Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  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

Critical Challenges of ESI & Email Retention
Are you storing too much electronic information? Get expert legal advice and better understanding of what you are required to do as an IT professional.

Become a fan of Windows IT Pro on Facebook!
Join us on Facebook and be a fan of Windows IT Pro!

Sustainable Compliance: Are You Having a Resource Crisis?
Read this white paper to examine trends in compliance and security management and review approaches to reducing the cost and operational burden of compliance.

Rev Up Your IT Know-How with Our Recharged Magazine!
The improved Windows IT Pro provides trusted IT content with an enhanced new look and functionality! Get comprehensive coverage of industry topics, expert advice, and real-world solutions—PLUS access to over 10,000 articles online. Order today!

Get It All with Windows IT Pro VIP
Stock your IT toolbox with every solution ever printed in Windows IT Pro and SQL Server Magazine plus bonus Web-exclusive content on hot topics. Subscribe to receive the VIP CD and a subscription to your choice of Windows IT Pro or SQL Server Magazine!



Order Your Fundamentals CD Today!
Gain an introduction to Exchange, learn server security requirements, and understand how unified communications can play a role in your messaging strategies with this free Exchange CD.
Windows IT Pro Home Register About Us Affiliates / Licensing Media Kit Contact Us/Customer Service  
SQL Connected Home IT Library SuperSite FAQ Wininfo News
Europe Edition Office & SharePoint Pro Windows Dev Pro Windows Excavator 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing