Receiving an syntax error
-
=================Product-----------------
1 Symphony 96 16 This is the model name Symphony_1501.jpg Looks like an ordinary bumThese Roman Shades will make you feel as if you were sitting on a piece of stone... NULL 1 2005-06-08 00:00:00.000 2005-06-10 00:00:00.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
2 Collector Heads 20 16 Lighting head.jpg Looks really nice once it is up NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
3 Vinyl Fence 30 NULL All White Baby Vinyl.jpg Looks like a million dollars NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
4 2 Lonely Coppers 19 NULL Extracting Tool 2Copper.jpg Looks just like a disstractor NULL NULL NULL NULL NULL NULL NULL NULL NULL 34.6500 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
5 NULL 12 NULL Escape to here image.gif Looks like i have excaped NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
6 NULL 17 NULL Persuasive image.gif For the one that really care NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
7 2" Faux Wood Blinds 48 16 Select Faux Woods faux_wood_1501.jpg Metros Select "Basics" 2" faux wood blinds are absoultely the best quality low end price point blind offered on the market! NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Heavy Duty Steel high profile headrail. Top quality componets. Exclusive 3mm thick foam extrusion slats. Standard Valance or 3" Crown Valance. Top quality 2" x 2 1/8" heavy gauage steel headrails Tight closing "TRAPEZOID" bottomrails. U.V. resistant 3-ML expanded foam PVC slats "NO SAG" Slats No charge option: Extra long controls. Common valances
8 2 1/2" Slat Wood Blinds 16 16 Select Custom Woods 2_and_half_Plantation_1501.jpg Custom 2 1/2" Plantation Blinds; Custom made to fit. NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Routless slats add 20% Cotton Tape Not Offerd With This Prodcut. 3" Valance Standard Cord tilters are standard and recommened. NULL NULL NULL NULL NULL
9 2 1/2" Alternative Plantation Blinds 48 16 Foam Extrusion PVC Alternative_blinds1.jpg The Shutter Look at a Fraction of the Price! NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL We recommand this prodcut to be a routless only; due to 2 1/2" Plantation Blinds close tighter as a routless. If your preference is to have route holes you may deduct 13%. Deluxe 3" Crown Valance is Standard. Heavy Duty Cord Tilters Standard. (Wand tilt not available) Controls on opposite sides only. Tile Left - Lift Right or Tilt Right - Lift Left. Side cut-outs: $15.00 per side. Cotton tape not offered with this prodcut. NULL NULL NULL
10 2" Flat Foam Blinds 48 16 Foam Extrusion PVC Flat_Foam_blind1.jpg The look of wood with the durability of vinyl NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Extream weight of this prodcut make sure that all of your brackets are tightly secure! Standard 2" Valance for the product. 2" Flat Foam Blinds offered with CORD TILTERS ONLY! Controls on opposite sides only. Tile Left - Lift Right or Tilt Right - Lift Left. Side cut-outs: $15.00 per side. 1 1/2" Cotton tape at 15% surcharge NULL NULL NULL
11 2" Aluminum Slat Blinds 64 16 Select Aluminum 2_inch_aluminum1.jpg Great Wide Slat look --Best Price! NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Blinds over 72" will not close as tightly as smaller blinds because of weight. Standard 2" Aluminum Valance is a 2 slat matching aluminum. Cord Tilters Standard - Clear Plastic Wands Optional at no Charge. Standard Controls Side cut-outs: $15.00 per side. 1 1/2" Cotton tape at 15% surcharge Double slatted blinds: Any two color combination as 50% to cost. NULL NULL
12 Arched Blinds 16 16 NULL arched_Blind1.jpg Arched Blind NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
13 1" Aluminum Mini Blinds 64 16 NULL 1_aluminum_mini_blinds1.jpg 1" Aluminum NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
14 1/2" Aluminum Micro Blinds 64 16 1/2" Aluminum half_inch_aluminum1.jpg Has so much to offer you would think that the world is yours! NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
15 1" Select Custom Wood Blinds 16 16 Select Custom Woods 1_inch_wood_blind1.jpg 1" Wood NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Wand Tilters Only. Multiple blinds on one headrail not recommended. Under 20 1/8" controls must be on opposite sides. Under 13 1/2" no lift control 1 1/4" wood valances are standard NULL NULL NULL NULL
16 2" Curved PVC Blinds 16 16 Select Custom Verticals 2_inch_pvc_verticals_blinds1.jpg If only the best will do in your home you'll be left with no other option than to choose the Select PVC Vertical from Metro! NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Virgin PVC Louvers First quality componets Guaranteed not to warp,twist or disintegrate in direct sunlight. Minimum operable headrail width is 7" and Maxium is 192". MX-93 headrail are finished in silver anodized or painted at no extra charge. Headrail track dimensions are 1 3/4" x 1 3/8" Motorized verticals available on request. Multi-Colored (Striped) Verticals: Only Add $26.00 to each vertical purchace. Valance is extra; with a no charge round corner option.
17 Phifer SheerWeave 16 16 NULL sheerweave50001.jpg SheerWeave NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
18 RollEase "Roller Shades" 80 16 NULL roman-rollease1.jpg Roman / Rolleasse This is where the problem is at. NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
19 Louvered Arch 32 16 NULL louvered_arch_1.gif Louvered Arch NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
20 Woven Woods 16 16 NULL WovenWoods1.jpg Woven Woods NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
21 Roman Shades 80 16 NULL RomanShade1.jpg These Roman Shades will make you feel as if you were sitting on a piece of stone... NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
22 2" Select Custom Wood Blinds 16 16 Select Custom Woods NULL These custom blinds taylor made to fit perfectly just like a hand and glove. NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Routless slate add 20% 1 1/2" Cotton Tapes offered at 15% surcharge 3" Valance Standard Cord tilters are standard and recommened. Cloth Tapes are not available withthe routless option. NULL NULL NULL NULL
23 2" Select Custom Wood Blinds "SandBlasted Colors" 16 16 Select Custom Woods NULL There only a handful of companys that offer the beautiful Sandblasted Colors & Metro Blind & Shand is one of them. NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Routless slate add 20% 1 1/2" Cotton Tapes offered at 15% surcharge 3" Valance Standard Cord tilters are standard and recommened. NULL NULL NULL NULL NULL
24 Movable Arches 32 16 Select Half Circle NULL Select Movable Arches look great installed over horizontal blinds, and produce a finish look. NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL **Something to conceder when ordering this product** Deluxe Frame "Z" Frame overlaps opening 3 1/4" **Something to conceder when ordering this product** Standard Frame "Z" Frame overlaps opening 1 3/4" Optional 2 1/2" deep built in valance to cover the headrail of your horizontal blind. Arch installed in seperate arch opening with wood seal - Order with flat base Arch installed in seperate arch opening with no seal - Order with frame on all sides. NULL NULL NULL NULL
25 Movable Arches 32 16 Select Eyebrow Sunburst NULL Select Movable Arches look great installed in every room, and are great for protecting your furniture from UVA rays. NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Maximum leg length is 1/3 base width Minimum leg length is 20% of base width Minimum width 24" NULL NULL NULL NULL NULL NULL
26 Movable Arches 32 16 Select Quarter Circle NULL Select Quarter Arches look great in any room, and is great for protecting against UVA rays. NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
27 Movable Arches 32 16 Select Octagon & Circle NULL Select Octagon and Circles look great in any room, and is great for protecting against UVA rays. NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
37 Graber Verticals 16 30 Option #1 NULL G-71 Super-Vue & Ultra Value Pricing NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Vinyl: Crown NULL NULL NULL NULL NULL
38 Graber Verticals 16 30 Option #2 NULL G-71 Super-Vue & Ultra Value Pricing NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Basketweave Vinyl: Lightscreen , Nassau, & Richmond Vinyl Embossed: Illusio, & Stowe Valances are extra; therefore, if you need a valance please choose from one of the three choices. NULL NULL NULL NULL NULL
39 Graber Verticals 16 30 Option #3 NULL G-71 Super-Vue & Ultra Value Pricing NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Vinyl Embossed; Coronado, Lausanne, Lexington, & linen NULL NULL NULL NULL NULL NULL NULL NULL
40 Graber Verticals 16 30 Option #4 NULL G-71 Super-Vue & Ultra Value Pricing NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Indian Summer, Lucia, Lyric, & Southern Charm Vinyl Embossed: Cachet, Decatur Sculptured, Homespun, Quantum, Saddle, Twine, Vancouver, Vermont, Verona, & Woodtones Vinyl S-Shaped: Static NULL NULL NULL NULL NULL NULL
41 Graber Verticals 16 30 Option #5 NULL G-71 Super-Vue & Ultra Value Pricing NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Brighton, Lucia Backed, & Stardust Vinyl Embossed: Arlington, Calypso, Casino, Corinthia, Laurel, Royale, Shantung, Stucco, Sundance, & Twister NULL NULL NULL NULL NULL NULL NULL
42 Graber Verticals 16 30 Option #6 NULL G-71 Super-Vue & Ultra Value Pricing NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Capri, Catalina, Festival, Forum, Jewel, Madison, Milano, Noble, Portsmouth, Rain, Tweed, & Vineyard Vinyl S-Shaped: Georgetown NULL NULL NULL NULL NULL NULL NULL
43 Graber Verticals 16 30 Option #7 NULL G-71 Super-Vue & Ultra Value Pricing NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Autumn, Caravan, Clarion, Galleria, Jakarta, Laguna, Minuet, Rhine, Sarterne, & Stained Glass NULL NULL NULL NULL NULL NULL NULL NULL
44 Graber Verticals 16 30 Option #8 NULL G-71 Super-Vue & Ultra Value Pricing NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Mesh (COMMERCIAL ONLY), Strings, & Strings Insert NULL NULL NULL NULL NULL NULL NULL NULL
45 Graber Verticals 16 30 Option #11 NULL Perfect-Vue NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Vinyl: Crown NULL NULL NULL NULL NULL NULL NULL NULL
46 Graber Verticals 16 30 Option #22 NULL Perfect-Vue NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Basketweave Vinyl: Lightscreen, Nassau, & Stowe * Also in coordinating 2" Designer Vinyl Blinds NULL NULL NULL NULL NULL NULL
47 Graber Verticals 16 30 Option #33 NULL Perfect-Vue NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Vinyl Embossed: Coronado, Lausanne, Lexingtop , & Linen * Also in coordinating 2" Designer Vinyl Blinds NULL NULL NULL NULL NULL NULL NULL
48 Graber Verticals 16 30 Option #44 NULL Perfect-Vue NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Indain Summer, Lucia, Lyric, & Southern Charm Vinyl Embossed: Cachet, Decatur Sculptured, Homespun, Quantum, Saddle, Twine, Vancouver, Vermont, Verona, & Woodtones Vinyl S-Shaped: Static NULL NULL NULL NULL NULL NULL
49 Graber Verticals 16 30 Option #55 NULL Perfect-Vue NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Brighton, Lucia Backed, & Stardust Vinyl Embossed: Alington, Calypso, Casino, Corinthia, Laurel, Royale, Shantung, Stucco, Sundance, & Twister * Also in coordinating 2" Designer Vinyl Blinds * Also available as FashionPleat and EvenPleat shades NULL NULL NULL NULL NULL
50 Graber Verticals 16 30 Option #66 NULL Perfect-Vue NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Capri, Catalina, Festival, Forum, Jewel, Madison, Milano, Noble, Portsmouth, & `Rain Vinyl Embossed: Aluminum, Gabrielle, Madeleine, Phonenix, Prairie, Rainer, Satin Stripe, Tweed, & Vinyard Vinyl S-Shaped: Georgetown Also in coordinating 2" Designer Vinyl Blinds * Also available as FashionPleat and EvenPleat shades NULL NULL NULL NULL
51 Graber Verticals 16 30 Option #77 NULL Perfect-Vue NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Autumn, Caravan, Clarion, Galleria, Jakarta, Laguna, Minuet, Rhine, Sauterne, & Stained Glass * Also available as FashionPleat and EvenPleat shades Also available as Fresco Roman Shades NULL NULL NULL NULL NULL NULL
52 Graber Verticals 16 30 Option #88 NULL Perfect-Vue NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Fabric: Mesh (Commercial Only), Strings, & Strings Insert NULL NULL NULL NULL NULL NULL NULL NULL
==============================---Categories--
15 Product Page
16 Decption
17 Travel
18 Protection
19 Munitions
20 SomeThing
=======----Working on the table
I AM receiving a error
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'Company'.
Dam again!
-
Categories============ Sorry about that i pasted that without looking
15 Product Page
16 Wood Blinds 20
30 Vinyle Fence
32 Arches & Circles
33 Shutters 20
34 Roller Shades 20
35 Woven Woods 20
48 Faux Wood & Alternative 20
64 Aluminum Blinds 20
80 Roller Shades 20
96 Symphony 20
=======Company----------------------------
16 1 Metro Blind & Shade M_Company_p.jpg Home of the natural looking Faux Wood Blind; These Faux Wood Blinds look so real you'll think they fell out of a tree!
20 1 Comfortex C_Company_p.jpg It' hard to beat the feeling of a beautiful Sunday afternoon; With the elegance and beauty that Comfortex offers in windows fashions you'll feel like it's Sunday morning every day.
30 1 Graber G_Company_p.jpg Looking for Verticals? Well look no further! After seeing what Graber has to offer you'll quickly realize why they are one of the largest PVC Vertical Manufactures in the world.
400 1 Prestige P_Company_p.jpg Looking for quality in Wood Blinds but worried about cost? Well stop worrying! Breeze throuch the Prestige Collection and take time to see all of your options, at a price that your can afford.
600 1 Hunter Douglas H_Company_p.jpg Looking for
Dam again!
-
I can't use this I want the insert statement, do you expect me to retype all this just to help you??
Check this out there's a insert generator link in there :
-
Honey im home===========
Categories==========================-------
SET IDENTITY_INSERT [dbo].[Categories] ON
IF NOT EXISTS (SELECT [ProductCategoryID] FROM [dbo].[Categories] WHERE [ProductCategoryID] = 15)
INSERT INTO [dbo].[Categories] ([ProductCategoryID], [ProductCategoryName], [CategoryTypeID])
VALUES (15, N'Product Page', NULL)
IF NOT EXISTS (SELECT [ProductCategoryID] FROM [dbo].[Categories] WHERE [ProductCategoryID] = 16)
INSERT INTO [dbo].[Categories] ([ProductCategoryID], [ProductCategoryName], [CategoryTypeID])
VALUES (16, N'Wood Blinds', 20)
IF NOT EXISTS (SELECT [ProductCategoryID] FROM [dbo].[Categories] WHERE [ProductCategoryID] = 30)
INSERT INTO [dbo].[Categories] ([ProductCategoryID], [ProductCategoryName], [CategoryTypeID])
VALUES (30, N'Vinyle Fence', NULL)
IF NOT EXISTS (SELECT [ProductCategoryID] FROM [dbo].[Categories] WHERE [ProductCategoryID] = 32)
INSERT INTO [dbo].[Categories] ([ProductCategoryID], [ProductCategoryName], [CategoryTypeID])
VALUES (32, N'Arches & Circles', NULL)
IF NOT EXISTS (SELECT [ProductCategoryID] FROM [dbo].[Categories] WHERE [ProductCategoryID] = 33)
INSERT INTO [dbo].[Categories] ([ProductCategoryID], [ProductCategoryName], [CategoryTypeID])
VALUES (33, N'Shutters', 20)
IF NOT EXISTS (SELECT [ProductCategoryID] FROM [dbo].[Categories] WHERE [ProductCategoryID] = 34)
INSERT INTO [dbo].[Categories] ([ProductCategoryID], [ProductCategoryName], [CategoryTypeID])
VALUES (34, N'Roller Shades', 20)
IF NOT EXISTS (SELECT [ProductCategoryID] FROM [dbo].[Categories] WHERE [ProductCategoryID] = 35)
INSERT INTO [dbo].[Categories] ([ProductCategoryID], [ProductCategoryName], [CategoryTypeID])
VALUES (35, N'Woven Woods', 20)
IF NOT EXISTS (SELECT [ProductCategoryID] FROM [dbo].[Categories] WHERE [ProductCategoryID] = 48)
INSERT INTO [dbo].[Categories] ([ProductCategoryID], [ProductCategoryName], [CategoryTypeID])
VALUES (48, N'Faux Wood & Alternative', 20)
IF NOT EXISTS (SELECT [ProductCategoryID] FROM [dbo].[Categories] WHERE [ProductCategoryID] = 64)
INSERT INTO [dbo].[Categories] ([ProductCategoryID], [ProductCategoryName], [CategoryTypeID])
VALUES (64, N'Aluminum Blinds', 20)
IF NOT EXISTS (SELECT [ProductCategoryID] FROM [dbo].[Categories] WHERE [ProductCategoryID] = 80)
INSERT INTO [dbo].[Categories] ([ProductCategoryID], [ProductCategoryName], [CategoryTypeID])
VALUES (80, N'Roller Shades', 20)
IF NOT EXISTS (SELECT [ProductCategoryID] FROM [dbo].[Categories] WHERE [ProductCategoryID] = 96)
INSERT INTO [dbo].[Categories] ([ProductCategoryID], [ProductCategoryName], [CategoryTypeID])
VALUES (96, N'Symphony', 20)
SET IDENTITY_INSERT [dbo].[Categories] OFF
Products====================______-----------------
SET IDENTITY_INSERT [dbo].[Product] ON
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 1 AND [ProductCategoryID] = 96)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (1, N'Symphony', 96, 16, N'This is the model name', N'Symphony_1501.jpg', N'Looks like an ordinary bumThese Roman Shades will make you feel as if you were sitting on a piece of stone... ', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 2 AND [ProductCategoryID] = 20)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (2, N'Collector Heads', 20, 16, N'Lighting', N'head.jpg', N'Looks really nice once it is up', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 3 AND [ProductCategoryID] = 30)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (3, N'Vinyl Fence', 30, NULL, N'All White Baby', N'Vinyl.jpg', N'Looks like a million dollars', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 4 AND [ProductCategoryID] = 19)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (4, N'2 Lonely Coppers', 19, NULL, N'Extracting Tool', N'2Copper.jpg', N'Looks just like a disstractor', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 5 AND [ProductCategoryID] = 12)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (5, NULL, 12, NULL, N'Escape to here', N'image.gif', N'Looks like i have excaped', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 6 AND [ProductCategoryID] = 17)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (6, NULL, 17, NULL, N'Persuasive', N'image.gif', N'For the one that really care', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 7 AND [ProductCategoryID] = 48)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (7, N'2" Faux Wood Blinds', 48, 16, N'Select Faux Woods', N'faux_wood_1501.jpg', N'Metros Select "Basics" 2" faux wood blinds are absoultely the best quality low end price point blind offered on the market!', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 8 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (8, N'2 1/2" Slat Wood Blinds', 16, 16, N'Select Custom Woods', N'2_and_half_Plantation_1501.jpg', N'Custom 2 1/2" Plantation Blinds; Custom made to fit.', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 9 AND [ProductCategoryID] = 48)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (9, N'2 1/2" Alternative Plantation Blinds', 48, 16, N'Foam Extrusion PVC', N'Alternative_blinds1.jpg', N'The Shutter Look at a Fraction of the Price!', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 10 AND [ProductCategoryID] = 48)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (10, N'2" Flat Foam Blinds', 48, 16, N'Foam Extrusion PVC', N'Flat_Foam_blind1.jpg', N'The look of wood with the durability of vinyl', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 11 AND [ProductCategoryID] = 64)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (11, N'2" Aluminum Slat Blinds', 64, 16, N'Select Aluminum', N'2_inch_aluminum1.jpg', N'Great Wide Slat look --Best Price!', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 12 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (12, N'Arched Blinds', 16, 16, NULL, N'arched_Blind1.jpg', N'Arched Blind', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 13 AND [ProductCategoryID] = 64)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (13, N'1" Aluminum Mini Blinds', 64, 16, NULL, N'1_aluminum_mini_blinds1.jpg', N'1" Aluminum', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 14 AND [ProductCategoryID] = 64)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (14, N'1/2" Aluminum Micro Blinds', 64, 16, N'1/2" Aluminum ', N'half_inch_aluminum1.jpg', N'Has so much to offer you would think that the world is yours!', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 15 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (15, N'1" Select Custom Wood Blinds', 16, 16, N'Select Custom Woods', N'1_inch_wood_blind1.jpg', N'1" Wood', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 16 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (16, N'2" Curved PVC Blinds', 16, 16, N'Select Custom Verticals', N'2_inch_pvc_verticals_blinds1.jpg', N'If only the best will do in your home you''ll be left with no other option than to choose the Select PVC Vertical from Metro!', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 17 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (17, N'Phifer SheerWeave', 16, 16, NULL, N'sheerweave50001.jpg', N'SheerWeave', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 18 AND [ProductCategoryID] = 80)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (18, N'RollEase "Roller Shades"', 80, 16, NULL, N'roman-rollease1.jpg', N'Roman / Rolleasse This is where the problem is at.', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 19 AND [ProductCategoryID] = 32)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (19, N'Louvered Arch', 32, 16, NULL, N'louvered_arch_1.gif', N'Louvered Arch', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 20 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (20, N'Woven Woods', 16, 16, NULL, N'WovenWoods1.jpg', N'Woven Woods', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 21 AND [ProductCategoryID] = 80)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (21, N'Roman Shades', 80, 16, NULL, N'RomanShade1.jpg', N'These Roman Shades will make you feel as if you were sitting on a piece of stone...', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 22 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (22, N'2" Select Custom Wood Blinds', 16, 16, N'Select Custom Woods', NULL, N'These custom blinds taylor made to fit perfectly just like a hand and glove.', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 23 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (23, N'2" Select Custom Wood Blinds "SandBlasted Colors"', 16, 16, N'Select Custom Woods', NULL, N'There only a handful of companys that offer the beautiful Sandblasted Colors & Metro Blind & Shand is one of them.', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 24 AND [ProductCategoryID] = 32)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (24, N'Movable Arches', 32, 16, N'Select Half Circle', NULL, N'Select Movable Arches look great installed over horizontal blinds, and produce a finish look.', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 25 AND [ProductCategoryID] = 32)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (25, N'Movable Arches', 32, 16, N'Select Eyebrow Sunburst', NULL, N'Select Movable Arches look great installed in every room, and are great for protecting your furniture from UVA rays.', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 26 AND [ProductCategoryID] = 32)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (26, N'Movable Arches', 32, 16, N'Select Quarter Circle', NULL, N'Select Quarter Arches look great in any room, and is great for protecting against UVA rays.', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 27 AND [ProductCategoryID] = 32)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (27, N'Movable Arches', 32, 16, N'Select Octagon & Circle', NULL, N'Select Octagon and Circles look great in any room, and is great for protecting against UVA rays.', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 37 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (37, N'Graber Verticals', 16, 30, N'Option #1', NULL, N'G-71 Super-Vue & Ultra Value Pricing', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 38 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (38, N'Graber Verticals', 16, 30, N'Option #2', NULL, N'G-71 Super-Vue & Ultra Value Pricing', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 39 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (39, N'Graber Verticals', 16, 30, N'Option #3', NULL, N'G-71 Super-Vue & Ultra Value Pricing', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 40 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (40, N'Graber Verticals', 16, 30, N'Option #4', NULL, N'G-71 Super-Vue & Ultra Value Pricing', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 41 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (41, N'Graber Verticals', 16, 30, N'Option #5', NULL, N'G-71 Super-Vue & Ultra Value Pricing', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 42 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (42, N'Graber Verticals', 16, 30, N'Option #6', NULL, N'G-71 Super-Vue & Ultra Value Pricing', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 43 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (43, N'Graber Verticals', 16, 30, N'Option #7', NULL, N'G-71 Super-Vue & Ultra Value Pricing', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 44 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (44, N'Graber Verticals', 16, 30, N'Option #8', NULL, N'G-71 Super-Vue & Ultra Value Pricing', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 45 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (45, N'Graber Verticals', 16, 30, N'Option #11', NULL, N'Perfect-Vue ', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 46 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (46, N'Graber Verticals', 16, 30, N'Option #22', NULL, N'Perfect-Vue ', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 47 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (47, N'Graber Verticals', 16, 30, N'Option #33', NULL, N'Perfect-Vue ', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 48 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (48, N'Graber Verticals', 16, 30, N'Option #44', NULL, N'Perfect-Vue ', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 49 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (49, N'Graber Verticals', 16, 30, N'Option #55', NULL, N'Perfect-Vue ', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 50 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (50, N'Graber Verticals', 16, 30, N'Option #66', NULL, N'Perfect-Vue', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 51 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (51, N'Graber Verticals', 16, 30, N'Option #77', NULL, N'Perfect-Vue', NULL, NULL)
IF NOT EXISTS (SELECT [ProductID], [ProductCategoryID] FROM [dbo].[Product] WHERE [ProductID] = 52 AND [ProductCategoryID] = 16)
INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [ProductCategoryID], [CompanyID], [ModelName], [ProductImage], [ProductDescription], [UnitCostPerFoot], [UnitCostPerSection])
VALUES (52, N'Graber Verticals', 16, 30, N'Option #88', NULL, N'Perfect-Vue', NULL, NULL)
SET IDENTITY_INSERT [dbo].[Product] OFF
Company=========================__------------------
IF NOT EXISTS (SELECT [CompanyID] FROM [dbo].[Company] WHERE [CompanyID] = 16)
INSERT INTO [dbo].[Company] ([CompanyID], [DepartmentID], [CompanyName], [CompanyAddress], [CompanyCity], [CompanyProvince])
VALUES (16, 1, N'Metro Blind & Shade', NULL, NULL, NULL)
IF NOT EXISTS (SELECT [CompanyID] FROM [dbo].[Company] WHERE [CompanyID] = 20)
INSERT INTO [dbo].[Company] ([CompanyID], [DepartmentID], [CompanyName], [CompanyAddress], [CompanyCity], [CompanyProvince])
VALUES (20, 1, N'Comfortex', NULL, NULL, NULL)
IF NOT EXISTS (SELECT [CompanyID] FROM [dbo].[Company] WHERE [CompanyID] = 30)
INSERT INTO [dbo].[Company] ([CompanyID], [DepartmentID], [CompanyName], [CompanyAddress], [CompanyCity], [CompanyProvince])
VALUES (30, 1, N'Graber', NULL, NULL, NULL)
IF NOT EXISTS (SELECT [CompanyID] FROM [dbo].[Company] WHERE [CompanyID] = 400)
INSERT INTO [dbo].[Company] ([CompanyID], [DepartmentID], [CompanyName], [CompanyAddress], [CompanyCity], [CompanyProvince])
VALUES (400, 1, N'Prestige', NULL, NULL, NULL)
IF NOT EXISTS (SELECT [CompanyID] FROM [dbo].[Company] WHERE [CompanyID] = 600)
INSERT INTO [dbo].[Company] ([CompanyID], [DepartmentID], [CompanyName], [CompanyAddress], [CompanyCity], [CompanyProvince])
VALUES (600, 1, N'Hunter Douglas', NULL, NULL, NULL)
Dam again!
-
how about
SELECT dbo.Product.ProductID, dbo.Categories.ProductCategoryID, dbo.Categories.ProductCategoryName, dbo.Product.CompanyID
FROM dbo.Product INNER JOIN
dbo.Categories ON dbo.Product.ProductCategoryID = dbo.Categories.ProductCategoryID
WHERE (dbo.Product.CompanyID = 16) AND (dbo.Categories.CategoryTypeID = 20)
?
-
I have tried that one a hundred times and still nothing. it produces double results from the product table and does not return a result from the categories table
Erik
Dam again!
-
Here is the message that receive from the query analizer
Server: Msg 207, Level 16, State 3, Procedure GetBlindMenuInfoCTaLL, Line 7
Invalid column name 'ProductCategoryID'.
Server: Msg 207, Level 16, State 1, Procedure GetBlindMenuInfoCTaLL, Line 7
Invalid column name 'ProductCategoryID'.
Server: Msg 207, Level 16, State 1, Procedure GetBlindMenuInfoCTaLL, Line 7
Invalid column name 'ProductCategoryName'.
Server: Msg 207, Level 16, State 1, Procedure GetBlindMenuInfoCTaLL, Line 7
Invalid column name 'CategoryTypeID'.
Dam again!
-
Please post the results it gives you vs the ones you want to receive.
-
BTW thoses error are impossible if you are calling the query from the right db. The query gave me actual results.
-
Here is the link to a snap shot of the analizer
Still same o'll funny results, is it possiable that i have some sort of issue locally?
Dam again!
-
It's not the same productid, this is not a duplicate row.
Have a look at the data in each table to see if anything doesn't make sens.
-
Now that i look at it i can see what i have done. Its all with the CategoriesProductID. Every where i have a duplicate CategoriesProductID that repersents another result.
Ok, what is the suggestion to clean this up?
Erik
Dam again!
-
Every where i have a duplicate CategoriesProductID (In the Product table) that repersents another result.
Dam again!
-
Depends on how you want to use this data and the design of the form/report...
How about not including the column at all in the select?
-
I see, the Categories table is binding to ever CategoriesProductID in the Product table.
The way that i thought that i was setting this up was to do right the Opposite. I also have a one to many relationship from the categories table to the product table. I order to do what i am tring to do i would have to make the one to mant go from the Product table to the Cateories table.
Is that correct?
What i am tring to do here is Example: If i have 20 different styles of wood blinds i wany to put them into a woodblind category in a seperate table. So if i have 20 different wood blinds in the Products table they can all share a CategoryID from a categorytable.
Erik
Dam again!
Viewing 15 posts - 46 through 60 (of 67 total)
You must be logged in to reply to this topic. Login to reply