Try it with this test data:

select '1' as ID,'Game1' AS Name

union all select '2' AS ID,'Game2' AS Name

union all select '3' AS ID,'Game4' AS Name

union all select '4' AS...

I originally designed this SetUpIntervals CTE to be able to SUM (or COUNT, etc.) values across a continuous date range. However it is easily adapted to the case where...

drew.allen (6/20/2012)

---

You can, but I find the CROSS APPLY simpler...

Drew hit the nail on the head. My bug, my bad!

But I can correct it without the CROSS APPLY!

;WITH CTE AS (

SELECT [Length], [Width], [Height]

...

Your understanding seems to be 100% on the money.

While I've known about VALUES sets for a long time in theory, I never really had a chance to play with them...

Marshy,

Today is your lucky day! Well maybe tomorrow as it is night time here now.

I have just the query for you but I need a description of something.

I'm assuming...

OK sports fans, I've now read through this entire thread and I'm now 90% the solution I posted before will work for the OP. I was a bit concerned...

For the record, I am a moron. ...

okbangas (6/20/2012)

---

That is one way of doing it yes, but there is really no need to attempt to insert a record, if you can do a simple test to check...

balaji_kethe (6/20/2012)

---

Thanks for your suggestions.

One thing i would like to add here is, the stored procedure returning the tabular data sets is locked and i don't have access to read/alter...

Someone will probably shoot me for suggesting this but:

1. Instead of SELECTing your results out of the SP, SELECT ... FOR XML into an XML variable.

2. Do the same with...

Here's the results applying the COLLATION fix to the REPLACE in PARSENAME. It still doesn't touch SUBSTRING / CHARINDEX though (just a slight improvement).

PRINT '========== BASELINE ==========';

SET STATISTICS IO...

Cadavre (6/20/2012)

---

dwain.c (6/20/2012)

---

Nice one Cadavre!

That's the same collation issue that I was trying to address the other day when timing REPLACE on another thread.

Just one question though. Did Jeff...

If you're SELECTing from the results delivered by a CTE, any field listed on the ORDER BY must also be returned from the CTE, even if they're not part of...

Correct me if I'm wrong here but, in addition to forcing the isolation level, couldn't you just do something like this instead?

BEGIN TRY

insert into sometable...