I have a table that contains millions of rows for names of customers as a column. I want to find if a part of a name exists within another row in the same column. E.g. If a row has value ‘Roger …
Tag: query-string
SQL query how to get the local variable
I have this query and I want to get “page” variable which is created: How can I get it in the query to make a procedure to search. and page = @page; Answer
Passing multiple values for a single parameter in Reporting Services
I have several Multi-Select parameters in my report. I am trying to find a way to pass in multiple values for a single parameter in the web query string? If I pass in a single value, it works fine. The report runs fine selecting multiple choices for a single param. My trouble lies in the web query string. Answer Although