Christopher Stobbs (1/23/2009)

---

Jeff I hope you Proud changed you code a bit and and still using Setbased.

Pumps on my machine 7secs

SELECT TOP 1000000

CASE

WHEN ROW_NUMBER() OVER(ORDER BY GETDATE()) %...

Piece of cake... no time to finish it, but you get the idea.

declare @x int, @r3 int, @r5 int

select @x = 1

select @r3 = 1

select @r5 = 1

while @x <=...

Assuming my numbers are right, you generated a set of over 480 million codes overnight (before dropping the H8 and 69s)??

I'd definitly not consider this slow by all means... and...

Steve Jones - Editor (1/22/2009)

---

All software does get procedural, though parallelism might get through some of that, and the interrupt/jumps to new parts as we wait for IO can also...

This is a quick and dirty way for the columns : SELECT *...

The script that create those objects. Reread the article again to see how to do it exactly.

The output should look something like this :

CREATE Table dbo.TableName (Col 1...

No need for shovels. Just have him dig a hole big enough for the body, then let a good sand storm will it backup, or use your hands in...

You don't seem to get "it"

We can't help you unless we see what you see EXACTLY.

That means we need a copy of the tables WITH data AND the queries and...

Also if you pick the datatype DATE if rs, it'll show a datetimepicker. So the date will be valid as a date. Now will it be valid...

Do you know what happens when you stare at a work break? You need to take a real break and start posting here for help :D.

Don't worry about it, I recentrly to lookup for somethign in bol and asked a question in here!!!

Talk about irony :D:w00t:

What??? almost 20 hours straight without anything posted here... there must be something wierd in the air today... or the work break has just stared :P.

Domagoj Orec (1/19/2009)

---

Ninja's_RGR'us (1/19/2009)

---

That wouldn't have been so funny if you hadn't repeated it twice in a row :D:w00t::P.

Been guilty myself of a few typos over the years... so no...

That wouldn't have been so funny if you hadn't repeated it twice in a row :D:w00t::P.

Been guilty myself of a few typos over the years... so no harm done :).

That's worth repiting Grant :w00t::D:hehe:.