http://www.windowsitpro.com/authors/author/author/5777598/rss/5777598en-USSun, 27 May 2012 07:35:51 GMTSun, 27 May 2012 07:35:51 GMThttp://www.windowsitpro.com/article/performance/inline-conditional-aggregation-one-for-allFor most simple aggregations, using GROUP BY with an aggregation function returns the information you need. Inline conditional aggregation uses CASE...END to return multiple aggregates from just one query.]]>Vikash K. AgarwalThu, 24 Jul 2003 00:00:00 GMThttp://www.windowsitpro.com/article/performance/inline-conditional-aggregation-one-for-allhttp://www.windowsitpro.com/article/tsql3/using-t-sql-to-generate-a-resultset-in-tree-formUse recursive stored procedures to generate a tree from a SQL Server table.]]>Vikash K. AgarwalWed, 21 Mar 2001 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/using-t-sql-to-generate-a-resultset-in-tree-formhttp://www.windowsitpro.com/article/tsql3/temporary-tables-local-vs-globalA comparison of local temporary tables and global temporary tables.]]>Vikash K. AgarwalWed, 21 Mar 2001 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/temporary-tables-local-vs-globalhttp://www.windowsitpro.com/article/internet/keep-database-schema-onlineBuild an ASP page that lets you access your database schema through the Internet.]]>Vikash K. AgarwalThu, 19 Oct 2000 00:00:00 GMThttp://www.windowsitpro.com/article/internet/keep-database-schema-online