I wholeheartedly agree with Steve’s article.

I’ve interviewed a lot of people and came to this conclusion: they have 20 years of SQL Server experience almost always means that they haven’t...

What is going to be executing this stored procedure?  It first glance I thought you might have these lists generated by a multi-select parameter from SSRS, but judging by the...

TimCarrett (9/2/2016)

---

Shouldn't the code be:

SELECT TOP 5

SV.number AS Number

INTO #numbers

FROM master.dbo.spt_values SV

WHERE SV.type = 'P'

AND SV.number BETWEEN 1 AND @RegularRangeEnd

ORDER BY NEWID();

And

SELECT TOP 1

SV.number AS MegaNumber

INTO #mega_number

FROM master.dbo.spt_values SV

WHERE SV.type...

Okay, sorry, here is the correct version. I don't know how I managed to post the wrong one, but I did.

--========================================================================

-- To populate the Regular Range End,...

yeah, I know I posted the wrong version. Oh well. You get the idea.

Actually, if I recall correctly, this ended up being a permissions issue. The account running the SSIS package had read only access to the directory and so when you...

Maybe not. I guess I didn't know that one. But the overall point, as far as cursors go, is if you have a situation where you need to...

Someone earlier asked for an example of something that works best when using cursors and here is a script I have that I run when I need to make sure...

Thank you for writing this. I used to ask a cursor question when interviewing candidates and I got the same answer every time “you shouldn’t use cursors, they...

I've never posted before, so I hope this works, but this here is a small part of a stored proc that drives a report I have. The report shows...