recompile grouped procedures?

• minea vasile

  Grasshopper

  Points: 20

  More actions

  October 26, 2004 at 8:15 am

  #109608

   

  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

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  October 28, 2004 at 9:15 am

  #528318

  Please post your questions in an appropriate forum. This forum is dedicated to the Question of the Day - which is a daily question about SQL Server. Everyday SQLSeverCentral posts a new QOD for everyone to answer, this forum is dedicated to discussing those posts.

  To see the Question of the Day, go to Resources>Question of the Day.

   

  -SQLBill