Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Store Procedure HELP!!!

Author  Topic  vulture Starting Member 5 Posts Posted - 2001-08-22 : 06:33:01 hi ppl i need help, im kinda of new to SQL (like trying to rejoin the SQL world after 4 years away form it) and in tryin to make a prcedure that doesnt seems to work. i have 2 tables Products, ProductsDetails with these fields: table Products productID product name Discontinued table ProductsDetails ProductDetailId productID ProdcutDescription Discontinued Now i have an HTML page on where a select a product and them i can CANCEL or ACTIVATE the product, what im trying to do is a Store Procedure that when i ACTIVATE OR CANCEL a produt will automatic check if the are any details for that product on TABLE PROCUTSDETAIL and ACTIVATE OR CANCEL then acording to the selection a made on the HTML page. This may be simple for soem of u but damm hard to me at this point, if anyone could help it would be great thx