put multiple value in a like sql

Solutions on MaxInterview for put multiple value in a like sql by the best coders in the world

Search
showing results for - "put multiple value in a like sql"
Jacopo
15 May 2019
1SELECT
2  x.*
3FROM
4  (
5    VALUES
6      ('emp1%', 3),
7      ('emp3%', 2)
8  ) AS v (pattern, row_count)
9  CROSS APPLY
10  (  -- your query
11    SELECT top (v.row_count)
12               employee_id, employee_ident, utc_dt, rx_dt 
13    FROM       employee
14    INNER JOIN employee_mdata_history
15    ON         employee.ident=employee_mdata_history.employee_ident 
16    WHERE      employee_id like v.pattern
17    ORDER BY   rx_dt desc
18  ) AS x
19;
20
source
similar questions
sql add two values togethersql update multiple tableshow to update the multiple rows in sqlset sql multiple valuesmultiple like in sqlhow to insert multiple records at once in sql acesssql sum multiple rowssql select merge multiple valuesreplace multiple string in query sqltsql join multiple record in one stringsql server insert multiple rowsupdate table sql multiple setinsert into values multipleoracle sql like multiple valuesinsert multiple values into one column sqlupdate multiple columns in sqlsql where multiple valuesmultiple replace value mssqlsql query update multiple columnsselect query in sql for multiple valuesadd multiple field in table sqlsql server update multiple columns at oncesql insert multiple rows from select
queries leading to this page
how to put query in sql for multiple like conditionmultiple value in like sqllike query with multiple values in sqlhow to multiple like values in sqlput multiple value in a like sql