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.
This article will help developers looking for a way to split delimited strings in a single query using 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
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
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
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
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