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
Tag: T-SQL
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
XQuery for the Non-Expert – Substring() Function
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. Within the value() and query() methods it is sometimes desirable to return a portion of a string. Similar to T-SQL, there is a substring function in XQuery that provides this functionality. In this XQuery for the Non-Expert post … Continue reading XQuery for the Non-Expert – Substring() Function
XQuery for the Non-Expert – Resources
Learning XQuery can be a pain. There are a lot of different uses for XML and different languages implement it in many different fashions. To help clear the air a bit, I wrote a number of posts on XQuery; which this post is a part of. Now that I’ve posted my initial posts on what … Continue reading XQuery for the Non-Expert – Resources
XQuery for the Non-Expert – Exist
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the previous post, I discussed the value() method as part of my XQuery for the Non-Expert series. This next post will deal with a topic similar to the exist() method – the determination of whether a element … Continue reading XQuery for the Non-Expert – Exist
Strate SQL 