Technical Article

Delimited String Parsing and Evaluation Functions

Here's a quick and dirty function for parsing strings based on a delimiter (As in a varchar field with comma delimited text). I'm hoping for feedback on a more efficient means of doing this.Also,4 functions for comparing two delimited lists of strings. Many may ask why these are needed, but that's a very long explanation […]

You rated this post out of 5. Change rating

2005-09-21 (first published: )

255 reads

Technical Article

Utility proc for updating (sub) sequence columns

This is a utility proc that I use a lot for datawarehouse transformation/load processing. This is a generic proc for resequencing an integer column in sorted order within a given key combination.Note that 'key' is used here in a general context and not specific, that is there doesn't have to be any keys or indexes […]

You rated this post out of 5. Change rating

2004-10-12

82 reads

Technical Article

tighter approach to counting strings in strings

Saw Mike's routine for counting occurences of a string in a string and I thought I'd offer a simpler solution.Simply replace the occurence with null and use length differences as shown.NOTE: len may ignore trailing spaces, so this can be made more solid by adding some non printable char (less likely to interfere with operation) […]

You rated this post out of 5. Change rating

2004-03-10

67 reads

Blogs

SQL Saturday NYC Recap 2025

By

My first time at SQL Saturday New York City was an absolute blast! Thank...

SSMS 21

By

Just a quick one this morning. I’m on the road and haven’t worked up...

Why Data Silos Hurt Your Business Performance

By

Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...

Read the latest Blogs

Forums

Problem creating a Linked Server to MS Access 97 database from SQL Server 2019

By Weegee71

Hi there I need help on creating a Linked Server to an MS Access...

SSPI handshake failed error code 0x80090311

By jamesstirling01

Hi, I have a workstation with SQL Express 2019 installed and I have a...

Need query help - MAX record

By jmerlau

Hello - I have attached a Word document here with details about my issue....

Visit the forum

Question of the Day

Removing Log Shipping

If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?

See possible answers