Splitting Delimited Strings Using XML in SQL Server
This article will help developers looking for a way to split delimited strings in a single query using XML.
Divya Agrawal's bio is coming soon...
Comparing Files from Different Folders Using SQL Server and XML
Sometimes there is a need to process files in a folder, but first you need to determine which files need to be processed compared to older files that have already been processed. There are several ways that this can be done, but in this tip I show you a w
Swap SQL Server column data due to inserting data into wrong columns
This article is for newbies who have just started their career in SQL development. Everyone might have faced this problem when importing or inserting data into tables when they accidentally put the data in the wrong columns. The first thought would be to
Different ways to execute a SQL Agent job
Every database person might have come across the situation of maintenance tasks such as backing up of databases, re-indexing tables and other such tasks. We often schedule jobs for such tasks, so that they execute as per the set schedule. But there is som
Calculate Running Totals Using SQL Server CROSS JOINs
One challenge you may be faced with is the need to create running totals for query output, whether it be a straight query or for a report. Doing calculations such as this in Excel are pretty straightforward, because each cell can have a different formula
Using CROSS JOIN queries to find records out of sequence
This topic is nothing new, but well worth revisiting for those who have not used CROSS JOINS. You may have faced a problem where you need to compare historical records for a particular set of records to ensure that records have been saved in the correct o