Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag RECURSIVE Rss

   Items 1 to 2 of 2   
 

Convert a string list to TABLE with single CTE query

Converts a string list into a table using a single query, no variables and no helper functions.  Read more...
By Dimitris Staikos 2012/05/11 | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 2,169 reads

Display Complex Hierarchical Data with Server-Side Pagination

This article presents an approach to perform server-side pagination and display complex hierarchical data in Reporting Services.  Read more...
By Peichung Shih 2011/12/22 | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 7,450 reads
   Items 1 to 2 of 2   
 
Tags
cte (1)    
custom paging (1)    
hierarchyid (1)    
list (1)    
pagination (1)    
reporting services (ssrs) (1)    
server-side pagination (1)    
sql server 2008 r2 (1)