Viewing 9 posts - 1 through 9 (of 9 total)
Thanks everybody!! that really helped . 🙂
October 3, 2012 at 5:02 am
Thanks SSC Eights!
Your query works perfect.
Big thanks to all for your precious time!
Regards,
Asrar
October 1, 2012 at 5:10 am
@SSC Veteran. Yes,the ranking is out of line. let me try the other one. But big thanks to all 🙂
October 1, 2012 at 4:47 am
Thanks Siva!! Hope this fits best 🙂 🙂
October 1, 2012 at 4:30 am
The second one 🙂 . I at least need them once.
October 1, 2012 at 4:25 am
Thank for the help Mike01. i was not aware of this.:-)
April 12, 2012 at 6:52 am
Thanks very much..:-)
i came up is quite huge
declare @start_day_week date
declare @End_Day_week date
if(dateadd(WEEK,0,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))<GETDATE() and dateadd(WEEK,1,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))-1>GETDATE())
begin
select @start_day_week =dateadd(WEEK,0,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))
select @End_Day_week=dateadd(WEEK,1,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))-1
end
else
if(dateadd(WEEK,1,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))<GETDATE() and dateadd(WEEK,2,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))-1>GETDATE())
begin
select @start_day_week =dateadd(WEEK,1,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))
select @End_Day_week=dateadd(WEEK,2,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))-1
end
else
if(dateadd(WEEK,2,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))<GETDATE() and dateadd(WEEK,3,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))-1>GETDATE())
begin
select @start_day_week =dateadd(WEEK,2,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))
select @End_Day_week=dateadd(WEEK,3,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))-1
end
else
if(dateadd(WEEK,3,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))<GETDATE() and dateadd(WEEK,4,DATEADD(MOnth,DATEDIFF(month,'1990',GETDATE()),'1990'))-1>GETDATE())
begin
select...
April 12, 2012 at 6:50 am
In my case deleting and deploying the same on report server fixed the issue.:-)
Try it!!
-Syed
February 1, 2012 at 5:18 am
The only way i see is, script it to create or alter and then debug. 😉
September 29, 2011 at 11:06 am
Viewing 9 posts - 1 through 9 (of 9 total)