This is a simple math problem, that does not require CTEs , recursion or iteration.

DECLARE @from_date DATE = '1-Oct-2020';
DECLARE @to_date DATE = '25-Oct-2020';

select 
@from_date as From_Date, 
@to_date...

Hi Michael

Nice work. If you want a reliable method of getting Disk volume info here is a sproc I have written for SQL 2005+.

USE [master]

GO

IF IS_SRVROLEMEMBER('sysadmin') = 0

...

Hi,

SMO is currently not supported in CLR extended stored procedures. If you try to construct an extended stored proc to call SMO and install it into SQL 2005,...

Yes, it took a bit of effort, but we have implemented a comprehensive set of stored procedures that can interact with our special SQL Agent jobs on the server. ...

Your approach will not work unless you have installed Integration Services on the same server as your ASP.NET webserver.

If you want to execute a SSIS package on the database server...

This is brilliant!

Writing repetitive code for the myriad of mundane tasks that are required when writing complex applications can be a barrier to getting the important functionality...

Hi Mike,

I can think of two possible approaches:

[1] Roll something similar to sp_help_job ...

use [msdb]

select

jb.[name],

ja.session_id,

STATUS_CD =

...