David, Actually well put. I just am curious if what he wants to do is doable.

Also, how are the tables defined (please post the DDL for the tables)?

I recommend Professional SQL Server 2005 Integration Services published by Wrox.

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...