Table Ansi
2 March 2010
Table Ansi
 |
 Foot Operated Valve Hand Sink 16 x 15 W Faucet ETL $365.95 Time Remaining: 5d 5h 58m Buy It Now for only: $365.95 |
 2950 21 MAROON STACKING CHAPEL SANCTUARY CHURCH CHAIR $29.50 Time Remaining: 1d 1h 21m |
 True TSSU 48 12 Two Door 48 Refrigerated Salad Sandwich Prep Table NSF $1,395.00 Time Remaining: 20d 12h 51m Buy It Now for only: $1,395.00 |
 Turbo Air TST 28SD Commercial Refrigerated Salad and Sandwich Prep Table Cooler $1,282.25 Time Remaining: 29d 11h 15m Buy It Now for only: $1,282.25 |
 New Turbo Air TST 72SD Commercial Refrigerated 72 Salad and Sandwich Prep Table $2,320.67 Time Remaining: 29d 10h 50m Buy It Now for only: $2,320.67 |
 NEW Lifetime 4 feet Adjustable Fold in Half Stain Resistant White Table $53.98 Time Remaining: 29d 12h 44m Buy It Now for only: $53.98 |
 True TSSU 60 16 Food Prep Table Solid 2 Door Sandwich Salad Unit 115V $2,424.67 Time Remaining: 16d 1h 7m Buy It Now for only: $2,424.67 |
 New Turbo Air TST 48SD Commercial Refrigerated 48 Salad and Sandwich Prep Table $1,967.72 Time Remaining: 29d 10h 45m Buy It Now for only: $1,967.72 |
 Turbo Air TST 72SD 30 Commercial Refrigerated Salad Sandwich Prep Table 30 Bin $2,781.30 Time Remaining: 29d 11h 30m Buy It Now for only: $2,781.30 |
 New Turbo Air TST 60SD Commercial Refrigerated 60 Salad and Sandwich Prep Table $2,213.00 Time Remaining: 29d 11h 15m Buy It Now for only: $2,213.00 |
 2950 21 BLUE STACKING CHAPEL SANCTUARY CHURCH CHAIR $29.50 Time Remaining: 1d 1h 21m |
 32 2803 Lifetime Folding Almond Plastic Chairs Ship Inc $1,092.47 Time Remaining: 27d 19h 44m Buy It Now for only: $1,092.47 |
 True TSSU 48 18M B Food Prep Table Mega Top Solid 2 Door Sandwich Salad Unit $2,577.29 Time Remaining: 16d 6h 48m Buy It Now for only: $2,577.29 |
 30x24 Stainless Steel Equipment Stand $215.00 Time Remaining: 16d 5h 24m Buy It Now for only: $215.00 |
 BRAND NEW ULTIMATE HOT DOG CART TRAILER KIOSK $3,299.99 Time Remaining: 22d 2h 36m Buy It Now for only: $3,299.99 |
 Iceberg 65490 IndestrucTable TOO 1200 Series Resin Personal Folding Table $65.65 Time Remaining: 21d 22h 15m Buy It Now for only: $65.65 |
 TURBO AIR 48 Sandwich Salad Prep TST 48SD FREE SHIP $2,134.84 Time Remaining: 1d 8h 46m Buy It Now for only: $2,134.84 |
 All Stainless Work Table 30 x 14 w backsplash NSF $205.00 Time Remaining: 4d 3h 56m Buy It Now for only: $205.00 |
 Stainless Steel Work Table 30 x 14 w backsplash NSF $129.99 Time Remaining: 16d 5h 39m Buy It Now for only: $129.99 |
 2950 21 MIXED TAN STACKING CHAPEL SANCTUARY CHURCH CHAIR $29.50 Time Remaining: 1d 1h 22m |
 True TSSU 27 8D 2 Food Prep Table Solid Drawered Sandwich Salad Unit 115V $2,112.55 Time Remaining: 16d 3h 2m Buy It Now for only: $2,112.55 |
 Commercial Grade 10 Hand Held Meat Grinder $35.00 Time Remaining: 16d 5h 50m Buy It Now for only: $35.00 |
 TURBO AIR 44 Pizza Prep Table TPR 44SD FREE SHIPPING Stainless Louver $2,336.80 Time Remaining: 1d 8h 17m Buy It Now for only: $2,336.80 |
 24 x 24 Stainless Steel Equipment Mixer Table $239.00 Time Remaining: 19d 13h 51m Buy It Now for only: $239.00 |
 Clean Dish Table 24 Left or Right Side $259.00 Time Remaining: 16d 5h 51m Buy It Now for only: $259.00 |
 Iceberg 65377 IndestrucTable TOO 1200 Series Resin Folding Table Folding T $184.75 Time Remaining: 21d 22h 17m Buy It Now for only: $184.75 |
 TURBO AIR 93IN SUPER DELUXE 3 DOOR PIZZA SANDWICH PREP COOLER TPR 93SD $4,643.89 Time Remaining: 28d 9h 20m Buy It Now for only: $4,643.89 |
 Black Vinyl Reception Area Guest Side Office Chair $118.95 Time Remaining: 26d 10h 54m Buy It Now for only: $118.95 |
 NEW DORMONT 1 2x24 COUNTER TOP GAS LINE CONNECTER HOSE 1650npfs24 1 2x24 $45.99 Time Remaining: 21d 7h 33m Buy It Now for only: $45.99 |
 2950 21 GRAY STACKING CHAPEL SANCTUARY CHURCH CHAIR $29.50 Time Remaining: 1d 1h 22m |
 Commercial Grade 32 Table Mount Meat Grinder $69.00 Time Remaining: 16d 5h 50m Buy It Now for only: $69.00 |
 True TSSU 72 12 Food Prep Table Solid 3 Door Sandwich Salad Unit 115V $2,785.37 Time Remaining: 16d 1h 50m Buy It Now for only: $2,785.37 |
 New TRUE TPP 93 Commercial Pizza Prep Table Cooler $5,099.11 Time Remaining: 23d 1h 55m Buy It Now for only: $5,099.11 |
 Stainless Steel Work Table 30 x 36 w backsplash NSF $159.99 Time Remaining: 16d 5h 39m Buy It Now for only: $159.99 |
 TURBO AIR 36 Sandwich Salad Prep TST 36SD FREE SHIP $1,924.96 Time Remaining: 1d 8h 46m Buy It Now for only: $1,924.96 |
 True TSSU 48 8 Food Prep Table Solid 2 Door Sandwich Salad Unit 115V $2,063.21 Time Remaining: 16d 34m Buy It Now for only: $2,063.21 |
 Navy Vinyl Guest Conference Office Desk Side Chair $118.95 Time Remaining: 26d 11h 5m Buy It Now for only: $118.95 |
 True TSSU 72 18 Food Prep Table Solid 3 Door Sandwich Salad Unit 115V $2,856.89 Time Remaining: 16d 1h 56m Buy It Now for only: $2,856.89 |
 Randell 84111NPCB Refrigerated Prep Table $2,500.00 Time Remaining: 1d 7h 5m Buy It Now for only: $4,000.00 |
 True TSSU 36 8 Food Prep Table Solid 2 Door Sandwich Salad Unit 115V $1,996.65 Time Remaining: 16d 30m Buy It Now for only: $1,996.65 |
 Turbo Air Super Deluxe Series Pizza Prep Table TPR 67SD $2,960.00 Time Remaining: 3d 7h 10m Buy It Now for only: $2,960.00 |
 TURBO AIR 67IN S S SANDWICH PIZZA PREP COOLER TPR 67SD $3,571.92 Time Remaining: 28d 13h 20m Buy It Now for only: $3,571.92 |
 TURBO AIR 60 Mega Top Prep Table TST 60SD 24 FREE SHIP $2,614.00 Time Remaining: 1d 9h 19m Buy It Now for only: $2,614.00 |
 Stainless Steel Work Table 30 x 72 NSF $219.99 Time Remaining: 19d 5h 11m Buy It Now for only: $219.99 |
 Undercounter Dish Table Drainboard Left or Right $475.00 Time Remaining: 19d 12h 55m Buy It Now for only: $475.00 |
 NEW DORMONT 1 2 X 36 COUNTERTOP GAS CONNECTOR HOSE LINE CT1650KIT36 3 X 1 2 $48.96 Time Remaining: 4d 7h 3m Buy It Now for only: $48.96 |
 True TSSU 60 12 Food Prep Table Solid 2 Door Sandwich Salad Unit 115V $2,405.54 Time Remaining: 16d 1h 6m Buy It Now for only: $2,405.54 |
 Metalfrio MT84 Countertop Merchandiser Cooler $519.60 Time Remaining: 22d 1h 48m Buy It Now for only: $519.60 |
 1895 DELUXE FABRIC DOME BACK BANQUET STACKING CHURCH CHAIR $18.95 Time Remaining: 6d 2h 7m |
 Turbo Air Pizza Prep Table Super Deluxe Series TPR 93SD $4,643.89 Time Remaining: 24d 15h 8m Buy It Now for only: $4,643.89 |
 24 x 30 Stainless Steel Equipment Mixer Table $259.00 Time Remaining: 19d 13h 52m Buy It Now for only: $259.00 |
 Stainless Steel Work Table 24 x 72 w backsplash NSF $182.99 Time Remaining: 19d 12h 55m Buy It Now for only: $182.99 |
 True TSSU 48 10 Food Prep Table Solid 2 Door Sandwich Salad Unit 115V $2,200.52 Time Remaining: 16d 38m Buy It Now for only: $2,200.52 |
 Double Tiered Table Mounted Overshelf 12x72 $369.00 Time Remaining: 16d 5h 14m Buy It Now for only: $369.00 |
 Turbo Air Low Boy Model TUR60SD Used Good Condition $850.00 Time Remaining: 11d 6h 16m Buy It Now for only: $850.00 |
 True TSSU 36 12M B Food Prep Table Mega Top Solid 2 Door Sandwich Salad Unit $2,292.71 Time Remaining: 16d 6h 30m Buy It Now for only: $2,292.71 |
 TURBO AIR 48 Mega Top Prep Table TST 48SD 18 FREE SHIP $2,375.60 Time Remaining: 1d 9h 19m Buy It Now for only: $2,375.60 |
 2950 21 DARK BROWN STACKING CHAPEL SANCTUARY CHURCH CHAIR $29.50 Time Remaining: 8d 1h 54m |
 True TSSU 60 18M B ADA Food Prep TableADA Compliant MegaTop Sandwich Salad Unit $2,816.35 Time Remaining: 17d 8h 33m Buy It Now for only: $2,816.35 |
 True TSSU 72 16 Food Prep Table Solid 3 Door Sandwich Salad Unit 115V $2,807.93 Time Remaining: 16d 1h 54m Buy It Now for only: $2,807.93 |
 Stainless Steel Work Table 30 x 24 w backsplash NSF $131.99 Time Remaining: 16d 5h 39m Buy It Now for only: $131.99 |
 Dipperwell Sink Wall Mount NSF No Lead Faucet $113.00 Time Remaining: 14d 10h 45m Buy It Now for only: $113.00 |
 Double Tiered Table Mounted Overshelf 16x48 $349.99 Time Remaining: 18d 2h 4m Buy It Now for only: $349.99 |
 TURBO AIR 28 Mega Top Prep Table TST 28SD 12 FREE SHIP $1,637.86 Time Remaining: 3d 23h 27m Buy It Now for only: $1,637.86 |
 Black Vinyl Reception Guest Side Office Chair $128.95 Time Remaining: 26d 10h 54m Buy It Now for only: $128.95 |
 True TSSU 27 8D 2 ADA Food Prep TableADA Compliant Dual Sandwich Salad Unit $2,112.55 Time Remaining: 17d 6h 42m Buy It Now for only: $2,112.55 |
 Dipperwell Sink Drop In NSF No Lead Faucet $112.00 Time Remaining: 14d 10h 50m Buy It Now for only: $112.00 |
 2199 DELUXE FABRIC CROWN BACK STACKING CHURCH CHAIR $21.99 Time Remaining: 8d 1h 55m |
 NEW TRUE SANDWICH SALAD FOOD PREP TABLES 27 TSSU 27 8 $1,478.37 Time Remaining: 21d 8h 35m Buy It Now for only: $1,478.37 |
 TURBO AIR 28 Sandwich Salad Prep TST 28SD FREE SHIP $1,391.15 Time Remaining: 1d 8h 46m Buy It Now for only: $1,391.15 |
 True TSSU 27 12M C Food Prep Table Mega Top Solid Door Sandwich Salad Unit $1,767.53 Time Remaining: 16d 3h 35m Buy It Now for only: $1,767.53 |
 True TSSU 60 8 Food Prep Table Solid 2 Door Sandwich Salad Unit 115V $2,368.82 Time Remaining: 16d 56m Buy It Now for only: $2,368.82 |
 True TSSU 36 8 ADA Food Prep TableADA Compliant Solid Door Sandwich Salad Unit $1,996.65 Time Remaining: 17d 2h 14m Buy It Now for only: $1,996.65 |
 True TSSU 48 8 ADA Food Prep TableADA Compliant Solid Door Sandwich Salad Unit $2,063.21 Time Remaining: 17d 2h 17m Buy It Now for only: $2,063.21 |
 True TSSU 27 12M B ADA Food Prep TableADA Compliant MegaTop Sandwich Salad Unit $1,767.53 Time Remaining: 17d 6h 59m Buy It Now for only: $1,767.53 |
 Single Tiered Table Mounted Overshelf 12x60 $209.00 Time Remaining: 16d 5h 15m Buy It Now for only: $209.00 |
 1895 DELUXE FABRIC DOME BACK BANQUET STACKING CHURCH CHAIR $18.95 Time Remaining: 8d 1h 55m |
 True TSSU 60 10 Food Prep Table Solid 2 Door Sandwich Salad Unit 115V $2,387.95 Time Remaining: 16d 1h 4m Buy It Now for only: $2,387.95 |
 True TSSU 72 8 Food Prep Table Solid 3 Door Sandwich Salad Unit 115V $2,738.70 Time Remaining: 16d 1h 46m Buy It Now for only: $2,738.70 |
 True TSSU 72 10 Food Prep Table Solid 3 Door Sandwich Salad Unit 115V $2,762.03 Time Remaining: 16d 1h 49m Buy It Now for only: $2,762.03 |
 True TSSU 48 10 ADA Food Prep TableADA Compliant Solid Door Sandwich Salad Unit $2,200.52 Time Remaining: 17d 2h 21m Buy It Now for only: $2,200.52 |
 True TSSU 36 12M B ADA Food Prep TableADA Compliant MegaTop Sandwich Salad Unit $2,292.71 Time Remaining: 17d 7h 29m Buy It Now for only: $2,292.71 |
 True TSSU 60 12M B ADA Food Prep TableADA Compliant MegaTop Sandwich Salad Unit $2,781.92 Time Remaining: 17d 8h 29m Buy It Now for only: $2,781.92 |
 Double Tiered Table Mounted Overshelf 12x48 $299.00 Time Remaining: 16d 5h 14m Buy It Now for only: $299.00 |
 True TSSU 27 8 Food Prep Table Solid Door Sandwich Salad Unit 115V $1,478.36 Time Remaining: 15d 9h 6m Buy It Now for only: $1,478.36 |
