Posted by Dan Guzman on 07/04/06 19:40

See Erland's article on the subject:
http://www.sommarskog.se/arrays-in-sql.html

--
Hope this helps.

Dan Guzman
SQL Server MVP

"shark" <xavier.sharon@gmail.com> wrote in message
news:1152022816.209445.326230@p79g2000cwp.googlegroups.com...
> Hi All,
>
> i hv created a sp as
>
>
> Create proc P @iClientid varchar (100)
> as
> Begin
> select * from clients where CONVERT(VACHAR(100),iClientid) in(
> @iclientid)
> end
>
> where iclientid = int data type in the clients table.
> now if i pass @iclientid as @iclientid = '49,12,112'
>
> but this statement throws an conversion error ( int to char error).
>
> is there any way to fetch records from a select statement using a
> string???
>
> Thanks in Advance.
>

• Next in forum: Re: Querying Windows Active Directory from Sql Server 2000
• Prev in forum: Re: comma separated values to stored procedures
• Thread view: Re: comma separated values to stored procedures

[Reply to this message]