I am using UNION ALL to create headers so I can copy and paste the result direct to excel file
select 'username' as h1, 'userid' as h2, 'userbdate' as h3
select username,userid, convert(date,userbdate,101)
I am getting
Conversion failed when converting date and/or time from character string.
any ideas? thx