Viewing 15 posts - 76 through 90 (of 131 total)
oh MAN! You've got separate cases for each column. Okay, feeling a bit dim today 🙂 Thank you so much.
August 8, 2011 at 11:02 am
You asked for it, it's icky!
SELECT
FactPeriodBalHist.FK_EntityKey,
FactPeriodBalHist.FK_AccountKey,
FactPeriodBalHist.FK_PayorKey,
FactPeriodBalHist.FK_PeriodDateKey,
DimPlan.ArAccount,
SUM(CASE WHEN datetime > dateadd(month, - 1, datetime) THEN balance ELSE 0 END) AS bal
FROM FactPeriodBalHist...
August 8, 2011 at 10:53 am
I'm even closer, but it's still putting the balance in one column. I need it to split it out into multiple columns.
so a row has a balance of 100$...
August 8, 2011 at 10:41 am
Lots of good advice:)
The biggest issue is it isn't in reports but in Dundas Dashboards and Perf Point Dashboard Designer. I haven't found a way to limit it in...
May 9, 2011 at 7:02 am
Hi,
I may be misunderstanding you, but the Adventureworks DW is a datawarehouse, not a cube. I'm not familiar with the AdventureWorks stuff, but I think there are probably install...
March 25, 2011 at 3:41 pm
Thanks Steve. I decided to play around with some stuff while I was waiting for an answer and realized a lot of the stuff that was baffling me before.
Started...
August 6, 2010 at 9:45 am
I made the mistake of migrating some data and views to a 2008 sql instance and just realized that I can't put a ssrs2008 report on a ssrs2005 server.
Let me...
April 2, 2010 at 12:11 pm
that's exactly what Iw as looking for, thanks so much!
March 24, 2010 at 2:16 pm
Quan Phan (12/9/2009)
So we can try using INNER JOIN instead of LEFT JOIN for the NonAdmitReason table.
adding the inner join takes me back to my original result of only showing...
December 10, 2009 at 7:42 am
That's definitely closer, it gives me one row with a count of zero for each of the choices in the NonAdmitReason table plus a row for each NonAdmitReason that is...
December 9, 2009 at 7:56 am
I thought of that, but no, still same thing. Even tried switching it and using/not using full outer joins, no dice.
SELECT ISNULL(COUNT(refTrkNonAdmitReason.description), 0) AS count,...
December 8, 2009 at 1:30 pm
just for that one table I want to pull all the values for, or in place of all of the left outer joins?
December 8, 2009 at 11:48 am
Here is the query:
SELECT COUNT(refTrkVisit.visitID) AS count, refTrkNonAdmitReason.description, Entity.entShortName, MONTH(refTrkVisit.initialEntryDate)
...
December 8, 2009 at 11:08 am
Bult or Bulk?
What do you want to save in the text file? All of the inserts, or a number of rows inserted, or what? 😀
teresita.castro (12/8/2009)
I need to create...
December 8, 2009 at 10:55 am
Viewing 15 posts - 76 through 90 (of 131 total)