spExtensionInsert - Hightechrobo bin

SQL 5

SpExtensionInsert Guest on 14th July 2025 07:37:56 AM

USE [Billing-AJA]
GO
/****** Object: StoredProcedure [dbo].[spExtensionInsert] Script Date: 7/14/2025 11:06:56 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[spExtensionInsert]
@Extid nvarchar(250),
@Firstname nvarchar(250),
@Lastname nvarchar(250),
@Building nvarchar(50),
@FLOOR nvarchar(50),
@Room nvarchar(50),
@Address nvarchar(50),
@Description nvarchar(50),
@RingGroup nvarchar(50)
AS
BEGIN
IF EXISTS (SELECT 1 FROM [dbo].extension WHERE [Extension] = @Extid)
BEGIN
UPDATE [dbo].extension
SET
Firstname = @Firstname,
Lastname = @Lastname,
[RingGroup] = CASE WHEN @RingGroup = '1' THEN 'true' ELSE 'false' END
WHERE [Extension] = @Extid;
UPDATE [dbo].[extension-locations]
SET
[Building] = @Building,
[FLOOR] = @FLOOR,
[Room] = @Room,
[Address] = @Address,
[Description] = @Description
WHERE [ExtensionId] = @Extid;
END
ELSE
BEGIN
INSERT INTO [dbo].extension VALUES(@Extid,@Firstname,@Lastname,CASE WHEN @RingGroup = '1' THEN 'true' ELSE 'false' END)
INSERT INTO [dbo].[extension-locations] VALUES(@Extid,@Building,@FLOOR,@room,@Address,@Description)
END
END

Advertise here

Recent Pastes

Raw Paste

USE [Billing-AJA]
GO
/****** Object:  StoredProcedure [dbo].[spExtensionInsert]    Script Date: 7/14/2025 11:06:56 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[spExtensionInsert]
@Extid nvarchar(250),
@Firstname nvarchar(250),
@Lastname nvarchar(250),
@Building nvarchar(50),
@Floor nvarchar(50),
@Room nvarchar(50),
@Address nvarchar(50),
@Description nvarchar(50),
@RingGroup nvarchar(50)

as
BEGIN
	if exists (select 1 FROM [dbo].extension WHERE [Extension] = @Extid)
    BEGIN
	update [dbo].extension
        SET
            Firstname = @Firstname,
            Lastname = @Lastname,
            [RingGroup] = case when @RingGroup = '1' then 'true' else 'false' end
			where [Extension] = @Extid;

update [dbo].[extension-locations]
        set
            [Building] = @Building,
            [Floor] = @Floor,
            [Room] = @Room,
            [Address] = @Address,
            [Description] = @Description
        where [ExtensionId] = @Extid;
		  END

ELSE
		BEGIN
INSERT into [dbo].extension values(@Extid,@Firstname,@Lastname,case when @RingGroup = '1' then 'true' else 'false' end)
INSERT into [dbo].[extension-locations] values(@Extid,@Building,@Floor,@room,@Address,@Description)

end
END