Regarding select Date
-
Hi, I am having a problem.Actually what i want is to find the Dates between particluar Dates like how many dates between two dates.For this i dont have any table.Then after i want to store this resultset in the Temporary Table. i have done lots of RNd but didn't get the ans. Thanks in Advance Avesh
-
Hi, I am having a problem.Actually what i want is to find the Dates between particluar Dates like how many dates between two dates.For this i dont have any table.Then after i want to store this resultset in the Temporary Table. i have done lots of RNd but didn't get the ans. Thanks in Advance Avesh
hi you have to give the values for from date and todate while @fromdate<=@todate begin insert into #Temp(fdate) values(@fromdate) set @fromdate=dateadd(day,1,@fromdate) end Regards Joe