Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Restore QUSRSYS and QGPL
Hi all. Background: I have a 520 running V5R3. The system was brought live by a third party vendor while I was out of work for a while n October of last year. From what I understand, the person who brought the system live saved our old V4R5 (mod 720) system and restored to the new box. They... -
Set variable to different values
Vongrunt, Thank you so much for your help. The last trick did it. I GREATLY appreciate the help given. Thanx... Mitch- mcs1169
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Set variable to different values
Vongrunt, Thank you for the reply. Remember, I am a relative neophyte so please be patient. I put DECLARE @Text varchar(10) DECLARE @Type varchar above the SELECT statement and modified the compare to SET @Type = CV3PhysicalNoteDeclaration.TypeCode IF @Type = 'WEIGHT' set @Text = Cast...- mcs1169
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Set variable to different values
Hi all. I am a first time poster and a relative neophyte when it come to SQL stored procedures. I have an existing SP that I am trying to modify. The existing SP gives me all of the latest weights on a group of patients in our hospital. I am trying to add the patient's heights as well. The...- mcs1169
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
