Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Fetching records

Author  Topic 

madhulatha_b
Starting Member

22 Posts

Posted - 2006-11-23 : 06:41:44
From application I need to pass multiple item codes in a single variable. I need to find records which are having these item codes in a table.

For example If I have item codes I1,I2,I3. I am concatenating these three codes into one variable i.e. tmp1 = 'I1','I2','I3'

Now I need to check for I1,I2,I3 values in table and fetch those records

How to do this

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-23 : 06:44:50
Check these links:

[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25830[/url]
[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6134[/url]

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-11-23 : 07:02:14

http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -