I have a simple question regarding TSQL and stored procedures.
Assuming a table with only two columns, say, ID and Phone.
The user will then key in up to 10 IDs and up to 20 Phone numbers.
The query is to find all rows in the table that would match any combinations of these IDs and Phone numbers.
I am not allowed to use Dynamic SQL. Must do with stored procedures.
Anyone, please help.
The problem is there is a table with two columns, IDs and PhoneNumbers.
There are about 1M rows in this table. The users are allowed to key in 10 IDs and 20 PhoneNumbers on a screen. A stored procedure is needed to scan out all rows in the table that would match any possible combinations of IDs and PhoneNumbers that the user had specified.