Search results for query: *

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

I see both the report server files at: http://localhost/ReportServer AND the Report Manager at: http://localhost/Reports When I go to preview the report I get the dreaded "Unable to connect to the database error" I have read many threads on this error but no resolutions. I am curious as why I...

I am still receiving the error that an error has occurred during report processing. Anyone with ideas?

MS SQL Server 2000 Developer XP SP 2 laptop Visual Basic .Net MS .Net Framework 1.1 MS development Environment 2003 SQL Server Report Designer V8.00.743.00 When I go to Tools - Connect Database - Fill out the credentials for my server. Test connection - Test Connection succeeded. Click on OK -...

have you tried this? Go to the GF for Location Format Section New Page After Each time the Location changes, a new page will start. Not sure if this is exactly what you need. Try it. Then work your way up the list, City, State, country, turning on the New Page After.

Here's my two cents: Crystal Reports will allow you to export your results to XLS, PDF, CSV, etc. If you know your joins/relationships from writing the select statements in QA, then using Crystal is that much easier. Why did you give up on Crystal? What was it's limitation as you saw it? If...