hhmmm...actually I just ran

SELECT biz.LOB

, SUM(mem.membercount) AS membercount

, SUM(mem.remitamount) AS remitamount

,SUM(mem.RemitPartAB) AS remitpartab

, SUM(mem.RemitPartD) AS RemitPartD

FROM dbo.MemFact mem

INNER JOIN dbo.LOBDim biz ON mem.LOBKey = biz.LOBKey

GROUP BY dbo.LOBDim.LOB

and just...

Sorry it took me so long to reply. It is SQL 2000 and the field is nullable. Here's the DDL.

CREATE TABLE [dbo].[DateDim](

      [DateKey] [int] NOT NULL,

      [ActualDate]...

....just putting this one back to the top...anyone have any examples of their own method for this?....Thanks.

Thanks for the reply Jonathan ! That is a good site.

Would you happen to have a sample for populating the fact table with dimesnion surrogate keys in SQL?

Thanks for all the replies ! The Clustered Index def. speeds up the update, but it takes a long time to add the index to the table (all indexes are...

Thanks for the reply PW.

1.) Do you mean clustered index on FinancialLagCategories or Claimdata?

2.) It is running in Simple recovery mode.

3.) Interesting, there is no transformation mapped to that field,...

also, there are only about 15 rows in FinancialCategories. Maybe I should just put it in a function?

You're right. I just had some bad test data in there. Duh...Thanks guys.

Thanks so much guys ! All I needed to do was use the vbscript DateDiff Function and it worked just fine.

Function Main()

DTSGlobalVariables("RefreshEndDate").Value = Now()

DTSGlobalVariables("DurationInMins").Value = DateDiff("n", DTSGlobalVariables("RefreshStartDate").Value, DTSGlobalVariables("RefreshEndDate").Value)

MsgBox...

It checks out okay in QA, that's why I'm confused. Here are the values of the two variables:

DTSGlobalVariables("RefreshStartDate").Value = 6/27/2005 1:09:28 PM

DTSGlobalVariables("RefreshEndDate").Value = 6/29/2005 5:16:36 PM

Pat

I get the following error:

Error on Line 22

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

Line 22 is: objRs.Open CommandText,...

Thanks for all the replies ! I got the following to work:

SELECT DISTINCT [CheckNumbersWithClaims].pidate, Sum([CheckNumbersWithClaims].TopAmt1) AS SumOftopamt1, Count([CheckNumbersWithClaims].TopAmt1) AS CountOftopamt1,

CAST(SUM(CASE WHEN ([SvLOB]='HP' And [SvSrcX]='C') THEN topamt1 ELSE 0 END) as...

Thanks guys. This is originally an Access Query:

SELECT DISTINCTROW [CheckNumersWith Claims].pidate, Sum([CheckNumersWith Claims].TopAmt1) AS SumOftopamt1, Count([CheckNumersWith Claims].TopAmt1) AS CountOftopamt1, CCur(Sum(IIf(([SvLOB]='HP' And [SvSrcX]='M'),[topamt1],0))) AS HPMHS_topamt, CCur(Sum(IIf(([svLOB]='HP' And [svSrcX]='C'),[topamt1],0))) AS HPMCS_topamt, CCur(Sum(IIf(([svLOB]='SP'...

WOW ! Thanks for the quick reply Noel ! That did it. Your help is always great.

-Pat

Thanks so much for your help guys !

One more question. I'm converting an access database to SQL. I have the following query in Access:

UPDATE XDummyPaidMonth " & _

...