Ok... let's do this... here's the original data... mark each zero row with the rownum from where it's supposed to get it's data. If you leave any at zero,...

There's air?

Hey MATT! Congrats on becoming a proud member of the over 5k crowd!

I think this might do it...

SELECT hi.Date,

hi.Area,

CASE WHEN hi.Amount = 0 THEN ISNULL(lo.Amount,0)...

Dang... thanks, Chirag... I keep forgeting this is a 2k5 forum. 🙂

Yeah, but what does the OP want to do with it? 🙂

Holy Moly, Mike... I thought I had it bad and the current job...

Folks, please... go back and look at the original post... the queries are identical except for the IF and the WHERE... just move the IF to the WHERE and be...

Heh… you know me… I love the Tally table my own self! But, as I've said many times, the Tally table is NOT a panacea.

Consider this… in your example,...

I didn't forget ya... I just had a really long day and haven't been able to do the necessary writeup along with the code. I'll finish this when I...

I didn't forget ya... I just had a really long day and haven't been able to do the necessary writeup along with the code. I'll finish this when I...

GilaMonster (9/23/2008)

---

On a fairly active server I used to work with, on SQL 2000 we were writing a 200MB C2 file about every 15 min. After we upgraded to 2005,...

Roy Ernest (9/23/2008)

---

Why not use the profiler with sp:StmtStarting and sp:StmtCompleted in Stored Procedures Events / TSQL SQL:StmtStarting and SQL:StmtComplted for that particular Job to get the details instead of...

Thanks for the feedback, Roger. Heh... you're going to learn to love UniqueIdentifiers about as much as you'll learn to hate them. I love them because they're guaranteed...

foursaints (9/12/2008)

---

There have already been a couple replies on this so I won't belabor too much, but you definitely can create a PK on a table variable, you just can't...