Search
InstantDoc ID
GO

Browse By: Author | Issue

Vikash K. Agarwal

Vikash K. Agarwal is a technology architect for Tally Solutions. He has almost 12 years of IT experience in various roles and specializes in system-design and programming with Microsoft Visual C++ and Win32. He is an MCSE and an MCDBA.
Email:vikash.agarwal@tallysolutions.com

My Latest Articles
My Latest Comments

Author Articles

July, 2003
Inline Conditional Aggregation: One for All
For 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.
SQL Server Magazine
March, 2001
Temporary Tables: Local vs. Global
A comparison of local temporary tables and global temporary tables.
SQL Server Magazine
March, 2001
Using T-SQL to Generate a Resultset in Tree Form
Use recursive stored procedures to generate a tree from a SQL Server table.
SQL Server Magazine
October, 2000
Keep Database Schema Online
Build an ASP page that lets you access your database schema through the Internet.
SQL Server Magazine
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.