Retrieving some rows...

[lassala]

Hi, Everybody!

Imagine the following situations:

I'd like to bring from a table, just people from a list of Countries? How could I do the select statement... something as

select * from table
where inlist(country,'brazil','usa','france')

Well, I'll pass to some function a list of possible values of my table...

Is there some way?

 

[tlbroadbent]

Create a stored procedure that create and executes a SQL statement.

Create procedure ListPeopleFromCountries @ctry varchar(1024) As

Declare @sql nvarchar(2000)
Set quoted_identifier OFF

Set @sql="Select * From tblname Where Country In (" + @ctry + &quot"

Execute(@sql)
GO

Call the stored procedure like this.

exec ListPeopleFromCountries "'brazil','usa','france'" Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes