Posted by Khafancoder on 05/25/07 21:24

Thanx,
here is the db schema :
http://i12.tinypic.com/4v5qfbb.gif

(PrimaryKey fields are identity too)
(SQL2005)


On May 25, 12:34 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Ed Murphy (emurph...@socal.rr.com) writes:
> > Why do you need to do that at all? It seems like you simply need
> > to do the following:
>
> > insert into Products n (ProductId, StoreId, ProductName)
> > select o.ProductId, @NewStoreId, o.ProductName
> > from Products o
> > where o.StoreId = @OldStoreId
>
> I suspect that Khafancoder's problem may be that ProductId is a
> unique key and not a key together with StoreID. The latter may or
> may not be a better design depending on the business requirements.
>
> I guess Khafancode will tell us it is not. I hope then he also
> gives us more information about his tables: which are the keys,
> if there are any IDENTITY column. And also which version of SQL Server
> he is using.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Synchronous Bulk-Copy into two table
• Prev in forum: Re: Need Help with a SQL Statement - Trying not to use a Cursor
• Thread view: Re: Synchronous Bulk-Copy into two table

[Reply to this message]