Try changing:

+ 'Use ?

to

+ 'Use [?]

Several presenters at conferences do. They either have it set up as a dual-boot, or run it under a VM. However, it CANNOT be installed on the Mac OS -...

Don't forget: the rank() function requires every row to be evaluated in order to determine the rank for all records, and then I get the 1st one.

MIN just has to...

Craig,

Between each of our codes, put a "GO...

The logic that you're trying to use is very confusing to me, so I'll just show you how to get the next/prior record for a customer. Hopefully you can extract...

Is there a limit to the number of entries for a customer?

Sounds like you have different SIDs for the user.

In each database, run sp_change_users_login 'report' - this will show you all of the windows users that have different SIDS.

You might want...

Steve Jones - SSC Editor (11/1/2010)

---

No need to add it if you'll write it. I'm more looking for a place to keep track of holes that I find in the...

jamesniesewand (11/1/2010)

---

Good Lord - you people are the best 😎

I mean seriously - on almost any forum I can mention, this topic would have been closed at my request (or...

Craig Farrell (11/1/2010)

---

Well, every now and then I get lucky. :w00t: Honestly...

Stefan Krzywicki (11/1/2010)

---

I was torn about whether to post this question here or in the forums, but settled on the forums because it might help other people too. Still, it...

But... you could have a different problem.

If your job is scheduled to run, say, every 15 minutes. When it runs @ 1:45 (the first time), it gets set to run...

Thanks Jason - it's been added...

Turning down free help,...

Okay, I made a dataset with ten-million records (over 5000 products), then ran both code:

Test harness / code is attached (trouble posting again) below:

if OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE...