Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
CREATE TABLE [dbo].[CUSTOMER_CONTACT_STD]( [SERIAL] [int] NOT NULL, [PROFILE] [tinyint] IDENTITY(0,1) NOT NULL, [PROFILE_NAME] [varchar](200) NOT NULL, [NAME_CURRENT] [varchar](200) NOT NULL, [MIDDLE_NAME_CURRENT] [varchar](200) NULL, [SURNAME_CURRENT] [varchar](200) NOT NULL, CONSTRAINT [PK_CUSTOMER_CONTACT_STD] PRIMARY KEY CLUSTERED ( [SERIAL] ASC, [PROFILE] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Nick Ms> -- Create date: <23/12/2012> -- Description: <Fills up missing profile numbers in CUSTOMER_CONTACT_STD or goes on with the next available profile number> -- ============================================= CREATE TRIGGER [dbo].[CUSTOMER_CONTACT_STD_Insert_PROFILE] ON [dbo].[CUSTOMER_CONTACT_STD] FOR INSERT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; UPDATE dbo.CUSTOMER_CONTACT_STD SET PROFILE = ( SELECT MIN(t1.PROFILE)+1 FROM CUSTOMER_CONTACT_STD t1 LEFT JOIN CUSTOMER_CONTACT_STD t2 ON t1.PROFILE = t2.PROFILE-1 WHERE t2.PROFILE IS NULL ) FROM dbo.CUSTOMER_CONTACT_STD INNER JOIN INSERTED ins ON CUSTOMER_CONTACT_STD.PROFILE = ins.PROFILE END GO
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
24 Experts available now in Live!