Hello.
We need to update a number of customer records each with new contact records.
I figure it's a simple insert query into tciContact. To get the next CntctKey number I use:
declare @contctkey int
exec spGetNextSurrogateKey 'tciContact',@cntctkey output
select @cntctkey
Does this sound right? Does anyone already have a script to help out with this?
Thanks!