Create and Populate a Date Dimension Table
Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes.
2013-02-04
791 reads
data mart
Merge, Metadata and the Data Mart ETL
Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.
2012-12-27
4,801 reads
Conditional Set-Based Processing: Moving Towards a Best Practice for ETL
When you need to insert a large set of data using T-SQL, what can you do? New author Melinda Sansone brings us a best practice when using T-SQL to load data for data marts, or warehouses.
2009-11-23
8,906 reads
RE: Query
How about something like this:___________________________________________________________declare @@counter integer declare @@appendsql varchar(1000) declare @@sql varchar(1000)set @@counter = 1 set @@sql = 'select 'WHILE @@counter < (select COUNT(distinct ID) from temp) BEGIN set @@appendsql = 'SUM(CASE ID WHEN ' + CAST(@@counter as varchar(1000)) + ' THEN value ELSE 0 END) as ID' + CAST(@@counter as varchar(1000)) + ',' set […]
2005-02-04
RE: Removing Identy using T-SQL
You cannot remove the identity property from a column. You can disable the property using SET IDENTITY INSERT.
2004-01-19
1 reads
2004-01-08
RE: Enjoying QOD
Thanks! There's a standings page that's half complete :). You can see it on the QOD homepage under Your Scorecard. Once there's enough points to really weigh people out there, I'll create a true standings page so people can see how they rank. The harder the question, the more points you get. Brian Knight bknight@sqlservercentral.com […]
2003-06-22
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers