Well I did say it was in disguise. 🙂

Constant scans are quite fast.

Not fast enough when SS2K5 uses them...

Hi,

Several different solutions have been provided, all of which work - some even use EXISTS as you requested.

If you don't understand them, please try again. If you still don't...

Wellington,...

I know, it's a common thing. SS2K5 uses row-versioning internally...

That's true. My point was that if the validation code already existed in...

If it helps at all (calm things down a bit) - I'm quite happy with the label 😉

Everyone have a good day. It's wet and cold...

I quote "you owe me a new monitor!" :laugh:

Thank you RBarryYoung.

@bitbucket: Please note that Paul Neilsen and I are different people. There is a clue in my surname.

The example that springs to mind is where a...

RBarryYoung (4/19/2009)

---

Actually for something this small you don't even need that. This should work:

...

Select 1 as Month

Union All Select 2

...

Replacing the UPSERT with a DELETE then INSERT doesn't scale very well.

This is a demo of an alternative:

--DROP TABLE #Destination, #Staging

CREATE TABLE #Destination (a INT IDENTITY(1,1) PRIMARY KEY, Data VARCHAR(36)...

I know it's deprecated, but GROUP BY ALL would work here:

CREATE TABLE #t1 (a INT IDENTITY(1,1) PRIMARY KEY)

CREATE TABLE #t2 (a INT IDENTITY(5,1) PRIMARY KEY)

SET NOCOUNT ON

GO

INSERT #t1 DEFAULT VALUES;

INSERT...

Just a quick addition:

If you use DATEPART with weekday, make sure DATEFIRST is SET appropriately.

It is possible to write the comparison generically for any DATEFIRST by using @@DATEFIRST, but I...

Hi,

I'd like to help, but with the best will in the world: I can't make sense of your post.

Sorry - I know it's difficult if English isn't your first language.

Perhaps...

The answer is..."it depends!"

Sometimes, a cursor *is* the optimal solution. Not often, but it does happen.

If you tell us a little more background to your question, you may get...

Kalen wrote a good article for SQL Mag - but that's subscriber...