Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mchambers

    Count records with Null values

    I change it to =sum(iif(isnothing(Fields!Duration.Value),1,0)) / (count(Fields!v_PROVIDER_NAME.Value) *8) and all zeros came back.
  2. mchambers

    Count records with Null values

    Thank you for your response. How would I do this in SSRS under the expression? Sorry new to SSRS. I have attached my sample data and groupings.
  3. mchambers

    Count records with Null values

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

    Error converting date and/or time from character string

    Wow I can’t believe I missed that. It’s been a long morning. Thanks for the catch!
  5. mchambers

    Error converting date and/or time from character string

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

    Error - in Where clause

    That worked! Thanks!
  7. mchambers

    Error - in Where clause

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

    Query to count patient with 2 or more visits within 90 days of first service

    That worked! Thank you both! Have a wonderful day.
  9. mchambers

    Query to count patient with 2 or more visits within 90 days of first service

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

    Query to count patient with 2 or more visits within 90 days of first service

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

    De-identify a Medical Record number

    Fantastic idea Pete! Thanks so much!
  12. mchambers

    De-identify a Medical Record number

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

    Digital Signatures

    Ok thanks for getting back to me.
  14. mchambers

    Digital Signatures

    It is a SQL database the datatype is text and I am using an OLEDB connection to connect to it.
  15. mchambers

    Digital Signatures

    Thanks so much for getting back to me. The imaged is stored in the database like as text. Here is an example which is only about half the text...
  16. mchambers

    Digital Signatures

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

    Help adding Parameters to Stored Procedure

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

    Help adding Parameters to Stored Procedure

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

    Help adding Parameters to Stored Procedure

    I forgot to add that I am trying to call @service = billing_proc_code, @protocol = protocol_id and @staff = billing_clinician_id. Thanks
  20. mchambers

    Help adding Parameters to Stored Procedure

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

Part and Inventory Search

Back
Top