why do you have a column named countryid and corresponding foreign key to a country table?
can you please provide the data as follows for all data
declare @products table(idproduct int, name varchar(50), country varchar(50), code int, price decimal(10,3))
insert into @idproduct -- name -- country -- code price
1, 'apple', 'england', 23, 5
union etc
<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
update a table with new data ; help please
Posted - 04/30/2012 : 18:37:42
