Jason,

Its working perfectly. Thanks a lot.:)

Really your help is very much useful for me. So once again My hearty thanks to you.:)

Jason,

I will check it and come back to you.:)

Jason,

Thanks a lot for your prompt reply.

Sure. I am using sql2000. I think your query will work in sql2005 only.

Once again my hearty thanks to you.

Jeff,

Thanks a lot for your help!

I have purified one more time.

DECLARE @DateStart DATETIME

DECLARE @DateEnd DATETIME

SELECT @DateStart = '07/Apr/2008', @DateEnd = '29/Dec/2008'

SELECT Month = convert(varchar,DatePart(MM,DATEADD(mm,N-1,@DateStart))),

...

Jeff,

I have refined the above code as

DECLARE @DateStart DATETIME

DECLARE @DateEnd DATETIME

SELECT @DateStart = '04/Apr/2007', @DateEnd = '29/Apr/2008'

SELECT convert(Datetime,'01'+'/'+convert(varchar,DatePart(MM,DATEADD(mm,N-1,@DateStart)))+'/'+convert(varchar,DatePart(YY,DATEADD(mm,N-1,@DateStart))),103),

DateAdd(DD,-1,convert(Datetime,'01'+'/'+convert(varchar,DatePart(MM,DATEADD(mm,N,@DateStart)))+'/'+convert(varchar,DatePart(YY,DATEADD(mm,N,@DateStart))),103))

FROM dbo.Tally

where DateAdd(DD,-1,convert(Datetime,'01'+'/'+convert(varchar,DatePart(MM,DATEADD(mm,N,@DateStart)))+'/'+convert(varchar,DatePart(YY,DATEADD(mm,N,@DateStart))),103)) <= @DateEnd

I got the below output:

Apr ...

Jeff,

DECLARE @DateStart DATETIME

DECLARE @DateEnd DATETIME

SELECT @DateStart = '04/Apr/2007', @DateEnd = '29/Apr/2008'

SELECT convert(Datetime,'01'+'/'+convert(varchar,DatePart(MM,DATEADD(mm,N-1,@DateStart)))+'/'+convert(varchar,DatePart(YY,DATEADD(mm,N-1,@DateStart))),103),

DateAdd(DD,-1,convert(Datetime,'01'+'/'+convert(varchar,DatePart(MM,DATEADD(mm,N,@DateStart)))+'/'+convert(varchar,DatePart(YY,DATEADD(mm,N,@DateStart))),103))

FROM dbo.Tally

Above code is working fine. But it is running like a car without break:). Yes,It...

i have executed the below statements.

select dateadd(mm,0,0)

select dateadd(mm,0,-1)

I got the following error.

Function DATEADD invoked with wrong number or type of argument(s).

select datediff (yy, "1984", 0)

Function DATEDIFF invoked with wrong number...

Jason,

I want to generate the last date for each month.

Select @year = min(Year)

From PRREQ

...

Jeff,

It is not working. I got the below error message.

Function DATEDIFF invoked with wrong number or type of argument(s).

But when i execute it seperately like

select DATEDIFF(MM,'01/apr/2007','01/apr/2008')

its showing 12.

Please help...

Just i tried to ask explanation for the above one.

I do agree with you. I made mistake.

User will pass a value for @abc,Say forexample @abc...

@abc is Varchar.

Jason,

My requirement is:

If @abc = '' or @abc = -1 then i want to assign NULL value to @abc.

But i am using sql2000.

I am also thought to use WHILE LOOP.

Adrian, do you think is there any performance wise difference between using CURSOR and WHILE loop ?

Please share your thoughts.

50000 rows.

10-15