subquery returning multiple values in sql server is query result when i used where in() claues
'110,112,125'
SELECT * from Tbl_Order where orderid in(select dbo.split(@param)
@paramis
SELECT * from Tbl_Order where orderid in(case @param when '' then orderid else (select dbo.split(@param))
SELECT * from Tbl_Order where orderid in (case when @param='' then orderid else (select dbo.Split(@param) )end)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)