tag:blogger.com,1999:blog-3581668942031605287.post2961441678523545098..comments2024-02-25T09:48:50.287+00:00Comments on Reporting Services Tips n Tricks: Subscriptions SQL queryabshttp://www.blogger.com/profile/08183235261376957091noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-3581668942031605287.post-35829821902097790332012-05-22T23:52:12.736+01:002012-05-22T23:52:12.736+01:00Thanks, I didn't know you could do this, great...Thanks, I didn't know you could do this, great tip. :-)abshttps://www.blogger.com/profile/08183235261376957091noreply@blogger.comtag:blogger.com,1999:blog-3581668942031605287.post-31471171758947592062012-05-09T20:36:29.156+01:002012-05-09T20:36:29.156+01:00Hey,
Thanks for this. Thought I'd share this ...Hey,<br /><br />Thanks for this. Thought I'd share this bitwise function to avoid larger case statements.<br /><br /> SELECT<br /> A.DaysOfWeek<br /> , A.DaysOfWeek & 1 As 'Sunday' <br /> , A.DaysOfWeek & 2 As 'Monday'<br /> , A.DaysOfWeek & 4 As 'Tuesday'<br /> , A.DaysOfWeek & 8 As 'Wednesday'<br /> , A.DaysOfWeek & 16 As 'Thursday'<br /> , A.DaysOfWeek & 32 As 'Friday'<br /> , A.DaysOfWeek & 64 As 'Saturday'<br /> FROM [ReportServer].[dbo].[Schedule] ARickhttps://www.blogger.com/profile/14393260539429401443noreply@blogger.comtag:blogger.com,1999:blog-3581668942031605287.post-24894427823833760142012-01-06T11:24:56.521+00:002012-01-06T11:24:56.521+00:00Hi, I found all this info on the internet and post...Hi, I found all this info on the internet and posted it on my blog so wouldn't have to search for it every time I wanted to look at it.<br />For the report that you have scheduled for the 1st of May I would check the description of the schedule in report manager first and then look at your query. The query above doesn't account for everything its just a starter.abshttps://www.blogger.com/profile/08183235261376957091noreply@blogger.comtag:blogger.com,1999:blog-3581668942031605287.post-54214375743030171202012-01-03T16:48:33.412+00:002012-01-03T16:48:33.412+00:00Hi. Do you know where you found the details that ...Hi. Do you know where you found the details that allowed you to create this? I am trying to figure out why a scheduled report executed on 1/1/2012 when it's schdule is for the 1st of May. In this table, under "Month" it has 16, which would make sense if month was done based on 1,2,4,8,16 instead of 1,2,3,4,5.<br /><br />If you have any thoughts on the matter, I'd be interested to know. cmay AT walshgroup DOT comAnonymoushttps://www.blogger.com/profile/14810461908023193146noreply@blogger.com