Groups > comp.databases.ms-sqlserver > #1929

Re: WHILE LOOP AS FOR LOOP

Newsgroups	comp.databases.ms-sqlserver
Date	2015-07-29 07:31 -0700
References	<d5581480-cb05-4b19-8f82-995f7bfe01e3@googlegroups.com> <XnsA4E6A3D9FCE25Yazorman@127.0.0.1>
Message-ID	<6141367c-ecc2-4a6b-aa21-1b006053a8fb@googlegroups.com> (permalink)
Subject	Re: WHILE LOOP AS FOR LOOP
From	Jessica González <jess.rgm@gmail.com>

Show all headers | View raw

thanks.. but

SET IDENTITY_INSERT table ON;
INSERT INTO table(pk,activo,permiso,rol) 
      SELECT IDENT_CURRENT('table')+1,'S',id, 1
      FROM table2


return error  

Violation of PRIMARY KEY constraint 'PK__table__3213E83F2B947552'. Cannot insert duplicate key in object 'table'. The duplicate key value is (6).

only 'id' i need get from table2

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

WHILE LOOP AS FOR LOOP Jessica González <jess.rgm@gmail.com> - 2015-07-29 06:58 -0700
  Re: WHILE LOOP AS FOR LOOP Erland Sommarskog <esquel@sommarskog.se> - 2015-07-29 14:04 +0000
    Re: WHILE LOOP AS FOR LOOP Jessica González <jess.rgm@gmail.com> - 2015-07-29 07:31 -0700
      Re: WHILE LOOP AS FOR LOOP Erland Sommarskog <esquel@sommarskog.se> - 2015-07-29 15:44 +0000
        Re: WHILE LOOP AS FOR LOOP rja.carnegie@gmail.com - 2015-07-29 10:03 -0700
  Re: WHILE LOOP AS FOR LOOP --CELKO-- <jcelko212@earthlink.net> - 2015-08-14 17:54 -0700

csiph-web