Comments for SQL Disco

Comment on Datetime expressions in Reporting Services by Sam

Sam — Wed, 25 Aug 2010 16:57:42 +0000

Perfect!! Exactly what I needed. Dates have been killing me!

Comment on Creating a “last day of month” schedule in reporting services by Andreas

Andreas — Tue, 06 Jul 2010 10:37:15 +0000

What you need to do is write down the ScheduleID from the query above. This is the ID of the Shared Schedule that you set up as a run-once schedule.

Then go to SQL Server agent and open any job that is associated with any subscription. It will be a stored procedure with an ID as a parameter. Then make a new sql server agent job with the same syntax as the other subscription jobs, but this time use the ID from the run-once schedule as the parameter, and set the (sql server agent) Schedule to last day of month. Hope this clears things up!

Comment on Grouping datetime by date in T-SQL by Ryan Hennig

Ryan Hennig — Fri, 11 Jun 2010 04:08:27 +0000

I had a similar situation at work, where I needed to group by intervals of 10 minutes. I wrote a handy UDF to do this which can bucket datetime into any interval of minutes. You could use like this:

SELECT dbo.BucketDateTime(GETDATE(), 60 * 24)

The implementation is on my blog:
http://ryancoder.blogspot.com/2010/06/bucket-datetimes-in-t-sql.html

Comment on Grouping datetime by date in T-SQL by James

James — Wed, 26 May 2010 23:58:44 +0000

Great thanks mate. this made my day

Comment on Creating a “last day of month” schedule in reporting services by brian lanehart

brian lanehart — Mon, 17 May 2010 20:40:24 +0000

do you mind providing a little more information? i see what you are saying overall – create a custom schedule in sql server agent and associate that with the manually created ssrs schedule that you ran once. i’m a little confused on which id’s you are copying from where to where though.

thanks!
brian

Comment on Migration from SSRS 2005 to 2008 by burton

burton — Thu, 15 Apr 2010 23:59:59 +0000

thanks for this post. it saved our butt doing our TFS 2010 install!

Comment on Grouping datetime by date in T-SQL by Joaquim Félix

Joaquim Félix — Fri, 08 Jan 2010 14:19:45 +0000

This example was great. I have been a Oracle (and PL/SQL) developer for last 9 years and now I’m struggling my way inside SQL Server (and T-SQL).
Your post was, and is, a tremendous help.
Thank You.

Comment on Grouping datetime by date in T-SQL by Phil Karras

Phil Karras — Tue, 02 Dec 2008 16:57:34 +0000

I’m sure there were many others like me who searched, found, & used your ideas to get a job done but then never said thanks.

Thanks!

Now I need to count how many values have been added to another field on a given date, I don’t care what the values are as long as they are not NULL.

Comment on Grouping datetime by date in T-SQL by Matt

Matt — Tue, 04 Nov 2008 20:35:42 +0000

Thanks very much! Works like a charm.

Comment on Grouping datetime by date in T-SQL by maatthias

maatthias — Thu, 11 Sep 2008 18:14:59 +0000

That first query is very clever. Thanks for this.