To Joe's point:  I think Jeff's documentation is an excellent example of my point.  When the user decides that

SvcTypeID IN (1,2,3,5,1801)

doesn't mean 

WHERE SvcTypeID IN (1, --Standalone Long Distance

                    2, --800...

Seeing as the majority seems to prefer commented code, I'd be interested to see how you would document code (presumably SQL) that you've written or maintained.  Maybe once I see...

Jeff,

People are against simple embedded documentation for at least two reasons.  First, comments tend to state the obvious.  So if you establish a standard that requires comments, you get things...

Colin,

Thanks for the response. I don't blame you for not looking at the query, I only posted it because when I don't, I get a response telling me to post...

Wow, that's interesting about the JOIN. 

I can't tell you about the execution plan yet.  Two and a half hours later, it's still running.

Mattie

Mallik,

I've never run into this particular problem, but in the past when questions like this have been posted, responders suggested a phenomenon called 'parameter sniffing'.  Search this site using those...

Well, I've come up with a set-based solution. 

What inspired this was Sergiy's post that made me realize I could have a rownumber independent from the assigned random number in the permanent...

Vasc,

I had that discussion.  I lost.

I'm not sure that your solution won't work for more than one run, because my process only brings over the rows without an assignment date. ...

Tim,

It's to populate a jury selection pool.  I have a table full of licensed drivers (RandomEvents), and we need a random selection.  So once and only once, I need to...

Vasc,

Thank you for the time you've taken on this.  I've tried to take your logic, but I'm having trouble with the variable @Cycles.  In the formula,

SET @Cycles =...

First of all, I want to thank everyone who took time to look at this issue.  I'm truly impressed at how you all can even attempt to come up with...

Tim,

Do you expect a lot of failed updates? Do you need to do them as a series of individual transactions?

No, I expect no failed updates. 

I think I need...

Well, it's a dumb mistake, but not that dumb.

I just included the definition of @RandomUID table in case there was something in...

Why don't you want it to be a Sony?

Mattie

Our technical people who know way more about this than I do have told me not to run a DTS package on a machine being accessed by Remote Desktop.  Unlike...