I actually have a web server with only iis7.0 installed, a server with only sql installed "NOT this one you guys are helping me with", and a dns server that...

Thanks so much for the help...

Your help guided me to be able to fix my problem.

After digging into this from your eduction i am able to find this issue on...

I know this one is going to sound super loco....

It seems to me that management studio is not installed. That is what i have been looking for this whole time.

That...

I have installed and uninstalled until I am officially fing crazy.

Here are some pictures that show what I have. Notice how everything looks installed but i can not get to...

This is perfect !

Thank you very much for your help !

Erik

That works perfect !

Thanks

Thanks Barry !

I did not receive the notification email for some reason.

Thanks

Erik

A product can never be an option for itself.

Thanks alot!

I just changed the LEN to COUNT(*) and this works great..

Thanks again

Erik

Can you show my the set implementation?

I see what you're doing.

You are thinking in terms of if a product has options it needs to have a options table. And that is right as well.

Here is...

Hey GrassHopper I finally got it.

I had to think backwards.

ALTER proc [dbo].[uspUtbProduct_Select_W_Top1Photo_4Opts]

@SubCategoryID INT,

@ProductID INT

AS

DECLARE @OptionsTable TABLE

(

ProductID INT,

SubCategoryID INT,

ProductName VARCHAR(30),

ProductNumber VARCHAR(30),

PhotoID INT,

PhotoName VARCHAR(30)

)

INSERT...

Thanks for the reply grasshopper !

What this is, is a product management system, and not the order system.

What I need to do while managing the products is do a insert...

I personal like xml for these situations.

And here is my why of implementing this

Options---> //

...

Absolutely beautiful my dear Watson !

SELECT

PR.[ProductID]

,PR.[SubCategoryID]

,PR.[ProductOptionID]

...