TSQL 2012 CHOOSE Function
In SQL Server 2012 there is a new function called CHOOSE that takes in an offset, and a list of options. Choose is a function that returns the item at a specific index. Syntax: CHOOSE(index, val_1, val_2, val_3, …) If …
In SQL Server 2012 there is a new function called CHOOSE that takes in an offset, and a list of options. Choose is a function that returns the item at a specific index. Syntax: CHOOSE(index, val_1, val_2, val_3, …) If …
SQL Saturday 166 in Olympia WA on November 10th was announced, and that one is close enough to drive to. I have submitted 2 sessions for this event. What’s New in TSQL 2012 By November, this with be the …
Here are the sessions that I will be presenting at Code Camp in two weeks.. What’s New in TSQL 2012 This is the first time that I will be presenting this one. Its going to be a lot of fun …
I learned today that several of the sessions that I pitched for Code Camp 2012 have been accepted. Code Camp will be on Saturday June 16th 2012 in Redmond WA. I am not sure why the call it Seattle …
I just signed up as a SQL Saturday sponsor. Here is the logo that I put together to use for the sponsorship link. Good thing my SQL skills are much stronger than my Photoshop skills.
Today I started the day early with a great presentation for the SQL Lunch UK group on Common Table Expressions. For those who attended the presentation here is the Zip file with the Powerpoint and the SQL code from the …
On May 8th at 4:30am (Lunchtime UK) I will be presenting my Unleashing Common Table Expressions in an online webcast type presentation. I am looking forward to it. I have tuned it up a bit since the last time I …
I am planning on visiting Salt Lake City for SQL Saturday in October. Exploring the TSQL Enhancements in SQL Server 2012 Unleashing Common Table Expressions in SQL Server Using SSRS reports to analyze SQL Server health
The question came up as to how do I parse a query string using TSQL. So here you go, using a common table expression, and basing this on a similar function to what I put together yesterday for split. which …
Using a CTE in a Function to Split Up a Query String Read more »
One of the common questions that comes up in my CTE class/presentation asks can you use the CTE inside of a function or stored procedure. The answer is yes, but today I came across another question, how can I split …