Search results for query: *

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

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

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

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

After installing IIS6.0 and opening the application, I am trying to add my computer name. I get this error: this computer is not running internet information services version 4 or higher I cannot find out why? Any ideas? Thanks

I have report services installed locally on my laptop. It is access the local sql server developer 2000 database. It is running XP SP2. When I am in my report project, I can query the data and return data from the database. I can look at the Layout of the report. When I go to preveiw the...

Hello, I have a Customer form contains Name, Address, Phone. On this same form, I have Sales Info - product name, qty, cost. The product name is a drop down list from the Product table. What I would like to happen is when the user selects the product name from the drop down list, the Sales...

I have a simple table called products. I have created the table. Product Name cost per item: Properties - Number, Long Int,currency, auto When I go to enter data into the table, here's what I am getting: Enter Result 6.00 $6.00 -- good 6.15 $6.00 -- Nope?? What is going on? Seems...

Hello, Using: Laptop - demo system XP SP2 MS SQL Server 2000 developer (upgraded from Professional) I am trying to restore my database(DEMO) from my previous install of SQL Server. When I open SQL Server Enterprise and go to Restore Database from Device, find the demobackup file, it gives me...

Crystal 8.5 SQL Server 2000 To reset each page number for each patient in the report. Report is duplex printing, printing one page on front, next one on back - remainder(pagenumber/2)=0 Report has main report with 5 groups, in 4th group is subreport. G1 - Unit G2- Unique ID G3- Patient Name G4...

Crystal v10 Lotus Notes view I have the following groups in my report: Country ASC Category ASC @Status -Specified order: Open, Reopen, closed, transferred Report Date - DESC Case ID The status formula is: if isnull({Case.CaseStatus_t}) then "Open" if isnull({Case.CloseDate_d}) then "Open"...

Crystal Version 8.5 MS SQL 2000 I need to convert the following id code to ascii numbers. A-Z = 65-90, 0-9 = 48-57 ID Code 123BDC455 040CGQ791 The code will always be 3 numbers, 2 chars, 3 numbers. I need them to convert to: ID Code conversion 123BDC455 495051666867525353 040CGQ791...

Crystal V 8.5 Lotus Notes view Group 1 = Category Group 2 = Case ID Running total that counts the caseids that fall within the current year. CaseID ReportDate current year 123 5/6/2005 1 124 4/7/2005 1 234 5/3/2004 0 256 5/8/2005 1 Grand Total: 3...

I am using MS SQL Server 2000 Can someone tell me why the following sql only returns the first cursor set? ALTER PROC Top_3_Results_R_Pr AS -- variables for cursor-obtained values DECLARE @ChartGUID varchar(16) ,@ClientDisplayName varchar(50) , @ClientGUID varchar(16) -- make...

Hello, I am using a Lotus Notes view. Using Crystal version 10 My Lotus Notes admin created a view called Case_v for me to do reports off of. We then decided that another column needed to be added to this view, but since the Case_v was being used in other reports, it would be easier to create...

Howdy, Trying to get the Max row out of a table. For example: ClientUID OrderUID Ordermaintidcode toucheddtm reason 4556 123 101 02-19-05 01:00 New 4556 123 102 02-19-05 02:00 Changed 4556 123 103 02-19-05 02:30 Final...

Hello, I am using CR 8.5, MS SQL 2000 and a stored procedure for this report. In the stored procedure, one field captures the Height and Weight of a person - call it typecode. Another field captures the numeric value of the height or weight - call this HTWT. Here is how my data looks like...