You will still want to build the Date Dimension. I think you will find this any of Kimballs books as well, as well as an explaination as to why.

😎

Thanks! This just came in handy where I work!

😎

If you do a search of SSC, I am pretty sure you will find what you are looking for. I have seen several people either post scripts or links...

This is the function I had posted back during the war:

CREATE FUNCTION [dbo].[fn_BRound] (

@val decimal(38,20),

@pos int

)

RETURNS decimal(38,20)

as begin

declare...

Anyone check out the other threads that we had on this topic? I thought we had a solution to this somewhere in there with all the mud flying around.

What is the data type of the column containing moddatetime?

Times haven't changed, its just some people don't accept responsibilty for the their systems after hours. at my last company we had an on-call rotation with three individuals. ...

What I think the question was asking, is how do you change the password and run the script from the command line. Using -z, you are giving a new...

change this:

SET @bLookForChangedCUSIPs = 0

SELECTCOUNT(*) ChangedCUSIPs

FROMPerformance.dbo.gChangedCUSIPs

WHERECUSIPKey = @vchVAGK+@vchPAC

IF @@ROWCOUNT>0 SET @bLookForChangedCUSIPs = 1

to this:

set @bLookForChangedCUSIPs

select @bLookForChangedCUSIPs = 1 from Performance.dbo.gChangedCUSIPs WHERE CUSIPKey = @vchVAGK+@vchPAC

😎

You know, of course, as soon as they let you change to a bit field, that would be when they would want to add the value "2" to the system....

Last company I worked for kept saying the same thing about the propriatary system that supported the business from the time I started to the time I left in 2005....

Just me, but the only "small" data type I wouldn't use is smalldatetime. Why introduce a "Y2K" type issue by limiting your dates to January 1, 1900, through June...

Although I'd like to go to SQL Server 2008 when it comes out, and I may push for it in our DW project, but for our LOB apps, we've upgraded...

Would you please post the DDL for the both the source and destination tables?

😎

It may be the way your update is written. Could you post the code you are running for us to look at?

😎