Recent content by Crystalguru

Sweet! That was it! Thanks so much.

MSSQL 2000 Can I declare a table variable, then use it for another table variable? Here is my code: Declare @Patients Table (ClientKey numeric(16,0) NULL, UnitKey numeric(16,0) NULL) INSERT INTO @Patients SELECT PatientVisit.ClientKey as ClientKey ,Unit.Key as UnitKey FROM Unit INNER...

MS SQL Server 2000 Using Query Analyzer to create query The below query gives me a 'Divide by Zero error encountered'. How can I check for zeros first. I tried a case statement but cannot figure out where/how it goes. I put it in the demoninator, to check for zeros. select u.displayname...

MS SQL Server 2000 I need help optimizing this join. INNER JOIN CV3Order on CV3BasicObservation.OrderGUID = CV3Order.GUID And CV3BasicObservation.ClientGUID = CV3Order.ClientGUID And CV3BasicObservation.ChartGUID = CV3Order.ChartGUID And CV3Order.GUID not in (SELECT...

Shazam! We may have it! Select AllBeds.Name, OccupiedBeds.Status, OccupiedBeds.ClientdisplayName From ( Select CV3Location.Name, CV3location.typecode, CV3location.guid From CV3location WHERE CV3Location.TypeCode = 'Bed' ) As AllBeds...

This query: Select CV3Location.Name, CV3location.typecode From CV3location Returns: TypeCode =Units, Rooms, Beds To get just beds: Select CV3Location.Name, CV3location.typecode From CV3location WHERE CV3Location.TypeCode = 'Bed' This query: Select...

Here's the actual query I am using: SELECT CV3Location.Name, CV3location.typecode, Unit.GUID as LocationGroupGUID, Unit.Name as Unit, CV3ClientVisit.ClientDisplayName, cv3clientvisit.internalvisitstatus FROM CV3Location JOIN CV3Location Unit ON CV3Location.LocnGrpGUID=Unit.GUID...

I am using MS SQL Server 2000 Here's my current data: Patient Name Bed Num Doe, Jon 1101 Smith, Mary 1102 Carls, Don 1105 What I would like to see is this: Patient Name Bed Num Null 1100 Doe, Jon 1101 Smith, Mary 1102 Null 1103 Null 1104...

Thanks, works like a charm.

I am having trouble with the Start Date and Start Time parameter. Guess I just can’t get my head into it this morning. My report has two parameters: Start Date Start Time If the user enters the following: Start Date: 02/07/06 Start Time: 14:00 The Report Period will be 24 hours: 02/07/06...

I am re-evaluating the performance of a query and noticed that the query contained several LIKE statements. Will this affect performance of the query? AND ((cd.DocumentName = 'PDB_Patient Database' AND (obs.DisplayName = 'PDB_LivingWill_O' OR obs.DisplayName = 'pdb_DPOA' OR obs.DisplayName =...

Sheco-- I agree also. As you can tell from my screen name, I am rather partial to Crystal Reports. But have had training on Reporting Services. What I find most frustrating is I know what I want to do but can never FIND it. It definately needs to mature and become a little more "Microsoft"...

Got it from your other post! Thanks!

Thank you very much for a very well written and easy to follow instructions. I completed A - E and the connection failed. I completed step F and the connection was successful. I turned on the "Allow saving password" and clicked on the preview tab - IT WORKS!! This makes me SO happy! I have...

Since I am quite new to this, I am not sure. Could you point me in the right direction to test what type of connection it may be? Thanks