Thank you! I think this is what you are asking for.. My Boss wants a Trigger and the reason is maybe to just get me use to writing more logic instead og updat, Delete, and insert along with basic SQL quires as well. Any help would be greatly appreciated
Thank you
USE [101WareTest]
GO
/****** Object: Table [dbo].[ProposalProfitSplitWorksheet] Script Date: 1/22/2014 3:24:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProposalProfitSplitWorksheet](
[WorksheetID] [int] IDENTITY(1,1) NOT NULL,
[DateTimeCreated] [datetime] NOT NULL,
[CreatedByUserID] [int] NOT NULL,
[CreatedByImpersonatingUserID] [int] NULL,
[ProposalUniqueID] [int] NOT NULL,
[ScenarioNumber] [int] NOT NULL,
[BillingBranchID] [int] NOT NULL,
[SiteSurveyBranchID] [int] NOT NULL,
[DateTimeAcceptedBySellingBranch] [datetime] NULL,
[AcceptedBySellingBranchUserID] [int] NULL,
[AcceptedBySellingBranchImpersonatingUserID] [int] NULL,
[DateTimeAcceptedByInstallingBranch] [datetime] NULL,
[AcceptedByInstallingBranchUserID] [int] NULL,
[AcceptedByInstallingBranchImpersonatingUserID] [int] NULL,
CONSTRAINT [PK_ProposalProfitSplitWorksheet] PRIMARY KEY CLUSTERED
(
[WorksheetID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] WITH CHECK ADD CONSTRAINT [FK_ProposalProfitSplitWorksheet_db_branches] FOREIGN KEY([BillingBranchID])
REFERENCES [dbo].[db_branches] ([BRID])
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] CHECK CONSTRAINT [FK_ProposalProfitSplitWorksheet_db_branches]
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] WITH CHECK ADD CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_AcceptedByInstallingBranchImpersonatingUserID] FOREIGN KEY([AcceptedByInstallingBranchImpersonatingUserID])
REFERENCES [dbo].[logins] ([LgID])
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] CHECK CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_AcceptedByInstallingBranchImpersonatingUserID]
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] WITH CHECK ADD CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_AcceptedByInstallingBranchUserID] FOREIGN KEY([AcceptedByInstallingBranchUserID])
REFERENCES [dbo].[logins] ([LgID])
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] CHECK CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_AcceptedByInstallingBranchUserID]
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] WITH CHECK ADD CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_AcceptedBySellingBranchImpersonatingUserID] FOREIGN KEY([AcceptedBySellingBranchImpersonatingUserID])
REFERENCES [dbo].[logins] ([LgID])
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] CHECK CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_AcceptedBySellingBranchImpersonatingUserID]
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] WITH CHECK ADD CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_AcceptedBySellingBranchUserID] FOREIGN KEY([AcceptedBySellingBranchUserID])
REFERENCES [dbo].[logins] ([LgID])
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] CHECK CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_AcceptedBySellingBranchUserID]
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] WITH CHECK ADD CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_CreatedByImpersonatingUserID] FOREIGN KEY([CreatedByImpersonatingUserID])
REFERENCES [dbo].[logins] ([LgID])
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] CHECK CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_CreatedByImpersonatingUserID]
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] WITH CHECK ADD CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_CreatedByUserID] FOREIGN KEY([CreatedByUserID])
REFERENCES [dbo].[logins] ([LgID])
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] CHECK CONSTRAINT [FK_ProposalProfitSplitWorksheet_logins_CreatedByUserID]
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] WITH CHECK ADD CONSTRAINT [FK_ProposalProfitSplitWorksheet_proposals] FOREIGN KEY([ProposalUniqueID])
REFERENCES [dbo].[proposals] ([UniqueID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] CHECK CONSTRAINT [FK_ProposalProfitSplitWorksheet_proposals]
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] WITH CHECK ADD CONSTRAINT [CK_ProposalProfitSplitWorksheet_ScenarioNumber] CHECK (([ScenarioNumber]=(2) OR [ScenarioNumber]=(1)))
GO
ALTER TABLE [dbo].[ProposalProfitSplitWorksheet] CHECK CONSTRAINT [CK_ProposalProfitSplitWorksheet_ScenarioNumber]