Search results for query: *

You folks are great! I should have thought of that myself. Thank you again! glthornton

Hi Everyone, I'm using SQL 2000 server, Win 2003 server. I am trying to convert a datetime field into a regular date but I need the result to provide me a null when if the date returned is 12/31/1899. Here is what I have so far: SELECT patid,acctpriority,accounttype, TYPE=CASE WHEN...

I get data that I can read, but the problem is its UTF-8 so not all the field have unicode values. So when it loads into the table its a fixed width file and once it hits a unicode character is shifts everything and then stops loading the records. When I change it to TristateFalse, does that...

Thank you PHV for your response, but it just doesn't seem to work. Look at the attachment link so you can see the type of results I am getting. Would greatly appreciate any other thoughts or ideas. Kind regards, glthorntonhttp://www.driveway.com/u1m2l7s1o8

I have been trying to import a Unicode file into an Access 2003 database via VBA code with no luck. I tried using the OpenTextStream to read the data but can't seem to get that to work. The files are fixed width but are UTF-8 format. Please any proven fix would be greatly appreciated.

You folks are AWESOME!!!! Worked like a charm! You can all go home now, you've helped a fellow user. :) Cheers, Glenn

Hi, SQL 2000 platform, Windows 2003 server. I'm working on a query that will provide me maximum date for a specific field(MR_FINISH_DATE). The problem is that not all of my entries have data in this field and thus are returning with a NULL result. I want to know if it is possible to force a...

Hi, I'm trying to compare 2 separate DB (SQL 2000 Server) tables to determine which Medical Record numbers are missing. I've developed a query to do that and it executes successfully, but I am not getting the end result that I am anticipating. Here is my query: SELECT DISTINCT MR_NUMBER...

Borislav, if I run the below query I get exactly what I want except I'm trying to also pull in the the Provider Name (prov.displayname). SELECT ckt.name, MAX(ckd.created) FROM ((Checkdata ckd INNER JOIN Checkmark ckm ON ckd.CID = ckm.CID) INNER JOIN checktext ckt ON ckd.DataID = ckt.DataID)...

Thank you for your reply Borislav. I have run the query you have provided and I'm still not getting the results I am looking for. Although, your query did remove some of the result rows. I still have multiple duplicates. I have placed both queries in the analyzer for everyone to see. You...

Hi, I'm working on a SQL 2000 server and I'm trying to write a query that will return the latest instance of a patient's medication allergies. But my current query is only designed to pull all instances. Here is what my current SQL code looks like: SELECT DISTINCT ckt.name, prov.displayname...

You're awesome George!!! Sometimes things like this seem a lot harder than they really are. Thank you so much. You're a life saver! Glenn

Hi, Is it possible to combine 2 separate date and time fields and then convert them to a single date/time format within a SELECT statement? Let me give you an example, I have one field called Appointment Date (apptDT) and then I have another field called Appointment Time (apptTM). This is...

Hi everyone, Configuration: MS SQL 2000 using Server 2003. I am trying to design a query that will allow me to access different databases using the OPENDATASOURCE command but also using the WITH (NOLOCK) command as well. I know that using NOLOCK is using a 'dirty read', but it's okay with...

This is exactly the kind of information that I needed to know. I cannot tell you how much I really appreciate your assistance on this!! This was great stuff!!

This will work great!! Thanks George!

Thank you George. I do understand the UNION and UNION ALL syntax, but let me provide you with some more examples. Here is my Weight query: SELECT vst.patid, vst.vid INTO dbo.vtrhio_daily FROM Visits vst INNER JOIN checktext ckt ON vst.VID = ckt.VID INNER JOIN Checkmark ckm INNER JOIN...

Hi everyone, (DB Info: SQL Server 2000). I'm currently working on a project for our hospital to participate in our states RHIO. What I need to do is create sql queries that will check to see if certain values (BP, Height, Weight, etc.) has been added to a patient record within the past 24...

Shazam!! That one finally worked!! What I did was take the code you provided me and put that in the formula that is located in the Details Section. Then I removed the old code from the formula that was located in the Report Footer Section and replaced it with "Shared NumberVar TotCommVisits;"...

Hey, I totally understand. :) I do not have the formula duplicated anywhere else. Glenn