you can use bulk insert.

since more than one user is inserting record at a time so in your tabe duplicate values are going in primary key column. you can use transactions to check the...

[font="Arial"]thanks a lot chris....its working .....thanks once again[/font] :):):)

hi chris...

need your help once again...

actully producerid is of varchar type so i guess we cant use min for distinct producerid.and for same producer there are numerous producerid. so the...

Thanx chris:)

one more thing chris.....

SELECT f.*,

c.VENDORNUM,

pm.producerid

INTO #feedrecord

FROM idscomsql.dbo.feedrecord f

LEFT JOIN (SELECT MIN(producerid) AS producerid, producer...

Thanx a lot chris. thanx for your help. whith this i guess i'll be able to achive my goal.:)

FIRST OF ALL THANX A LOT

my code is like

Create PROCEDURE spInsert

AS

BEGIN

declare @clientCode varchar(10)

declare @dbstring varchar(50)

set @clientCode='kh'

set @dbstring = @clientCode + 'idsnetsql'

print @dbstring

exec('use ' + @dbstring +

'

Select *...