Thanks again.

But I already asked, can we do it without putting 1 to 31 hard coded?

Hi,

I followed each post on this thread immediatly after it posted. Sorry to say no post is deleted. If you are after him because uf some other issues then...

good one Andrew!!

Can it be done without writting [1] to [31]?

Oh wow, this is my thread. 😀

Let me get in here - I don't know why all people running behind one guy? It looks like some people are...

Good One

Thank you all

Mangal9i (3/6/2009)

Try this... I guess very easy to understand and modify as well 🙂

;WITH Mangal as

(

SELECT Dateadd(yy,datediff(yy,0,getdate())-4,0) Date --Start Date,5 years including current

UNION ALL

SELECT dateadd(dd,1,date)

FROM Mangal

WHERE...

No systables as well 🙁

And tables available don't have seqeunce numbers. They some id columns, but not perfect.

Very very limited access

I can't create anything on database, I don't have rights.

I guess my question was clear enough - at run time.