2 threads, 8 posts, and only 1 contributor.  Is he trying to inflate his numbers?

Drew

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...

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...

Here's another method.


SELECT PatientID
FROM #t
WHERE PatientBalance <> 0
GROUP BY PatientID
HAVING MAX(PatientBalance) > 0
    AND MIN(PatientBalance) < 0

Drew

SELECT PatientID,...