Viewing 15 posts - 31 through 45 (of 87 total)
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...
September 6, 2006 at 2:27 pm
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]...
September 5, 2006 at 2:18 pm
....just putting this one back to the top...anyone have any examples of their own method for this?....Thanks.
March 9, 2006 at 11:23 am
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?
March 6, 2006 at 8:25 pm
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...
February 9, 2006 at 11:51 am
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,...
February 7, 2006 at 4:50 pm
also, there are only about 15 rows in FinancialCategories. Maybe I should just put it in a function?
February 7, 2006 at 4:01 pm
You're right. I just had some bad test data in there. Duh...Thanks guys.
February 7, 2006 at 3:27 pm
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...
June 30, 2005 at 7:43 am
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
June 29, 2005 at 4:09 pm
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,...
June 29, 2005 at 3:34 pm
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...
June 3, 2005 at 1:56 pm
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'...
June 2, 2005 at 10:06 am
WOW ! Thanks for the quick reply Noel ! That did it. Your help is always great.
-Pat
May 20, 2005 at 3:02 pm
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 " & _
...
May 18, 2005 at 2:33 pm
Viewing 15 posts - 31 through 45 (of 87 total)