Viewing 15 posts - 1 through 15 (of 31 total)
my related question is although number of days in each week is rather consistent (6) if we expand the year from 2014 to 2020, but number of weeks in each...
September 30, 2015 at 4:04 pm
I think I figured that one out.
Thanks you
September 30, 2015 at 3:49 pm
That's awesome...thank you. how do I add number of days in each week period to the table?
September 30, 2015 at 3:42 pm
What I am trying to achieve is this. I am going from Claim Billed (CH) to Claim Paid (PL).
Patient ID - CHClaim No - CHThird Party Code - CHBilled...
August 17, 2015 at 11:50 am
Thank You. Coupl eissues:
1. I think there was a missing close parentheses in this statement right before ROWS. I added that.
\MAX(fgs.rn) OVER (ORDER BY fgs.DT, fgs.BegTime, fgs.ClientID) ROWS UNBOUNDED...
June 18, 2015 at 2:19 pm
Doohsan,
I needed to add couple more variables into the partition statement. Thus, I modified the data and codes accordingly (see below). First I get this error message:
The Parallel Data Warehouse...
June 18, 2015 at 2:12 pm
Dohsan,
My bad of overlooking your question in the first post. You were right and that was a typo. Thus date matters and 5/7 should have been 5/6. Thank you for...
June 17, 2015 at 9:43 am
Thank you for sharing the code. For most part, the code is working since I can get no of groups from your GroupNum column. However, GrpSize (GroupCount) should be 7...
June 16, 2015 at 4:04 pm
Oh that, I know that for sure since they are unique.
March 17, 2015 at 11:18 am
I am sorry but I am not following your question! the issue is to add more rows with the same logic as O.
Helal
March 16, 2015 at 8:14 am
Just like adding O, now I add C with the same logic. So C for 2010501 will be the sum of (a201501 and b201501). Here are data:
--Existing Data
--===== If the...
March 13, 2015 at 9:13 am
Grouping Sets worked great. Thank you...can I add more items besides O with Grouping Sets? if yes, can you give me an example please?
Helal
March 12, 2015 at 5:06 pm
Luis,
Thank you for your kind words and am sorry that I overlooked the fact that they were part of your signature. Again, Jeff and your codes saved my life.
Helal
March 3, 2015 at 1:50 pm
Thanks Luic for dynamic SQL. Very elaborate and I need to test it. However, on your note "Are you seriously taking the advice and code from someone from the internet...
March 3, 2015 at 8:31 am
Viewing 15 posts - 1 through 15 (of 31 total)