recompiled grouped procedure

• minea vasile

  Grasshopper

  Points: 20

  More actions

  October 26, 2004 at 7:43 am

  #162533

  when a procedure from a grup is recompiled.

  suppose i have

  create proc dbo.x

  as

  if cond dosome

  else doalt

  and i want to do something like

  create proc dbo.x;2

  as dosome

   

  create proc dbo.x;3

  as doalt

   and  create proc dbo.x;1

  x int=1

  as

  case x when 2 then exec dbo.x;2

  else exec dbo.x;3

   

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736430

  More actions

  October 26, 2004 at 9:55 am

  #528014

  It will compile the first time and that is all.