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...

Here is the link to a snap shot of the analizer

http://afcc1.com/sqlHELP

Still same o'll funny results, is it possiable that i have some sort of issue locally?

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...

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

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...

I have been stuck for two days!

This is great.

I am hopeing to be able to work on this size price solution very soon.

When i start on it, if you do not mind, i will send you...

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...

=================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...

Man, I GOT this puppy

I am using the wizard to copy the table to a txt file and the is doing well other than i have no option to what...

Whats for dinner?

I am able to export the data to a txt file(By right clicking on the table in the enterprise manager); however, it keeps exports the same table and...

I am working on it. I'll be back it a bit

I did not give you the correst information last time.

This should be the right stuff.

=======================----Product

CREATE TABLE [Product] (

 [ProductID] [int] IDENTITY (1, 1) NOT NULL ,

 [ProductName] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL...

You are going to have to hold my hand on this one

Ok hold on, I have another one to hit you with.

How do i generate the insert statements?