I work on SQL server 2012 I face issue I need to update Generated Number on table testto get UNIQUE number to every group id
from 1 to 4so first group from groupid 1 to 4 will be as 1000so second group from groupid 1 to 4 will be as 1001so third group from
groupid 1 to 4 will be as 1002
create table test
(
FamilyId int,
PortionKey nvarchar(20),
GroupId int,
GeneratedNumber int
)
insert into test(FamilyId,PortionKey,GroupId,GeneratedNumber)
values
(12100,'ab',1,NULL),
(12100,'cd',2,NULL),
(12100,'eg',3,NULL),
(12100,'fb',4,NULL),
(12100,'am',1,NULL),
(12100,'fu',2,NULL),
(12100,'ab',3,NULL),
(12100,'cy',4,NULL),
(12100,'lf',1,NULL),
(12100,'ad',2,NULL),
(12100,'gb',3,NULL),
(12100,'mu',4,NULL)
if i get unique number for every group of portion key from 1 to 4 then it accepted for menever mind 1000 or not but must be uniqueportion key on table test not repeatedI need every group id from 1 to 4 to get unique numberbased on group id and portion key
