If you don't want to think leave this profession right now. It's not for you.

I stated everything you should get from BOL if you've been taught to read manuals.

JOIN ==...

1. Open BOL anf find out that JOIN == INNER JOIN.

2. Give yourself a definition what is "duplicate rows".

I would start from another question:

why to do such UPDATE at all?

Concatenating values from 2 fields contradicts essential rules of data management.

If somebody some time needs concatenated values just use...

IF EXISTS (select 1 from INSERTED)

will perform faster.

If your trigger is for delete as well use

IF EXISTS (select 1 as One from INSERTED UNION select 1 as One...

It's not a problem, there is nothing to fix.

It's TRANSACTIONAL SQL.

In order to prevent creating another table with the same name SQL Server checks if such table already exists in...

Another victim of NULL replacement.

You need just restore NULL where it suppose to be:

where DATEDIFF(D, CONVERT(DATETIME, NULLIF(NEWREQDATE, '00000000'), GETDATE() ) > 1

Read about bcp command in BOL.

All answers for you are there.

Then all you need is just "linked table" from Access to SQL Server.

Right click on "tables", chose "Link to tables", there select "ODBC Databases", click "NEW", find "SQL Server" in...

Can anybody suggest less suitable way to pass data from SQL Server to Access than XML file?

...

sSql = "EXEC dbo.DepartmentEmployees " _

& "@department_id = " & departmentId

Set oRs = oConn.Execute(sSql)

Are you sure this code is written in T-SQL?

If you need only lines where ALL profiles are present you may use inner join:

SELECT FN.propertyValue AS FirstName, LN.propertyValue AS LastName,

CN.propertyValue AS CompanyName, C.propertyValue AS City,...

> Not to beat a dead horse, but any ideas why it worked for almost a year?

Good question.

Did anybody do anything with Distributed Transactions settings on the server? On remote...

Does you SP have some

SELECT ...

INTO #Table

statements?

Which of the statements hangs now?