SP Correction

Feb 12, 2014 at 2:56 PM
first, thanks for your job!

It work great! (I would have dreamed to have a script to parse Calculated Measures ^^ )


Just a correction for next users, you must change sp_AMODBServer procedure

Now :
IF OBJECT_ID('sp_AMODBServer','P') IS NOT NULL
DROP PROC sp_AMODBServer
GO
CREATE PROCEDURE sp_AMODBServer 
 @ServerName sysname = NULL
,@ServerId       int OUTPUT
AS
    SELECT @ServerId = isnull(MAX(ServerID),0) + 1
      FROM [Server]
 
    INSERT INTO dbo.Server
    (ServerId,ServerName)
    SELECT @ServerId,@ServerNamet
 

 
GO
With
IF OBJECT_ID('sp_AMODBServer','P') IS NOT NULL
DROP PROC sp_AMODBServer
GO
CREATE PROCEDURE sp_AMODBServer 
 @ServerName sysname = NULL
,@ServerId       int OUTPUT
AS
    SELECT @ServerId = isnull(MAX(ServerID),0) + 1
      FROM [Server]
 
    INSERT INTO dbo.Server
    (Id,Name)
    SELECT @ServerId,@ServerNamet
 

 
GO
Thanks a lot,
Arnaud