Viewing 15 posts - 826 through 840 (of 4,085 total)
2 threads, 8 posts, and only 1 contributor. Is he trying to inflate his numbers?
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 23, 2018 at 2:22 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 23, 2018 at 9:51 am
I did exactly that at a previous job. We had to send out letters for an insurance company and the content of the letter depended on the type of insurance...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 23, 2018 at 8:17 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 22, 2018 at 3:24 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 22, 2018 at 3:01 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 22, 2018 at 9:43 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 22, 2018 at 9:22 am
This should be handled in the presentation layer, not the database layer.
SQL Server is strongly typed. That means that you cannot mix string ('') and decimal data in...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 19, 2018 at 2:15 pm
Here's another method.
SELECT PatientID
FROM #t
WHERE PatientBalance <> 0
GROUP BY PatientID
HAVING MAX(PatientBalance) > 0
AND MIN(PatientBalance) < 0
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 19, 2018 at 12:18 pm
SELECT PatientID,...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 19, 2018 at 12:15 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 19, 2018 at 11:47 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 19, 2018 at 10:30 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 17, 2018 at 2:19 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 17, 2018 at 2:17 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 17, 2018 at 9:43 am
Viewing 15 posts - 826 through 840 (of 4,085 total)