Recent content by chiplarsen

LB, you are awesome! You have helped me several times over the past 13 years! Thank you! Your example worked perfectly. I added the medication IDs to the query and changed the syntax a little. It works great! It is exactly what I needed. Thanks again! This will help me get out of the box...

Thank you LB! I am working through some of the syntax right now. I am going to try to get it to work. Chip

No, there will be one encounter per patient and multiple patients. I will suppress all of the detail and just have the summary crosstab. This is what it will sort of look like. The first column are the values from the grouped datediff values. The fourth column is the count of the patient...

My intention is to get a specific patient encounter based off of the admission date. From there, I am looking for a specific documentation record and that date. I am using the specific documentation date(only one) and the minimum order date to calculate how long it took from the documentation...

Thank you lbass and kray4660!

Hi kray4660, Could you give me an example of how you would accomplish this with sql code? I have a main table that the order table(order date) is linked to. If I understood how to link the code back into the main table, I could do it. I believe that you would create a little query that would...

Hi, I have created a report in Crystal 13. I have a formula that is used to tell how many days between two dates. The "Admit Date" is constant, but the second date could have multiple values. I am using the minimum(second date) in my datediff. The first formula is to get the minimum date...

I have a SQL 2005 database that I want to use a trigger to update a column in one table base on data from the previous day. The data in this table is inserted via a bulk insert command. bulk insert BILLING_TABLE from 'c:\ftpfiles\cur_cens2.txt' There is one column that will be empty upon...

I am using Python 3.1. I am trying to start a process (.exe) on a remote server. I am running the script from another server. When I run this code, the process starts on the remote server and can be seen in the processes in the task manager. I need this process to be visible so I can monitor...

I am trying to do something that I am sure is simple, but I have not work with VBScript much at all. I want to open a text file in one directory and save as to another directory with a new name. When I run this code from a cmd prompt, I do not get an error, it just executes and does nothing in...

Hi, I have an Access 2003 database that uses SQL 2005 linked tables. I have no problem opening the database and viewing the data, but if I want to add a record to the table or update a record, I can not do it. The options to insert a record are grayed out. The SQL tables are linked via ODBC...

Hi, I have a string that looks like this. Patient Transferred to:CSCU I want to split out the data from the right side of the :. I tried this, but it did not works. split(description,":")[1] This returns Patient Transferred to. I want to get CSCU. Can anyone help with this function. Thank you

I am embarrased to say you were right. There were no matches on PAT_ACCT_NBR. I should not have assumed that there were. I guess that is a lesson learned. Thank you

George, it is working now. I think that it would have worked after you told me about FIRE_TRIGGERS command in the bulk insert. Thank you George.

This is the results of the query. IPS_DSCHRG_DX varchar BILLING_TABLE nvarchar CURRENT_CENSUS nvarchar DISCHARGE_TABLE nvarchar It does look like the query is firing, but no updates. I am also learning about creating the proper keys in my tables. In the BILLING_TABLE, the PK is a combination...