how to get total count from outer query cursor

• mcfarlandparkway

  SSCertifiable

  Points: 7699

  More actions

  March 23, 2017 at 12:37 pm

  #336258

  I have a cursor where it has select query
  select col1,col2,col3 from table
  where col1 is not null
  group bycol1,col2,col3

  I need a count of the query so that i can use it in inner query, How to get the count form the abouve query? need to keep it in a variable?

• drew.allen

  SSC Guru

  Points: 76996

  More actions

  March 23, 2017 at 12:45 pm

  #1934628

  Please don't create multiple threads for the same issue.

  Please respond here

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA