sql server stored procedure

[ganesh22]

Hi,
i writen stored procedure for getting values based on location but my problem is if i entered single location means its working but if i enteres multi location means its not working
ex: if i entered Chennai means its working then if i entered Chennai,Bangalore means its not working???

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Get]
@ID varchar(500)=NULL,
@Location varchar(50)=NULL
AS
BEGIN
select * from Details where Location in (@Location)
End

[deepuv04]

Hi,
i writen stored procedure for getting values based on location but my problem is if i entered single location means its working but if i enteres multi location means its not working
ex: if i entered Chennai means its working then if i entered Chennai,Bangalore means its not working???

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Get]
@ID varchar(500)=NULL,
@Location varchar(50)=NULL
AS
BEGIN
select * from Details where Location in (@Location)
End

Hi
Try the following code...
Here pass the @Location value like Banglore,Chennai,....

[code = sql]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Get]
@ID varchar(500)=NULL,
@Location varchar(50)=NULL
AS
BEGIN
select * from Details
where (','+isnull(@Location,convert(varchar(100),Locatio n) )+',') like
('%,'+convert(varchar(20),Location)+ ',%')

End

[/code]

Thanks

[ganesh22]

Hi, Deepu!
Thanx for reply!, Its Working