Viewing 15 posts - 76 through 90 (of 223 total)
Ninja's_RGR'us (11/14/2011)
that query could be rewritten as such =>
JOIN RFT_TARGET_DIAGNOSES TON T.DIAG_CODE IN (C.DIAG_01, C.DIAG_02, C.DIAG_03, C.DIAG_04)
Huh... don't recall ever seeing an "in" claused used in a join quite...
November 14, 2011 at 10:29 am
OK -- great tips, clever tricks (and new fangled features I might get to play with if I ever get beyond sql 2k5)!
Plenty to go on from here.
thanks!
October 20, 2011 at 10:36 am
Chris -- interesting query. Looks like it's for SQL 2008?
So, if I understand it, the CROSS APPLY components transform a drug description into a comma-delimited array, which is then pivoted...
October 20, 2011 at 10:00 am
Grant Fritchey (10/20/2011)
Phil Parkin (10/20/2011)
Grant Fritchey (10/20/2011)
October 20, 2011 at 8:06 am
Jack Corbett (10/19/2011)
October 19, 2011 at 12:32 pm
Martin -- thanks for the reply. The finer points you highlighted in your code are duly noted. Awesome!
--Pete
September 13, 2011 at 2:56 pm
sjohnson022 (9/9/2011)
Thanks for the post, this really helped me. the variable is the only way to handle this situation.
Could you post what your replace expression looks like with the variable...
September 12, 2011 at 9:12 am
kramaswamy (9/7/2011)
September 7, 2011 at 11:27 am
Phil -- thanks for the quick reply!
Looks like I need to learn about setting breakpoints and viewing the values of variables....
--Pete
September 6, 2011 at 3:23 pm
Awesome - thanks for the quick reply!
September 2, 2011 at 12:56 pm
I've never forgetten this question: "What would your enemies say about you?"
I vaguely recall my response being one of their expressing envy about my successes.
But, in hindsight, I suppose a...
August 12, 2011 at 7:45 am
WayneS (5/27/2011)
peterzeke (5/27/2011)
WayneS (5/27/2011)
Pete,
2 questions:
1. Based upon the new row being added to the sample data, what are your expected results?
2. Does Drew's approach solve your issue?
Starting with #2 --...
May 31, 2011 at 6:39 am
WayneS (5/27/2011)
Pete,
2 questions:
1. Based upon the new row being added to the sample data, what are your expected results?
2. Does Drew's approach solve your issue?
Starting with #2 -- yes, Drew's...
May 27, 2011 at 2:25 pm
peterzeke (5/27/2011)
Mark-101232 (5/27/2011)
a case of just joining to the insurance for the latest month
WITH CTE AS...
May 27, 2011 at 7:19 am
Mark-101232 (5/27/2011)
a case of just joining to the insurance for the latest month
WITH CTE AS (
SELECT...
May 27, 2011 at 7:01 am
Viewing 15 posts - 76 through 90 (of 223 total)