Believe me, Me neither

But then again this is about you not Remi

Yes I am but still  If you make it a big deal then a big deal will turn and then I got curious...

Easy: you got curious once to know where I lived, what is the big deal to know where you DO ? there was even a forum post about this...

Falls Church, Virginia, USA

That is definitely NOT a guess

If the number of dots in the column is less than or equal to 3 then use my solution else use David Burro's

from here

I don't even remember but if you said so I believe you and ... you're welcome!?

[EDITED] I fixed the spelling... not a good...

Well, most of the time I DO

So sushila, where are you AGAIN?

-- get colnames

Select @str= case when sum(dtName.Col1) <> 0 then 'Col1' else '' end +

case when sum(dtName.Col2) <> 0 then ',Col2' else '' end +

case when sum(dtName.Col3) <> 0 then...

Remis Calendar solution is the correct way!

But just for the fun of it you can always use the numbers( or sequence, like others call it) table

select Dateadd(d,n,@startdate) Dte

from numbers...

NY.

Still trying to figure out where sushila works though

Who the %?(&?%$ figured that technic out and how much time did it take him????????????

Self

To be fair the bits and pieces...

BTW I was actually serious about the junior DBA position

Don't worry I am pretty sure you will do well. If something comes up I'll let you know