Retrieving select query 1

[Weese]

Hi,

I need to retrieve from a select query from a string of values that's delimited using a delimiter...

I am having a data like this in myTable

maxYr minYr SysMakCd SysModCd SysModDes
1999 2001 Turky 0912 TurkyModDes
2002 2003 Turky 0912 TurkyLaterDes
1999 2002 Sando 0712 sandoModdes

In a stored Procedure I am passing parameter like

@Year = '|2000|2002|'
@SysMk = '|Turky|Turky|'
@SysMd = '|0912|0912|'

Using the above parameter, I have to write a query to fetch data like this
myCd myDes
2000 + Turky + 0912, TurkyModDes
2003 + Turky + 0912, TurkyLaterDes


Any idea is highly appreciated.

 

[cheyney]

This link might be useful to you in trying to iterate through a delimited string in a stored procedure

http://www.sqlteam.com/item.asp?ItemID=637

Cheyney