SP Group Number

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  August 12, 2002 at 10:21 pm

  #105249

  Does anyone know how do I determine the last number used within a set of a group of stored procedures?

  For example, I have created the following Stored procedures:

  mySP;1

  mySp;2

  mySp;3

  mySp;4

  How do I determine that for the mySP procedure, there are 4 stored procedures within it?

  Thanks in advance

  Billy

• NPeeters

  SSChampion

  Points: 12536

  More actions

  August 13, 2002 at 12:24 am

  #434471

  You can use the following statement.

  select max(number) from sysobjects o, syscomments c where o.name = 'mySP' and o.id = c.id

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  August 13, 2002 at 1:08 am

  #434473

  thanks!