Let me type this again:

ALso, is EventID varchar or int ?

Well if it is alive here you go:

declare @ICnt int , @DCnt int

select @ICnt = count(*) from inserted

select @DCnt = count(*) from deleted

if @ICnt > 0 and @DCnt > 0

 begin

 --...

Now If the amount of data is that big and you ad afuntion to the view be ready to CRAWL

I would doit the...

Yes you need the cross join to get all the posible combinations and then left join to the the granted (third table that Remi is metioning)

Something like:

Select All.DocID, All.UserID

from (select DocID,...

Some table definitons and data sample can help tremendously so can you please post some of that

For the moment all I can do is just guess something like:

select fld1, fld2

from...

IT is call sarcasm

Are you sure you fixed all places?

CREATE PROCEDURE ReturnResponseByFormSXML2

AS

-- Stored procedure chtobi otobrazit XML s FieldName kak ElementName

DECLARE @SqlString nvarchar(4000)

DECLARE @FieldID Varchar(500)

DECLARE @EventID varchar(500)

SET @FieldID = '7250, 7251, 7252,...

Those IDs (object ID or Column ID ) are NOT identities, are internally managed by SQL Engine. if something goes wrong at the update event (this could be a canceled...

That's right it should have been:

-- Stored procedure chtobi otobrazit XML s FieldName kak ElementName

DECLARE @SqlString nvarchar(4000)

DECLARE @FieldID varchar(500)

DECLARE @EventID varchar(500)

....

SET @SqlString = 'SELECT EventID, B.UserID, LastName, FirstName, Organization, FormID,...

Did you read the link?

That's right

try:

SET @SqlString = 'SELECT EventID, B.UserID, LastName, FirstName, Organization, FormID, ' + @SqlString + '

FROM Temp1 A

JOIN Temp1Response B on A.fieldId = b.FieldID

JOIN UserInfo C on B.UserID = C.UserID

WHERE FieldID...

Ah, that's better

Use the  'KEEPIDENTITY' option of BULKINSERT !!!!

Peter,

I did experienced that once but wasn't sure where to find it (good memory always helps)

Glad, that did the trick!

Correct!

You should not have any problems (with EM) , just make sure that account can reach the shares on the remote server and you should be OK