SQl will consider as a single value, you need to go some trick to get the output
CREATE FUNCTION idToTable
(
@idString VARCHAR(8000)
)
RETURNS @idTemp TABLE(sID VARCHAR(20))
AS
BEGIN
DECLARE @Temp VARCHAR(20)
WHILE LEN(@idString) > 0
BEGIN
SET @Temp = LEFT(@idString, ISNULL(NULLIF(CHARINDEX(',', @idString) - 1, -1),
LEN(@idString)))
SET @psCSString = SUBSTRING(@idString,ISNULL(NULLIF(CHARINDEX(',', @idString), 0),
LEN(@idString)) + 1, LEN(@idString))
INSERT INTO @idTemp VALUES (@Temp)
END
RETURN
END
CREATE TABLE TestIn (name VARCHAR(15), id int identity)
insert into TestIn(name) values('Ammu'),('unni'),('geethu'),('tintu'),('joby'),('jinu')
declare @id varchar(300)
set @id='2,3'
SELECT * FROM TestIn where id in (select * from idToTable(@id))
Regards,
Jayakumar Selvakani
Amritha444, if this helps please login to Mark As Answer. | Alert Moderator