Using SELECT INTO with UNION Statements

On occassion, I need to take a number of different result sets and combine them into a single output, which I then want to store in a temporary table. I've done this while developing solutions for business needs and when analyzing performance for different environments. Sometimes I just need to store stuff. What makes this … Continue reading Using SELECT INTO with UNION Statements

December AppDev Webcast

The new year is just around the corner.  And before you know it, we’ll have an opportunity to start moving SQL Server 2012 into production.  While we anxiously await that day, it is a good idea to make sure that you are up on the latest T-SQL enhancements that are coming in the next release.  … Continue reading December AppDev Webcast

T-SQL Tuesday #17 – APPLY Knowledge

It’s that time of the month again… again.  Time for T-SQL Tuesday!  This month’s event is being hosted by Matt Velic (Blog | @mvelic).  The topic that he chose for this month is the APPLY operator. This is a great topic.   I like it because, often, when I am presenting I ask the question, “who … Continue reading T-SQL Tuesday #17 – APPLY Knowledge

Aggregating With Correlated Sub-Queries #tsql2sday

It’s that time of the month again.  Time for T-SQL Tuesday!  This month’s event is being hosted by Jes Schultz Borland (Blog|@grrl_geek).  The topic that she chose for this month is aggregates. The Dilemma A few months ago, a client I was working with had a dilemma with one of their search queries.  A query … Continue reading Aggregating With Correlated Sub-Queries #tsql2sday

XQuery for the Non-Expert – Aggregates

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In  the last post, I discussed using functions within XQuery with the Substring() function as part of the XQuery for the Non-Expert blog series.  To continue on that theme, this post is going to take a look into … Continue reading XQuery for the Non-Expert – Aggregates

XQuery for the Non-Expert – @Variable Use

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert blog series.  When working with the exist() method you may not always want to hardcode in the attribute values that you … Continue reading XQuery for the Non-Expert – @Variable Use

XQuery for the Non-Expert – Binary Values

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the value() method post of my XQuery for the Non-Expert series I discussed how to take element and attributes and return them as column values.  Those methods works all fine and dandy for most data but when … Continue reading XQuery for the Non-Expert – Binary Values