On a separate note.

GO is a batch separator.

https://msdn.microsoft.com/en-us/library/ms188037.aspx

and the definition of a batch is...

"a group of one or more Transact-SQL statements sent at the same time from an application to...

You can join Deleted & Inserted so you can include columns of both in one result set. Just make sure you have a unique key to join on.

There are...

Quoting ZZartin to bring more attention to his...

drew.allen (12/6/2016)

---

Now you're just making up stuff to support your claims.

Who cares?!?! Most people...

Igor Micev (12/5/2016)

---

I'll have to check about the DISTINCT. it seems that can be removed, but i'm not sure about whether there could be duplicates. will it make a bigger...

mxy (12/1/2016)

---

;WITH summary AS (

SELECT p.Studentstatus,

p.StudentId ,

...

DDL & DML would help.

First of all, you've created a temp table #LocalizedCategories, but you are doing a Select Distinct on it. Is there any reason you couldn't have...

mack53nico (12/1/2016)Is it possible to rewrite the code that encapsulates all these combinations in a concise way?

SELECT Source_System, Identifier, Forename, Surname, Date etc....

FROM tblTable

WHERE

(Identifier = @identifier

OR...

Another option:

SELECT @Dummy = CASE WHEN LEN( Med_Rec_Nbr ) < 7

THEN RIGHT('000000'...

SELECT ps.Med_Rec_Nbr, REPLACE(STR(ps.Med_Rec_Nbr,7),' ','0')

FROM @Primary_Summary AS ps

This approach also makes it obvious if you got a number larger than expected, rather than truncating to 7 characters.

- Cross database access requires some additional security checks.

- The connection to another database will require an additional session, which will have its own CPU and memory overhead....

You said you're new, but I strongly recommend you do tell him. His response...

On an unrelated note, you've created these objects in the master database. That is a very bad idea. If at all possible, you should move those to a...

How much...

A couple more questions:

You said lots of queries time out, but not all. Have you looked to see if there are specific columns that experience the timeouts? I...