Never argue with an idiot!

The script does not work. You can't argue with that!

FWIW:

(Sorry - couldn't work out how to format it nicely...)

[font="System"]

SELECT REPLACE(RTRIM(ISNULL(BODDS+' ','')+ISNULL(CTDDS+' ','')+ISNULL(NHDDS,'')),' ',',') AS DDS

,ISNULL(BOCLEARED,0)+ISNULL(CTCLEARED,0)+ISNULL(NHCLEARED,0) AS TotalCleared

,COALESCE(BOCLEAREDDATE,CTCLEAREDDATE,NHCLEAREDDATE) AS ClearedDate FROM BO

FULL OUTER JOIN CT ON BOCLEAREDDATE=CTCLEAREDDATE

FULL OUTER JOIN...

Hi,

Sorry if I'm locking the stable door after the horse has bolted, but have you checked out this article on "Parameter Sniffing"?

http://omnibuzz-sql.blogspot.com/2006/11/parameter-sniffing-stored-procedures.html

I'm not defending the cursor, but wouldn't the proposed solution cause potential Tempdb locking problems?

I always create the temp table first, then INSERT into it to avoid such issues.

e.g.

--Create temp...