SQL Server 2012 IIF Statement
SQL Server 2012 introduces the IIF statement. It is very similar to the IIF statement in MS Access. I have extracted the IIF part of… Read More »SQL Server 2012 IIF Statement
TSQL
Cannot resolve the collation conflict
One possible cause of the “Cannot resolve the collation conflict” error message is that your database collation doesn’t match the TempDB Collation. Recommendation It is… Read More »Cannot resolve the collation conflict
TSQL 2012 – Generating letters with a SEQUENCE object
As shown in my previous posting on SEQUENCES, they are a user-defined object that generates a sequence of numeric values in Transact SQL 2012. But what… Read More »TSQL 2012 – Generating letters with a SEQUENCE object
TSQL Rounding or Truncating DateTime to Nearest Day, Hour, Minute or Second
One thing that I end up having to look search on regularly is rounding of dates and times in Transact SQL, having looked this up… Read More »TSQL Rounding or Truncating DateTime to Nearest Day, Hour, Minute or Second
Adventureworks2012 data to Google GeoChart Visualization
There are so many cool tools available today for data visualization. This posting covers pulling data from the AdventureWorks2012 database running on SQL Server… Read More »Adventureworks2012 data to Google GeoChart Visualization
Added a TSQL Wiki
Today I created a TSQL Wiki. There is not much there yet, but over time it will grow. The wiki address is: http://tsql.SteveStedman.com
TSQL Pivot Table
TSQL Pivot Table? Whats that? Here is a quick sample of how to implement a pivot table in TSQL for SQL Server. The example below… Read More »TSQL Pivot Table
Home after Seattle (Redmond) Code Camp 2012
What a great day at Code Camp today. Click here to download the slides and sample code from the presentations. The first presentation that I… Read More »Home after Seattle (Redmond) Code Camp 2012
Code Camp in Redmond Today
I am headed to Code Camp in Redmond WA today. I ended up with 3 sessions that I will be presenting, and I am really looking forward… Read More »Code Camp in Redmond Today
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… Read More »TSQL 2012 CHOOSE Function