troubleshooting Question
When declaring a parameter in SQL Can you set the parameter to use all records that contain the word...
RUA Volunteer2?
asked on
asked on
When declaring a parameter in SQL Can you set the parameter to use all records that contain the words like this '%Test%' or '%Experiment%' or '%Study%' so as an example can you do this?
ALTER procedure [dbo].[bi_medica_code_combo]
@med_code ........... varchar(max) like '%Test%' or '%Experiment%' or '%Study%'
Can you apply any record that contains those 3 values through to the parameter to run EXEC on the [bi_medica_code_combo] procedure. If so I really need the proper format to make this work.
@med_code ........... varchar(max) like '%Test%' or '%Experiment%' or '%Study%'
or
@med_code ........... varchar(max) "in" or "=" ... ('%Test%' , '%Experiment%' , '%Study%')
If I have to put the exact value like "Test1,Test2,Test3...Test100" to pass to the parameter and I cannot use some kind of '%...%' please let me know.
ALTER procedure [dbo].[bi_medica_code_combo]
@med_code ........... varchar(max) like '%Test%' or '%Experiment%' or '%Study%'
Can you apply any record that contains those 3 values through to the parameter to run EXEC on the [bi_medica_code_combo] procedure. If so I really need the proper format to make this work.
@med_code ........... varchar(max) like '%Test%' or '%Experiment%' or '%Study%'
or
@med_code ........... varchar(max) "in" or "=" ... ('%Test%' , '%Experiment%' , '%Study%')
If I have to put the exact value like "Test1,Test2,Test3...Test100" to pass to the parameter and I cannot use some kind of '%...%' please let me know.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.