I get the following error when trying to check the sql script from page 6 of Historical Inventory Trail Balance Report under Installing the HITB Inventory reset tool.
Server: Msg 170, Level 15, State 1, Procedure EEUpdateAVGRCTSEQNM, Line 82
Line 82: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Procedure EEUpdateAVGRCTSEQNM, Line 96
Line 96: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Procedure EEUpdateAVGRCTSEQNM, Line 129
Line 129: Incorrect syntax near '('.
here is the script the error takes me to next to last line is where the first error code above takes me to
If OBJECT_ID('tempdb..#ItemList') IS NULL
BEGIN
CREATE TABLE #ItemList(
ITEMNMBR CHAR (31),
ADJUNITCOST NUMERIC (19,5),
NEXTRCTSEQNM INT)
END
CREATE NONCLUSTERED INDEX [ItemList_1] ON [dbo].[#ItemList]
(
[ITEMNMBR] ASC
)WITH (PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
Any idea?
Thanks
Rick
*This post is locked for comments