I am trying to find a query which will give different results for these join variations. As you mentioned that the results will be different, do you have any examples...

create table test ( c1 int, c2 text)

go

create proc test_text ( @var text output )

as

select @var= c2 from test

go

exec test_text

This throws error, assignment is wrong.

When will the need arise to store the HTML as Binary ? I 'm the scenario.

You haven't mentioned about any indexes on the tableA.

Can you try with clustered index on (PROD_CD,DRAW_NBR)

Then you can get rid of the MAX function ..