Actually started getting into computers in Junior High School. My grandfather had a medical lab and purchased an HP 9810 (actually just a BIG programmable calculator) to do the...

Actually, all we are asking is that you try to solve your problems first. If you are having difficulties, show us what you have done and we will gladly...

Just thought I'd add an update. In setting up the linked servers I found that I didn't need to enable Named Pipes on SQL Server 2005, the ODBC connection...

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

😎