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 address: vikash.agarwal@tallysolutions.com

4 results found for Vikash K. Agarwal, displaying items 1 - 4
August 2003

Inline Conditional Aggregation: One for All This article is only available to subscribers. Sign up now and get instant access!

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

April 2001

Using T-SQL to Generate a Resultset in Tree Form This article is only available to subscribers. Sign up now and get instant access!

Use recursive stored procedures to generate a tree from a SQL Server table.

SQL Server Magazine

April 2001

Temporary Tables: Local vs. Global This article is only available to subscribers. Sign up now and get instant access!

A comparison of local temporary tables and global temporary tables.

SQL Server Magazine

November 2000

Keep Database Schema Online This article is only available to subscribers. Sign up now and get instant access!

Build an ASP page that lets you access your database schema through the Internet.

SQL Server Magazine

Add these Headlines to your Website