Looks like direct recursion and you have the RECURSIVE_TRIGGERS option set

As you stated, use 'IF UPDATE ()' to control the update in the trigger

or use TRIGGER_NESTLEVEL

SELECT x.EMPID,COALESCE(a.[NAME],'') AS [NAME],COALESCE(l.LICENSE,'') AS [LICENSE]

FROM (SELECT N'111111' AS [EMPID]) x

LEFT JOIN @HREMP_adp a ON a.EMPID = x.EMPID

LEFT JOIN @License l ON l.EMPID = x.EMPID

Other than trying Sergiy's approach. If the dataset is large then performance will always be an issue whatever solution you try.

To avoid the use of a function you could try...

wow Jeff you sure ask the toughies

Wish I knew the answer

Only the International (yyyy-mm-dd) is self-describing and explicit

Only if you know the displayed value is in that format

What...

Bad question

'Default Instance' has a default port, 'Named Instances' do not

The question should have specified 'Default...

Firstly, views cannot have duplicate column names therefore if you have duplicate names then they are from your own query not the view, so use the alias in your query...

Based on the data supplied

Field1

LEFT([Address],LEN([Address])-CHARINDEX(' ',REVERSE([Address]),CHARINDEX(' .',REVERSE([Address]))+1))

Field2

SUBSTRING([Address],LEN([Address])-CHARINDEX(' ',REVERSE([Address]),CHARINDEX(' .',REVERSE([Address]))+1)+2,255)

If the data varies from the supplied standard or there are trailing spaces then the above will not work without adding RTRIM...

Just thought

Do you want to extract or remove the img tag

Since your input is a xml document check out sp_xml_preparedocument

The HTML given is not XML compliant

One way to...

Look up in BOL (Books Online)

How to create a job (Enterprise Manager)

Creating Job Steps (specifically Transact-SQL Job Steps as you will want to EXEC your proc)

How to schedule a job...

better solution (one less join )

SELECT a.[value],n.number

FROM (SELECT [value],COUNT(*) AS [Num] FROM GROUP...

Do you mean like this

SELECT a.[value],n.number

FROM a

INNER JOIN (SELECT [value],COUNT(*) AS [Num]

FROM GROUP BY [value]) s

ON s.[value] = a.[value]

INNER JOIN master.dbo.spt_values n ON...

Providing that Subjects in ASC order for [Name] does not matter then

SELECT

CASE WHEN a.Subjects1 = b.Subjects2 THEN a.Name1 ELSE a.Subjects1 END AS [Name],

CASE WHEN a.Subjects1 = b.Subjects2 THEN a.Subjects1...

p.s.

SELECT @result = COUNT(*)

FROM (SELECT c.[Date]

FROM @MyTable a

INNER JOIN [Calendar] c

ON c.[Date] >= a.StartDate AND c.[Date] <= a.EndDate

GROUP BY c.[Date]

HAVING COUNT(*) = 1) x...