Wrapping 91 sql''s

• joe joe-152023

  SSCommitted

  Points: 1819

  More actions

  May 30, 2006 at 7:54 am

  #90064

  Hi There,

  I have 92 different sql's with different logical checks of the data quality in a database, the checks holds a count of errors per area.

  Now I want to make a spreadsheet with counts of all these checks, distributed on different areas. Like this,

  Area_code;Check_1;Check_2;Check_3......ect

  6796;5;6;19......

  8346;35;56;75.....

  Can I wrap all the sql's into one single query? Or is there a more simple/better way to do this?

  Bests

  Joejoe

• Mike C

  SSC-Insane

  Points: 23224

  More actions

  May 30, 2006 at 8:27 am

  #640702

  You could execute all of your 91 queries from a single Stored Procedure...