July 2008 - Posts

0
Comments

Exporting gridview to Excel by bunbun

Having the ability to export data to Excel is a nice little feature to have as it seems envitable that users will ask for it at some point in time. Crystal reports and SQL Server Reports give you that option but it's not too difficult to write some code...
Filed under:
0
Comments

Common Table Expressions (CTE) by bunbun

Discovered the power of common table expressions today. I needed to create an hierarchy of GL accounts. My table was an adjancey list which made the CTE very easy. CTEs are new to SQL Server 2005. WITH AccountHierarchy ( account_cat_id , description ...
Filed under:
More Posts