Date Dimensions in T-SQL using CTE
T-SQL Script for Time Dimension Table Data: Populates Data between two dates for Reporting Solutions.
2011-07-04 (first published: 2010-06-14)
3,747 reads
Bhudev Prakash
Listing Subscribed SSRS Reports including Parameters & their Values
This script will allow user to analysis their Subscribed Reports.
2010-02-01 (first published: 2010-01-11)
1,863 reads
Blogs
Daily Coping 24 Jan 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Introducing ScriptDOM
I’ve been meaning to get a series of blog posts started on this topic....
Daily Coping 21 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
How to delete records selected from another table in stored procedure
CREATE PROCEDURE usp_DeleteEmployeeRcord ( @days Int ) AS BEGIN DELETE [dbo].[EmpMainTable] Where created <...
Multiple dates
I am new to data warehouse schema and i learning about role-playing dimensions. i...
Ask SSC