ya i'm Agreeing this.

First of all insert into #test values(2,'A'),(' ' ,'B') this is not there in sqlserver 2005.

So now we can't consider data type issue.

IF u go with sqlserver2008 ,yes of course we need to consider about data types.

Thank you