This might help some who have had problems with Dynamic SQL and handling multiple conditions- this worked for me:
CREATE PROCEDURE MatchConditions
@id int,
@op1 varchar(75),
@op2 varchar(75),
@op3 varchar(75),
@value1 varchar(75),
@value2 varchar(75),
@value3 varchar(75)
--Match...
[More]
Be the first to rate this post
- Currently 0/5 Stars.
- 1
- 2
- 3
- 4
- 5