VBBRett
asked on
Having 2 parameters equate to one parameter
I would like to take two parameters in SQL with SQL Server and concatenate them to be passed to one varchar parameter. How would I take the two parameters, which must take user input and then pass it all to a larger stringed parameter which essentially gets used into the query? Thanks!
ASKER
OK, I am looking for something much simpler then that. Let's say I have the following:
@cn as varhcar(6)
@mn as varchar(5)
cmn as varchar(12) = @cn + '-' + @mn
How would I declare cmn so that it is not a required parameter for a user to fill in but it is still used in my query?
@cn as varhcar(6)
@mn as varchar(5)
cmn as varchar(12) = @cn + '-' + @mn
How would I declare cmn so that it is not a required parameter for a user to fill in but it is still used in my query?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://stackoverflow.com/questions/512105/passing-multiple-values-for-a-single-parameter-in-reporting-services