How to Avoid Cursor

• jbhatt2

  SSC Enthusiast

  Points: 103

  More actions

  January 31, 2012 at 6:18 am

  #263571

  Hi,

  I have a common table expression that returns the below

  Num

  1

  2

  3

  I also have a select statement that returns something like

  Name

  ABC

  DEF

  I need to write a select statement that will result in the below:

  Num Name

  1 ABC

  2 ABC

  3 ABC

  1 DEF

  2 DEF

  3 DEF

  How can this be achieved without writing loop script?

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  January 31, 2012 at 6:23 am

  #1440567

  Is this homework? What have you tried so far? Hint: use CROSS JOIN.

  John

• arun1_m1

  SSCommitted

  Points: 1949

  More actions

  January 31, 2012 at 6:33 am

  #1440578

  Use cross join