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

Archives: December 2011

Dynamic Sorting in SSRS


Many times while developing any report we come across a situation where we need to SORT the TABLE columns or the columns in the GROUP dynamically. There are many well known ways to achieve this. However, here I will demonstrate a not-so-known way -



Assuming that the… Read more

8 comments, 18,867 reads

Posted in Juggling With SQL on 26 December 2011

How many times the T-SQL inside the CTE is executed?


Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that the t-sql written inside the CTE will be executed only once irrespective of the number of times it is referred in the subsequent CTEs or the related query.

Read more

12 comments, 9,091 reads

Posted in Juggling With SQL on 15 December 2011

Workarounds for SSRS 2008 Font rendering issue



A report developed using SSRS 2008 either through Visual Studio 2010 or BIDS 2008 does not renders properly when viewed in the Report Viewer 10.0 via Remote Desktop or any 3rd party applications using Terminal Services in the background.

Remote Rendering

Local Rendering


  1. Change the Screen Resolution…

Read more

5 comments, 5,583 reads

Posted in Juggling With SQL on 2 December 2011