Technical Article

Parse String into Table

This script takes a string of up to 8000 characters with a single character delimtier and returns a table with each substring in its own row. A identity column is also returned so you can easily find the n'th item in the list.Script is similar to kmlakov's but doesn't require the item count and adds […]

You rated this post out of 5. Change rating

2006-02-21 (first published: )

1,251 reads

Blogs

SQL Server Wait Stats

By

Everything in SQL Server is waiting for something…this is by design. And most people...

FabCon 2025 Recap

By

Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...

Privacy Policy

By

We value your privacy. This policy explains what personal data we collect and why. What...

Read the latest Blogs

Forums

why cant i get rid of extra dataset

By stan

hi i never used shared datasets before in ssrs.   i created a dataset  called...

Distinct values using string_agg

By jagjitsingh

Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType"...

Refactoring a DELETE query using NOT EXISTS — need expert feedback

By abdalah.mehdoini

Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup...

Visit the forum

Question of the Day

Importing Flat Files

What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?

See possible answers