Concatenate rows in a SQL table into a string

Concatenate rows in a SQL table into a string

Occasionally you may need to join the results of a query into a single string. You need to go from this: To this: At first this may seem challenging, but it’s actually relatively simple. Example script Transact-SQL CREATE TABLE #TestData (Data int) INSERT INTO...
Use randomized data to increase a test data set

Use randomized data to increase a test data set

Recently I was tasked with evaluating several possible solutions for a SQL Server search engine to search a database of students. For a proof of concept, I had a small snapshot of approximately 200,000 students. I needed to expand this data to simulate a much larger...