Viewing 15 posts - 1 through 15 (of 18 total)
very nice..appreciate all your responses!
December 22, 2023 at 12:08 am
this works like a charm. I appreciate the help and your friendly suggestions!
August 14, 2023 at 4:49 pm
Yes sir...it is enclosed. Thanks!
August 10, 2023 at 12:00 am
I pretty much skipped a few previous steps in the query above for simplicity. Assuming I've already ordered the above data set with a previous cte, I need to look...
December 26, 2021 at 8:13 am
sorry, been out of office for a few days, but wanted to close the loop, both suggestions of enveloping the case statement with a cast and convert both worked as...
January 7, 2021 at 3:42 pm
great responses and is what I need. Really appreciate it. Some is over my head at the moment, but working as expected. If I had another request to count the...
November 16, 2020 at 7:30 pm
this is great, Ken. Works as planned, however it's taking about an hour to complete. Anyway I can possibly optimize this? Thanks again for your help.
September 23, 2020 at 3:34 pm
I appreciate your help..this worked great! Thank you.
October 19, 2018 at 8:35 am
tried starting out with the SQL below, but it's not evaluating each UserID/Row...only bringing back the "ordered" date in T2 obviously.
select t1.*,
(select t2.Date
October 12, 2018 at 1:00 pm
thank you..
DCDate is actually Discharge Date. All visits have discharge dates, but in the query I provided the DCDispCode = 20 is actually the code for diseased.
They could have...
May 24, 2016 at 1:53 pm
thanks so much for your response Lowell. If, for example, a person who dies on Jan 1, 2015, I would need a count of visits from Jan 1, 2014 through...
May 24, 2016 at 12:50 pm
Lol..thanks for the replies. I appreciate the help I get from this forum. I'm a data analyst who's very new to the SQL world, so half the advice the gentleman...
February 8, 2015 at 9:26 am
this works great!..thanks so much for your help!
February 5, 2015 at 11:22 am
yes, if in the F.AttPhysKey, the same key can be in the F.SurgeonKey and yes, I'd like the row. Thanks!
February 5, 2015 at 10:12 am
thank you for your responses and link. I'll remember that for future questions I might have. They pseudo code worked fine..thanks for the advice.
September 18, 2012 at 4:58 pm
Viewing 15 posts - 1 through 15 (of 18 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy