is it possible to replace While loop by cte ?

• ravi@sql

  SSCrazy

  Points: 2121

  More actions

  August 11, 2015 at 1:24 am

  #301820

  HI Folks,

  Is it possible to replace while loop by CTE?

  I will fetch records from table 1 based on tretmentid.

  get the count of records

  run the while loop

  inside loop i will compare the column values with the same table(table 1) for different tretmentid.

  if any one row matches will come out from loop and send status .

  can it be replaced by CTE ?

  Regards,

  Ravi

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  August 11, 2015 at 1:31 am

  #1818805

  ravi@sql (8/11/2015)

  ---

  HI Folks,

  Is it possible to replace while loop by CTE?

  I will fetch records from table 1 based on tretmentid.

  get the count of records

  run the while loop

  inside loop i will compare the column values with the same table(table 1) for different tretmentid.

  if any one row matches will come out from loop and send status .

  can it be replaced by CTE ?

  Regards,

  Ravi

  Maybe. But without seeing your code, can't say for sure.

  By the way, a CTE is just a glorified subquery, nothing more.

  ---