Select Statement Help

• ajosh k john

  Valued Member

  Points: 69

  More actions

  November 22, 2005 at 2:03 am

  #92257

  Hi,

  I have a problem with select statement.

  For my report purpose i am creating a table dynamically based on a function retrived comma separated string .Itrating this string i created a table.For exp.IF my function retrive 1,2,3,4 like then dynamically i create a table having 4 fields.But the problem is that ,I have to itrate this 1,2,3,4 again and i have to put some count of values to the corresponding fields respectively.

  Thes 1,2,3,4 are some unique values and i am putting the description insteated of that numbers in the table.Can any body help me to select  the values from the table.

  by out put some this like this

  First    Second     Third     Fourth --->these are from a master table

  2         3               4         4       --->from another table

  5         6               2         6

  Thanks

  Ajosh

• Roy Rogers

  SSCertifiable

  Points: 7712

  More actions

  November 22, 2005 at 6:42 am

  #605209

  Can you give more details. When you iterate 1,2,3,4 again how to you realate that with another table.

  Regards,
  gova