SQL Query help

• moorthy.jy

  SSCommitted

  Points: 1753

  More actions

  October 19, 2009 at 12:07 am

  #99889

  I have a table looks like this.

  CREATE TABLE #TMP (ID INT, TERM VARCHAR(100))

  GO

  INSERT #TMP

  SELECT 1,'012345'

  UNION

  SELECT 2,'012345/655432'

  UNION

  SELECT 3,'534443'

  UNION

  SELECT 4,'987654/765432/324544'

  and, i want to see the results

  IDTERM

  1012345

  2012345

  2655432

  3534443

  4987654

  4765432

  4324544

  Please help me with this query

  Thanks in advance.

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  October 19, 2009 at 1:15 am

  #1067527

  Try this link

  http://www.sommarskog.se/arrays-in-sql-2005.html

  ---

  
  Clear Sky SQL
  My Blog[/url]

• moorthy.jy

  SSCommitted

  Points: 1753

  More actions

  October 19, 2009 at 2:25 am

  #1067538

  Thank you Dave. This is what i need. I also need this solution to work with SQL 2000. Is there any way?

  Thanks

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  October 19, 2009 at 2:31 am

  #1067540

  There was a link in that document

  http://www.sommarskog.se/arrays-in-sql-2000.html

  ---

  
  Clear Sky SQL
  My Blog[/url]

• moorthy.jy

  SSCommitted

  Points: 1753

  More actions

  October 19, 2009 at 2:35 am

  #1067542

  Thanks dave. There is another link. I just overlooked it. Thanks again.