Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Divya Agrawal

SQLServerCentral.com profile

   Items 1 to 9 of 9   
 

SSIS Package documentor

Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.   Read more...
Rating: |  Discuss |   Briefcase | 9,228 reads

Finding the Correct Weekday Regardless of DateFirst

In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.  Read more...
By Divya Agrawal 2010/02/19 | Source: SQLServerCentral.com | Category: datefirst
Rating: |  Discuss |   Briefcase | 6,741 reads

Problem with scripting objects through query

This article from Divya Agrawal might help you to overcome the problem when multiple objects or statements are scripted together. This is technique that can eliminate errors from scripts built dynamically.  Read more...
By Divya Agrawal 2009/10/30 | Source: SQLServerCentral.com | Category: incorrect syntax near go
Rating: |  Discuss |   Briefcase | 1,917 reads

Compatibility issue and CROSS APPLY

This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY  Read more...
By Divya Agrawal 2009/08/06 | Source: SQLServerCentral.com | Category: cross apply
Rating: |  Discuss |   Briefcase | 5,110 reads

Split string using XML

Learn how you can split a delimited string in a single query using XML with Divya Agrawal.  Read more...
By Divya Agrawal 2009/06/25 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 11,209 reads

Execute SQL job through batch file

This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file.  Read more...
By Divya Agrawal 2009/06/05 | Source: SQLServerCentral.com | Category: agent jobs
Rating: |  Discuss |   Briefcase | 15,690 reads

Swap column values

Interchange column values using a single update query  Read more...
By Divya Agrawal 2009/05/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,032 reads

Calculate the Running Total for the last five Transactions

Calculate the Running Total for the last five Transactions on an Iterative basis  Read more...
By Divya Agrawal 2008/11/27 | Source: SQLServerCentral.com | Category: iterative
Rating: |  Discuss |   Briefcase | 4,375 reads

Compare Dates in an iterative manner for a particular set of records

Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000  Read more...
By Divya Agrawal 2008/11/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,711 reads
   Items 1 to 9 of 9