Job Step To Big
Jan 31, 2002I am trying to run the code below as a step in a job, but I cannot get this much code in the step. Is there another way of running this code? I tried putting the code inside of an SP, but I got errors there too.
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_importthis
(
Confirmation varchar(50) NULL,
StartDate datetime NULL,
C1_1 char(3) NULL,
C1_2 char(6) NULL,
C1_3 datetime NULL,
C1_4 datetime NULL,
C1_5 varchar(55) NULL,
C1_6 money NULL,
C1_7 int NULL,
C1_8 char(9) NULL,
C1_9 varchar(5) NULL,
PRDept char(2) NULL,
TypeVisit int NULL,
C2_1 int NULL,
C2_2 int NULL,
C2_3 bit NULL,
C2_4 int NULL,
C2_5 bit NULL,
C2_6 varchar(50) NULL,
C2_7 char(1) NULL,
C2_8 char(1) NULL,
C2_9 char(1) NULL,
C2_10 char(1) NULL,
C2_11 char(1) NULL,
C2_12 char(1) NULL,
C2_13 char(1) NULL,
C2_14 int NULL,
C2_15 bit NULL,
C2_16 bit NULL,
C2_17 bit NULL,
C2_18 bit NULL,
C3_1 int NULL,
C3_2 int NULL,
C3_3 bit NULL,
C3_4 bit NULL,
C3_5 bit NULL,
C3_6 bit NULL,
C3_7 bit NULL,
C3_8 bit NULL,
C3_9 bit NULL,
C5_1 bit NULL,
C5_2 bit NULL,
C5_3 bit NULL,
C5_4 bit NULL,
C5_5 bit NULL,
C6_1 bit NULL,
C6_2 text NULL,
C6_3 bit NULL,
C6_4 text NULL,
C6_5 bit NULL,
C6_6 text NULL,
C6_7 bit NULL,
C6_8 bit NULL,
C6_9 bit NULL,
C6_10 text NULL,
C7_1 bit NULL,
C7_2 bit NULL,
C7_3 bit NULL,
C7_4 bit NULL,
C8_1 int NULL,
C8_2 int NULL,
C8_3 bit NULL,
C8_4 bit NULL,
C8_5 bit NULL,
C9_1 bit NULL,
C9_2 bit NULL,
C10_1 bit NULL,
C11_1 bit NULL,
C13_1 bit NULL,
C13_2 bit NULL,
C13_3 bit NULL,
C13_4 bit NULL,
C13_5 bit NULL,
LODept char(1) NULL,
C15_1 int NULL,
C15_2 int NULL,
C15_3 bit NULL,
C15_4 int NULL,
C15_5 bit NULL,
C15_6 varchar(50) NULL,
C15_7 char(2) NULL,
C15_8 char(2) NULL,
C15_9 char(2) NULL,
C15_10 char(2) NULL,
C15_11 char(2) NULL,
C15_12 char(2) NULL,
C15_13 char(2) NULL,
C15_14 int NULL,
C15_15 bit NULL,
C15_16 bit NULL,
C15_17 bit NULL,
C15_18 bit NULL,
C15_19 varchar(255) NULL,
C16_1 bit NULL,
C16_2 text NULL,
C16_3 bit NULL,
C16_4 text NULL,
C16_5 bit NULL,
C16_6 text NULL,
C16_7 bit NULL,
C16_8 bit NULL,
C16_9 bit NULL,
C16_10 text NULL,
C16_11 bit NULL,
C16_12 char(10) NULL,
C16_13 text NULL,
C16_14 bit NULL,
C16_15 bit NULL,
C16_16 text NULL,
Comments text NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.importthis)
EXEC('INSERT INTO dbo.Tmp_importthis(Confirmation, StartDate, C1_1, C1_2, C1_3, C1_4, C1_5, C1_6, C1_7, C1_8, C1_9, PRDept, TypeVisit, C2_1, C2_2, C2_3, C2_4, C2_5, C2_6, C2_7, C2_8, C2_9, C2_10, C2_11, C2_12, C2_13, C2_14, C2_15, C2_16, C2_17, C2_18, C3_1, C3_2, C3_3, C3_4, C3_5, C3_6, C3_7, C3_8, C3_9, C5_1, C5_2, C5_3, C5_4, C5_5, C6_1, C6_2, C6_3, C6_4, C6_5, C6_6, C6_7, C6_8, C6_9, C6_10, C7_1, C7_2, C7_3, C7_4, C8_1, C8_2, C8_3, C8_4, C8_5, C9_1, C9_2, C10_1, C11_1, C13_1, C13_2, C13_3, C13_4, C13_5, LODept, C15_1, C15_2, C15_3, C15_4, C15_5, C15_6, C15_7, C15_8, C15_9, C15_10, C15_11, C15_12, C15_13, C15_14, C15_15, C15_16, C15_17, C15_18, C15_19, C16_1, C16_2, C16_3, C16_4, C16_5, C16_6, C16_7, C16_8, C16_9, C16_10, C16_11, C16_12, C16_13, C16_14, C16_15, C16_16, Comments)
SELECT CONVERT(varchar(50), Confirmation), CONVERT(datetime, StartDate), CONVERT(char(3), [1-1]), CONVERT(char(6), [1-2]), CONVERT(datetime, [1-3]), CONVERT(datetime, [1-4]), CONVERT(varchar(55), [1-5]), CONVERT(money, [1-6]), CONVERT(int, [1-7]), CONVERT(char(9), [1-8]), CONVERT(varchar(5), [1-9]), CONVERT(char(2), [Purchase/ReturnDept]), CONVERT(int, TypeVisit), CONVERT(int, [2-1]), CONVERT(int, [2-2]), CONVERT(bit, [2-3]), CONVERT(int, [2-4]), CONVERT(bit, [2-5]), CONVERT(varchar(50), [2-6]), CONVERT(char(1), [2-7]), CONVERT(char(1), [2-8]), CONVERT(char(1), [2-9]), CONVERT(char(1), [2-10]), CONVERT(char(1), [2-11]), CONVERT(char(1), [2-12]), CONVERT(char(1), [2-13]), CONVERT(int, [2-14]), CONVERT(bit, [2-15]), CONVERT(bit, [2-16]), CONVERT(bit, [2-17]), CONVERT(bit, [2-18]), CONVERT(int, [3-1]), CONVERT(int, [3-2]), CONVERT(bit, [3-3]), CONVERT(bit, [3-4]), CONVERT(bit, [3-5]), CONVERT(bit, [3-6]), CONVERT(bit, [3-7]), CONVERT(bit, [3-8]), CONVERT(bit, [3-9]), CONVERT(bit, [5-1]), CONVERT(bit, [5-2]), CONVERT(bit, [5-3]), CONVERT(bit, [5-4]), CONVERT(bit, [5-5]), CONVERT(bit, [6-1]), CONVERT(text, [6-2]), CONVERT(bit, [6-3]), CONVERT(text, [6-4]), CONVERT(bit, [6-5]), CONVERT(text, [6-6]), CONVERT(bit, [6-7]), CONVERT(bit, [6-8]), CONVERT(bit, [6-9]), CONVERT(text, [6-10]), CONVERT(bit, [7-1]), CONVERT(bit, [7-2]), CONVERT(bit, [7-3]), CONVERT(bit, [7-4]), CONVERT(int, [8-1]), CONVERT(int, [8-2]), CONVERT(bit, [8-3]), CONVERT(bit, [8-4]), CONVERT(bit, [8-5]), CONVERT(bit, [9-1]), CONVERT(bit, [9-2]), CONVERT(bit, [10-1]), CONVERT(bit, [11-1]), CONVERT(bit, [13-1]), CONVERT(bit, [13-2]), CONVERT(bit, [13-3]), CONVERT(bit, [13-4]), CONVERT(bit, [13-5]), CONVERT(char(1), LookOnlyDept), CONVERT(int, [15-1]), CONVERT(int, [15-2]), CONVERT(bit, [15-3]), CONVERT(int, [15-4]), CONVERT(bit, [15-5]), CONVERT(varchar(50), [15-6]), CONVERT(char(2), [15-7]), CONVERT(char(2), [15-8]), CONVERT(char(2), [15-9]), CONVERT(char(2), [15-10]), CONVERT(char(2), [15-11]), CONVERT(char(2), [15-12]), CONVERT(char(2), [15-13]), CONVERT(int, [15-14]), CONVERT(bit, [15-15]), CONVERT(bit, [15-16]), CONVERT(bit, [15-17]), CONVERT(bit, [15-18]), [15-19], CONVERT(bit, [16-1]), CONVERT(text, [16-2]), CONVERT(bit, [16-3]), CONVERT(text, [16-4]), CONVERT(bit, [16-5]), CONVERT(text, [16-6]), CONVERT(bit, [16-7]), CONVERT(bit, [16-8]), CONVERT(bit, [16-9]), CONVERT(text, [16-10]), CONVERT(bit, [16-11]), CONVERT(char(10), [16-12]), CONVERT(text, [16-13]), CONVERT(bit, [16-14]), CONVERT(bit, [16-15]), CONVERT(text, [16-16]), CONVERT(text, Comments) FROM dbo.importthis TABLOCKX')
GO
DROP TABLE dbo.importthis
GO
EXECUTE sp_rename 'dbo.Tmp_importthis', 'importthis'
GO
COMMIT