Heh... Thanks, Steve. I'm just surprised because it's such an old trick and it's posted everywhere. You would think...

Jonathan Kehayias (12/22/2008)

---

Every example out there is proprietary and the code can't be shared. Anyone else notice that? I would venture to say that a good consultant would...

Nah... you just got bit by the rounding with integers... try this...

DECLARE @StartDate DATETIME,

@EndDate DATETIME,

...

Kit Brandner (12/22/2008)

---

Yeah, it uses the RAND() function. Nothing too special, but I found set-based methods would hang when trying to generate 1000+ records. Perhaps my conclusion was a bit...

Straight-up numeric pin...

Thanks for the kudo, J. :blush:

Wait a minute! What are you calling a duplicate!? You mean to tell me that no other username can make an entry on that date for that sLevel?

The reason it takes so long is because you've not aggregated the data. Please see the following for how to do a proper cross tab...

[font="Arial Black"]http://www.sqlservercentral.com/articles/T-SQL/63681/[/font][/url]

Without some actual test...

In the previous post, you wrote ...

The select works to get me the counts. And the idea of the Tally table does make the selects more simplistic. I...

Comparing that to the original, it looks like all you were missing was the FROM clause.

Kit Brandner (12/22/2008)

---

Consider the one exception I've encountered - generating a variable number of PIN codes according to a proprietary algorithm. There are easily several set-based approaches, but they run...

Can you post what you ended up with, please? Thanks.

This is what Vladan is talking about...

--===== Move just the data we want to a place where we can work on it

SELECT ISNULL(Sal,0) AS Sal,

...

:hehe:

Like I said in the article... copy to a temp table and...