Vikash K. Agarwal

Advanced Search

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
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
Use recursive stored procedures to generate a tree from a SQL Server table.
SQL Server Magazine

April 2001

Temporary Tables: Local vs. Global
A comparison of local temporary tables and global temporary tables.
SQL Server Magazine

November 2000

Keep Database Schema Online
Build an ASP page that lets you access your database schema through the Internet.
SQL Server Magazine

ADS BY GOOGLE

SPONSORED LINKS		FEATURED LINKS
Download Data Protection Manager 2007 Disaster recovery at a low cost Maximize speed, performance and reliablity of your PCs and servers—automatically! Speed Up Your PC! Try Diskeeper 2008 with InvisiTasking Free Now! Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business. Order Your Fundamentals CD Today! Register today for your in-depth copy of one of three Fundamental CDs on the following topics – Exchange, SQL, and SharePoint. Microsoft Learning Snack - Virtualization With Windows Server 2008 Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features. Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization.		Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization. Microsoft Learning Snack - Virtualization With Windows Server 2008 Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features. Empower Your Processes with PowerShell 201 Paul Robichaux delves deep into PowerShell how-tos in 3 informative lessons, each followed by live Q&A—all on your own computer! Register today! Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business. New Release: Windows IT Pro Master CD 13 years of content archives, fast answers with advanced search tools, and full access to WindowsITPro.com—order today!

Windows IT Pro Home

FAQ for Windows

WinInfo News
Europe Edition

About Us

Media Kit

Affiliates / Licensing

SQL Server Magazine

Office & SharePoint Pro

Windows Dev Pro

IT Job Hound

ITTV
IT Library

Technology Resource Directory

Connected Home

Windows Excavator

Windows SuperSite