SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Pivoting Rss

   Items 1 to 2 of 2   
 

An Easier Way of Pivoting Data in SQL Server

There are several methods to pivot, or transpose, data in T-SQL, but most are difficult to understand and write. Phil Factor demonstrates how to take advantage of JSON support, introduced with SQL Server 2016, to create a function that makes pivoting data simple.  Read more...
By 2018/02/16 | Source: SimpleTalk | Category: pivoting
Rating:  Rate this |   Briefcase | 7,153 reads

SQL Server T-SQL Tuning -TVF and Scalar Functions

A UDF is very convenient for centralising business logic as we can specify a set of business logic in one UDF which references multiple stored procedures and ad-hoc queries. However, they can lead to significant performance degradation due to their demands on the CPU  Read more...
By Additional Articles 2016/03/04 | Category: pivoting
Rating:  Rate this |   Briefcase | 4,802 reads
   Items 1 to 2 of 2   
 
Tags
json (1)    
sql server 2016 (1)