select
'Select '+
''''+ cast(SrNo as varchar) +''','''+ StateName+''','''+ cast(TINnumber as varchar) +''','''+ StateCode+''''+' Union '
from [dbo].[TblJA_StateCode]
'Select '+
''''+ cast(SrNo as varchar) +''','''+ StateName+''','''+ cast(TINnumber as varchar) +''','''+ StateCode+''''+' Union '
from [dbo].[TblJA_StateCode]