Hello,
I am creating a report that shows all staff productivity for each individual day of the week there are some staff who show a zero on some days and I can’t get the grand total at the end to count the staff Member if productivity is zero. Any help is appreciated. Here is the expression I...
Hello,
I am trying to group some rows of data so I get the most recent value. Tried to use a substring but received this error. Any help will be greatly appreciated.
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.
select...
Hello,
I am trying to modify a script where a patient has greater than two episodes of care and I am receiving an error. I've tried changing the script however SQL throws back an error each time.
Error - An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a...
Hello,
Thank you for the reply. The error I receive after running the updated code:
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "bth.PatID" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "bth.date_of_service" could not be bound.
Msg 4104...
Hello,
I am trying to write a query to pull patients that have received a service within 90 days of their first services. I have tried running the below code and some other variations and have not been able to get the count. Any help would be great.
select bth.PatID,
from billing_table bth...
Hello,
Does anyone know a formula I can use to create a new medical record number based off the patient's original MR# I have in my system? I have to de-identify some data and have no clue how I should accomplish this. Here is an example of what I am trying to do below.
MR# New#
1 65...
Hello,
I am trying to display the digital signature image on a crystal report and I'm having no luck. I am running CR 2011. I have tried changing the location of the graphic to the database field but the original graphic still shows and not the signature. I placed the field on the report and...
Thanks sqlbill, I actually did have the parameters in the code but removed them because they did not work. I left them in the top section to show which parameters I was trying to use. I placed them in each section of passes but they did not give me the results from each parameter. The only...
The was originally written to work with a crystal report and now I have to switch it over to work with Reporting Services. The date and coverage parameters work fine but I cannot get the report to accept the other 3 parameters I need to add. I tried to add them through reporting services but...
Hello,
I am having some trouble adding 3 more Parameters to an already written stored procedure. I have added the parameters at the top already. They are @protocol, @staff and @service. I have tried to fit them in the script but it is either not pulling the data or pulling data I am not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.