It's fine, except I'd add in a JOIN instead of using the old-style WHERE:

SELECT
  T1.Id
,  T1.IsActive
,  T1.StartDate
,  T1.EndDate
,  T1.Title
, ...

--Edit: Should have read the question properly, apologies.

I think we need to add some balance here. I like drinking beer, and lots of it. 
Luckily, today is Friday and I will get the chance to assuage my...

Can't you do this all in a single step?

SELECT TOP (1)
without an ORDER BY is a somewhat suspect practice.

If more than one row matches the WHERE clause, the result which is returned is likely...

Which tool are you using to perform the unzip? Here's how to do it with 7-Zip, for example.

If you provide the sample data in a consumable format (ie, one which someone can cut & paste directly into SSMS), you'll soon get a coded solution (probably using a...

Another approach would be to create a Code table. Then that maps to the Table1 and it can map to the Table2, it then enforces that only codes that...