GitHub

Convert Rows to Columns and Columns to Rows without using Pivot Functions

sum(case when salary_component_type='salary' then val end )as salary, sum(case when salary_component_type='bonus' then val end )as bonus, sum(case when salary ...
Visual Studio Magazine

Returning JSON from SQL Server Queries

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...
TechRepublic

Comparing cursor vs. WHILE loop performance in SQL Server 2008

Comparing cursor vs. WHILE loop performance in SQL Server 2008 Your email has been sent Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option ...