Any news on fixing the spam issue as yet? Every post apart from 1 on the "Active Threads" page just now was a spam post for the same telephone number....

COALESCE is a shorthand CASE expression, and a CASE expression uses data type precedence to determine the data type for the returned value. With column names like VendorName and...

Can you use FORMAT? I have only ever used it in ad-hoc queries to make numbers easier to read, and I can't vouch for its performance, but it seems...

Any chance you can convert that multiline scalar function to an inline table value function? Multi-line scalar functions can perform poorly, and your function has a WHILE inside it, which...

Adding a PK to the table, based on the procedure's name, probably make sense anyway. This stops the unlikely scenario of 2 people starting the process almost simultaneously and when...

One method would be to use DelimitedSplit8K_LEAD , which returns the ordinal position of the string, and then you can easily get the Nth value:

SELECT *
FROM...

This wasn't a suggestion; changing columns that don't allow NULL values to...

Honestly, adding a new column to be a primary key candidate (such as an a column with the IDENTITY property) is the easy part here. Cleaning up the duplicate rows...

Adding a new column that's a Primary key isn't going to stop those duplicate rows anyway; to stop that you likely need to also implement a UNIQUE INDEX. As for...

Any one got any ideas why the discussion post for today's article, Can We Please Stop Sending Passwords Over the Wire?, has been marked as "spam"?

Apart from none of that will work on Windows 10, Rachel; SQL Server 2000 cannot be run on Windows 10. Windows 10 wasn't even a glint in Microsoft's eye when...

SSC isn't the only site that has been receiving this kind of spam recently. I'm aware of at least 2 other sites that have suffered "Customer Service Number" spam posts...

So a lot of folks have written articles where no one has posted to the discussions in well over a year.  If someone reads and article and has a...

I feel like that list is proof that Grant and Jeff are the same person, as they have exactly the same amount of subscriptions.

It doesn't seem odd at all that you can't iterate through an undefined list of variables to me, if I'm honest. Scalar variables are defined as being individual values; they...