If those values truly correspond with your results:
741:51:59 = Jan 30 1900 11:34PM
then I'm not sure what you can, as I don't see a clear link between the two...

You didn't provide enough data to know that you want to INSERT, but you likely want something along these lines:

INSERT INTO [dbo].[SomeCause] ( SomeID, SomeType,...


exec('declare @testvar nvarchar(128); select top (1) @testvar = NameSchema from #TempCommonMatchFormatted; select @testvar as testvar')

If you want to return a value(s) to a...

The code looks good to me.  I think it's better to test row existence outside the TRY.

You use XACT_STATE() to:
(1) avoid attempting a ROLLBACK or COMMIT when a trans is not active
(2) to know whether to do a ROLLBACK or COMMIT in certain cases (if...

I can't tell specifically what you need, but I suggest using the "standard" approach to adjust a datetime to a given boundary.  For example, the code below totals by MINUTE,...

As to the query plans for these:

SELECT A.FirstName, A.LastName, B.Location
FROM TableA A
LEFT OUTER JOIN TableB B
ON A.PersonId = B.PersonId AND B.Location = 'London'

Yes, the E:\ paths will be the same, if...

You should also look at tablediff.exe to do that. 

Yeah, being a command-line utility it's a little quirky to get used to, but I've found it works well...

Use:
-t ","

instead of:
-t "|"

I'm guessing the error was about conversion to int, based on your comments, but it would be nice to be sure.
If so, run a pre-audit on the source data...


SELECT
  @StartDt = DATEADD(HOUR, 6, DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) - 1, 0)),
  @EndDt = DATEADD(HOUR, 1, DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0))