Without Loop

• Jus

  SSCrazy

  Points: 2534

  More actions

  May 20, 2009 at 10:04 am

  #134213

  Hello,

  I have one table like below. (say table name zz)

  BIDVceFDTV

  D901110

  D902110

  D903110

  D904101

  and there is another complex select statement which gives result set and BID from above table also part of this result set.

  Now, query is ..

  In the table zz, there are 3 columns...vce,fd,tv..if the value in these columns is 1 , then the result set of second query should have 2 records with corresponding BID.

  that means, for an example, BID =D901..two columns has the value 1 and one column with 0. then second result set should return 4 records with BID=901..

  I want this to be donw without loop.

  Please help...

  Jus

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 20, 2009 at 10:10 am

  #997747

  Prasad (5/20/2009)

  ---

  Hello,

  I have one table like below. (say table name zz)

  BIDVceFDTV

  D901110

  D902110

  D903110

  D904101

  and there is another complex select statement which gives result set and BID from above table also part of this result set.

  Now, query is ..

  In the table zz, there are 3 columns...vce,fd,tv..if the value in these columns is 1 , then the result set of second query should have 2 records with corresponding BID.

  that means, for an example, BID =D901..two columns has the value 1 and one column with 0. then second result set should return 4 records with BID=901..

  I want this to be donw without loop.

  Please help...

  Jus

  Instead of telling us what you want the result set to look like, show us based on the sample data provided. Also, show us what you have done so far to solve your problem.