Viewing 15 posts - 136 through 150 (of 431 total)
I need the expression to test if "Today" is the first day of the month. So, on March 1st, I actually need to show the user the date range of...
February 28, 2017 at 8:07 am
Here is a table. The expected results should look something like this. I'm not sure that the Days... is correct but, you get the picture. The PCCP record should be...
February 7, 2017 at 10:23 am
I'm not sure that the img tags are working.
February 7, 2017 at 10:01 am
">
I need the first example to not include the first Care Note. The individual IDXMRNs should begin with a PCCP record.
February 7, 2017 at 9:58 am
Almost there. Your where clause results in only PCCP records. If I remove your where clause and order by IDXMRN, EncDttm, then, it looks good. Only problem is....I need the...
February 7, 2017 at 9:43 am
January 31, 2017 at 7:18 am
January 31, 2017 at 4:25 am
The "DIR" command I posted wasn't supposed to export the file. It was supposed to...
January 31, 2017 at 4:12 am
January 30, 2017 at 11:29 am
drew.allen - Monday, January 30, 2017 11:11 AMUnless I'm missing something, it's very simple.
SELECT *
FROM #T
WHERE PrescriptionID < DuplicatePrescriptionIDDrew
I'm such...
January 30, 2017 at 11:22 am
January 30, 2017 at 10:58 am
January 30, 2017 at 5:43 am
January 30, 2017 at 5:13 am
Viewing 15 posts - 136 through 150 (of 431 total)