I post the topic question above so that i know the thread will post.

Some time back i was given this create table a query for a solution to price my...

=Table============

CREATE TABLE [Metro 2" Blind Size Price] (

 [BlindSizePriceID] [int] NOT NULL ,

 [MaxHeight] [decimal](9, 2) NOT NULL ,

 [MaxWidth] [int] NOT NULL ,

 [Price] [money] NOT NULL ,

 [CompanyID] [int] NOT NULL ,

 [ProductID] [int]...

Got it!

ALTER PROCEDURE GetBlindCompanyInformation

@IDCompany int

AS

SELECT DISTINCT Company.CompanyID, Company.CompanyName, Product.ModelName, Product.ProductImage, Product.ProductDescription

FROM         Company INNER JOIN

                      Product ON Company.CompanyID = Product.CompanyID

WHERE Company.CompanyID = @IDCompany  

I have added a Parameter the this query and it is giving me a ambigious column name error. What am i missing here?

============I added...

OK.

Thanks.

Currently i am creating these procedures in vb.net; however, i do have sql2000 enterprise manager but i find it more difficult to create stored procedures. Do you have any suggestions...

Hanslindgren could you please give an example?

Thanks

Was looking around for the Picture box and after scratching my head for a bit, i have realized that there is no picture box for the vb.net WEBFORMS, only on...

Thank you!

This has to be the fastest form on the net!

Thank!

Thank You!

ok, but what would be a SPROC to notify the e-mail client?

When the user that is seeking the contractor  hits the submitt button on a web form, and that information...

I THInk that i have asked my question incorrectly; however, the information received will be utilized. "Thank You"

Let me try again:

1. Lets say...

Will do...

i was not aware that there was such a database. Do you have a suggestion to where i might find a zip database?

Thanks.