Sergiy (6/27/2008)
jcrawf02,can you explain this:
ISNULL(count(distinct #PLANDATA_Claim.claimid),0) AS "FFS",
What ISNULL is doing here?
I have three environments that I need to query to find my data. #files table is in one, #PLANDATA is another, #ENCOUNTER is the third.
I am counting distinct claimids from #PLANDATA (user knows it as FFS) or #ENCOUNTER (user knows it as Encounter) and returning that value within the same row of the result set.
I'm basically changing the total to 0 for this column in the result set in the case that there aren't any claimids, so that it won't be null.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."