Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
Create Procedure [dbo].[AAA] @StoredProcName VarChar(100), @TermID INT = Null, @User VarChar(40) = Null, @Action VarChar(100) = Null AS SET NOCOUNT ON If exists(Select * from Clients..Licenses where [Name] like 'Clare%') Begin Set @StoredProcName = @StoredProcName + '_192' Case When @StoredProcName = 'AAA_192' then Execute @StoredProcName @User,@Action When @StoredProcName = 'AAA1_192' then Execute @StoredProcName Else Execute @StoredProcName @TermID,@User,@Action End End GO
Join the community of 500,000 technology professionals and ask your questions.