SUM(Case) issue

Question

SUM(Case) issue

Viewing 6 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Mike01 SSChampion Points: 11420 More actions · Answer 1

Your script doesn't work. Only one table is created, it errors out on the Foreign Key and the inserts fail. Can you provide a valid script for all 3 tables in the query as well as valid data?

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Happened to me as well. Please test your scripts before posting them. We are volunteers and have our own work to do instead of testing and correcting your scripts.

kabaari SSCrazy Points: 2235 More actions · Answer 3

USE [productDetails]

GO

/****** Object: Table [dbo].[tbl_Assembly_Holds] Script Date: 12/03/2009 09:21:22 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_Assembly_Holds](

[TagNumber] [float] NOT NULL,

[WorkOrder] [nvarchar](7) NOT NULL,

[WOUnit] [nvarchar](2) NOT NULL,

[WOYear] [nvarchar](4) NOT NULL,

[Inspect_EmpNo] [int] NOT NULL,

[Inspect_Date] [datetime] NOT NULL,

[Disposition_ID] [int] NOT NULL,

[Comment] [nvarchar](400) NULL,

[Repair_EmpNo] [float] NULL,

[Repair_Date] [datetime] NULL,

[Repair_Notes] [nvarchar](50) NULL,

[Rejar] [smallint] NULL,

[Record_Date] [datetime] NOT NULL,

CONSTRAINT [PK_tbl_Assembly_Holds] PRIMARY KEY CLUSTERED

(

[TagNumber] 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].[tbl_Assembly_Holds] WITH CHECK ADD CONSTRAINT [FK_tbl_Assembly_Holds_tlkp_Employees] FOREIGN KEY([Repair_EmpNo])

REFERENCES [dbo].[tlkp_Employees] ([EmpNo])

GO

ALTER TABLE [dbo].[tbl_Assembly_Holds] CHECK CONSTRAINT [FK_tbl_Assembly_Holds_tlkp_Employees]

INSERT INTO Holds

(TagNumber,WorkOrder,WOUnit,WOYear,Inspect_EmpNo,Inspect_Date,Disposition_ID,Comment,Repair_EmpNo,Repair_Date,Repair_Notes,Rejar,Record_Date)

SELECT '48362','71940','30','2009','449','2009-11-30 00:00:00.000','2','Spacer plate rolled under','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48370','71124','11','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48372','71124','7','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48543','72128','5','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48544','71069','16','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48545','72126','12','2009','449','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48546','70271','10','2009','449','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48547','72127','6','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48548','72127','7','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48549','70271','14','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48550','70273','1','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48551','71113','2','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48552','71113','1','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48657','72216','3','2009','724','2009-11-30 00:00:00.000','2','Air Bubbles in Epoxy','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48658','72224','1','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48660','72216','13','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48661','72216','12','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48662','72216','10','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48663','72216','9','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48664','72216','11','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48665','72216','5','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48666','72216','6','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48667','72216','8','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48668','72216','7','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48753','71118','1','2009','449','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48754','71118','4','2009','449','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48755','72226','8','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48756','71070','9','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48757','70273','5','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48758','71114','12','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48759','71110','4','2009','724','2009-11-30 00:00:00.000','2','Melt Down','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48760','71114','11','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48761','72226','51','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48762','72226','47','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48763','71111','15','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48767','71113','15','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48768','71113','13','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48769','71113','12','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48770','71940','29','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48771','71113','5','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48772','71113','4','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48773','71113','3','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48774','71119','13','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48775','71119','11','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48776','71109','8','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48777','71109','6','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48778','71109','4','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48779','71113','14','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48780','71114','5','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48781','71940','51','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48782','71109','3','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48783','71114','4','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48784','71114','2','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48785','71940','47','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48786','70273','9','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48787','71114','1','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

SELECT '48788','71111','11','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'

SELECT '48789','71109','11','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

Mike01 SSChampion Points: 11420 More actions · Answer 4

kabaari,

this code is wrong. Your original query used these 3 tables:

tbl_assembly_production

tbl_assembly_holds

tbl_Assembly_hold_defects

You provided a table layout for tbl_assembly_holds, but the inserts are wrong since there is no table called holds. Also, your script is creating a foreign key that references [dbo].[tlkp_Employees], but we don't know what that looks like. If you want help, you need to provide valid scripts and table layouts. Try testing them first before submitting them.

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

kabaari (12/3/2009)
USE [productDetails] GO /****** Object: Table [dbo].[tbl_Assembly_Holds] Script Date: 12/03/2009 09:21:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tbl_Assembly_Holds]( [TagNumber] [float] NOT NULL, [WorkOrder] [nvarchar](7) NOT NULL, [WOUnit] [nvarchar](2) NOT NULL, [WOYear] [nvarchar](4) NOT NULL, [Inspect_EmpNo] [int] NOT NULL, [Inspect_Date] [datetime] NOT NULL, [Disposition_ID] [int] NOT NULL, [Comment] [nvarchar](400) NULL, [Repair_EmpNo] [float] NULL, [Repair_Date] [datetime] NULL, [Repair_Notes] [nvarchar](50) NULL, [Rejar] [smallint] NULL, [Record_Date] [datetime] NOT NULL, CONSTRAINT [PK_tbl_Assembly_Holds] PRIMARY KEY CLUSTERED ( [TagNumber] 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].[tbl_Assembly_Holds] WITH CHECK ADD CONSTRAINT [FK_tbl_Assembly_Holds_tlkp_Employees] FOREIGN KEY([Repair_EmpNo]) REFERENCES [dbo].[tlkp_Employees] ([EmpNo]) GO ALTER TABLE [dbo].[tbl_Assembly_Holds] CHECK CONSTRAINT [FK_tbl_Assembly_Holds_tlkp_Employees] INSERT INTO Holds (TagNumber,WorkOrder,WOUnit,WOYear,Inspect_EmpNo,Inspect_Date,Disposition_ID,Comment,Repair_EmpNo,Repair_Date,Repair_Notes,Rejar,Record_Date) SELECT '48362','71940','30','2009','449','2009-11-30 00:00:00.000','2','Spacer plate rolled under','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48370','71124','11','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48372','71124','7','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48543','72128','5','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48544','71069','16','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48545','72126','12','2009','449','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48546','70271','10','2009','449','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48547','72127','6','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48548','72127','7','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48549','70271','14','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48550','70273','1','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48551','71113','2','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48552','71113','1','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48657','72216','3','2009','724','2009-11-30 00:00:00.000','2','Air Bubbles in Epoxy','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48658','72224','1','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48660','72216','13','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48661','72216','12','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48662','72216','10','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48663','72216','9','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48664','72216','11','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48665','72216','5','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48666','72216','6','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48667','72216','8','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48668','72216','7','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48753','71118','1','2009','449','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48754','71118','4','2009','449','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48755','72226','8','2009','449','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48756','71070','9','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48757','70273','5','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48758','71114','12','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48759','71110','4','2009','724','2009-11-30 00:00:00.000','2','Melt Down','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48760','71114','11','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48761','72226','51','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48762','72226','47','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48763','71111','15','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48767','71113','15','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48768','71113','13','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48769','71113','12','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48770','71940','29','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48771','71113','5','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48772','71113','4','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48773','71113','3','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48774','71119','13','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48775','71119','11','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48776','71109','8','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48777','71109','6','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48778','71109','4','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48779','71113','14','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48780','71114','5','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48781','71940','51','2009','724','2009-11-30 00:00:00.000','2','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48782','71109','3','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48783','71114','4','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48784','71114','2','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48785','71940','47','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000' SELECT '48786','70273','9','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48787','71114','1','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000' SELECT '48788','71111','11','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-11-30 00:00:00.000'
SELECT '48789','71109','11','2009','724','2009-11-30 00:00:00.000','1','','NULL','NULL','NULL','NULL','2009-12-01 00:00:00.000'

The above won't work. There is no table named Holds. Again, please TEST your scripts prior to posting them.

kabaari SSCrazy Points: 2235 More actions · Answer 6

kabaari

SSCrazy

Points: 2235

December 3, 2009 at 8:32 am

#1087145

Lynn / Lowell,

Thanks for the help.

Khalif