Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Divya Agrawal

SQLServerCentral.com profile

   Items 1 to 8 of 8   
 

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,647 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,903 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,062 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 | 10,943 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: jobs
Rating: |  Discuss |   Briefcase | 14,646 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,013 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,324 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,700 reads
   Items 1 to 8 of 8