Forum Replies Created

Viewing 15 posts - 31 through 45 (of 87 total)

  • RE: Cube summing/aggregating values incorrectly???

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

  • RE: Cube summing/aggregating values incorrectly???

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

  • RE: best method for populating a fact table in DTS?

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

  • RE: best method for populating a fact table in DTS?

    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?

  • RE: UPDATE Query taking hours to run in DTS Package???

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

  • RE: UPDATE Query taking hours to run in DTS Package???

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

  • RE: UPDATE Query taking hours to run in DTS Package???

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

  • RE: UDF T-SQL Help?

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

  • RE: Problem assigning val to a GV in ActX

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

  • RE: Problem assigning val to a GV in ActX

    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

     

  • RE: Problem assigning val to a GV in ActX

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

  • RE: Query Syntax Error

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

  • RE: Query Syntax Error

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

  • RE: CASE UPDATE Query

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

    -Pat

  • RE: format datetime field

    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 " & _

    ...

Viewing 15 posts - 31 through 45 (of 87 total)