Whats wrong with this SQL query?
USE [Cost]
GO
/****** Object: Table [dbo].[CostTable] Script Date: 06/08/2007 12:05:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CostTable](
[ID] [int] IDENTITY(1,1) NOT NULL,
[AccountingMonth] [int] NOT NULL,
[ExpenseCategory] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[PrimaryCostArea] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[SecondaryCostArea] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[Cost] [float] NULL,
CONSTRAINT [PK_CostTable] PRIMARY KEY CLUSTERED
(
[ID] ASC
) WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
---------------
Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
---------------
Which is line "[ExpenseCategory] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL" but I can't see anything wrong with it...
This is weird, the syntax looks all correct, yet I get the same thing in Query Analyzer, it seems the error originates from the PAD_INDEX and IGNORE_DUP_KEY syntax, but that looks correct also, if I run it without this, it Parses fine. Strange one.
I havent tried it but perhaps you could create the table and then ALTER TABLE and add the indexes.
USE [Cost]
GO
/****** Object: Table [dbo].[CostTable] Script Date: 06/08/2007 12:05:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CostTable](
[ID1] [int] IDENTITY(1,1) NOT NULL,
[AccountingMonth] [int](4) NOT NULL,
[ExpenseCategory] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[PrimaryCostArea] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[SecondaryCostArea] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[Cost] [float] NULL,
CONSTRAINT [PK_CostTable] PRIMARY KEY CLUSTERED
(
[ID1] ASC
) ON [PRIMARY]
) ON [PRIMARY]
