Since you're on SQL 2012, you can use TRY_CAST() instead of just CAST().

Drew

Here is one option.  I initially tried an approach similar to Kevin's, but this seems to require fewer scans.

SELECT df.LineNumber, df.MFN, MAX(CASE WHEN df.MFN = t.MFN...

You're filtering out any rows where tbl3.Col3 <> 1234, including those rows where there is no match and tbl3.Col3 is null. Move the condition to the join clause.

This will do most of what you ask.  You don't have a field that supports a sort consistent with your expected output, so I've used the one that comes...

This is the same problem as here.  Don't start a new thread just because you don't like the answers that you are getting on your original thread.

Drew

If you want the dates as the header, you will need to either use dynamic SQL or use...

You're overcomplicating your formula.  There is no reason to cast to float. Just use integer division.

UPDATE t1
SET set_no = t2.set_no
FROM #sample t1
INNER JOIN...