SQL2K Help! SQL Union Query And Varchar / Integer Conversion Problems =(

Hi, I need help.  Understatement of the year right now, too =

So... I've created a stored procedure that partially pulls a SQL union query to give me a complete one-line result set of a bunch of data... four separate selects comprise the query.

The tables are structured identically to each other, but the values being pulled are specific and distinct.  All of the non-date values stored are varchar values in the tables, and yet when I execute the SQL union query, I get the error message:  Syntax error converting the varchar value to a column of data type int.

 I know SQL does implicit conversions, however Im not sure why it's trying to do that with this query, I suppose.  it should have been straightforward.

Any suggestions?  Here is the query logic to look at, in case I'm missing the obvious 


exec('

SELECT ACCOUNT, LNAME, FNAME, SEX, DOB, cast(MA_ContentValue as decimal) as MA_ContentValue, cast(MA_DOS as smalldatetime) as MA_DOS,
cast(LDL_ContentValue as decimal) as LDL_ContentValue, cast(LDL_DOS as smalldatetime) as LDL_DOS,
 cast(HgbA1C_ContentValue as decimal)as HgbA1C_ContentValue, HgbA1C_DOS, cast(Creatinine_ContentValue as decimal) as Creatinine_ContentValue, Creatinine_DOS


FROM
(
 SELECT     Account, Lname, FName, Sex, DOB,MA_ContentValue, MA_DOS,
   0 as LDL_ContentValue, 0 as LDL_DOS,
   0 as HgbA1C_ContentValue, 0 as HgbA1C_DOS,
   0 as Creatinine_ContentValue, 0 as Creatinine_DOS
 FROM         dbo.vwDiabetic_MicroalbuminTop3
 
 UNION
 
 SELECT     Account, Lname, FName, Sex, DOB, 0 as MA_ContentValue, 0 as MA_DOS,
   LDL_ContentValue, LDL_DOS,
   0 as HgbA1C_ContentValue, 0 as HgbA1C_DOS,
   0 as Creatinine_ContentValue, 0 as Creatinine_DOS
 FROM         dbo.vwDiabetic_LDLTop3
 
 UNION
 
 SELECT     Account, Lname, FName, Sex, DOB, 0 as MA_ContentValue, 0 as MA_DOS,
   0 as LDL_ContentValue, 0 as LDL_DOS,
   HgbA1C_ContentValue, HgbA1C_DOS,
   0 as Creatinine_ContentValue, 0 as Creatinine_DOS
 FROM         dbo.vwDiabetic_HgbA1CTop3
 
 UNION

 SELECT     Account, Lname, FName, Sex, DOB, 0 as MA_ContentValue, 0 as MA_DOS,
   0 as LDL_ContentValue, 0 as LDL_DOS,
   0 as HgbA1C_ContentValue, 0 as HgbA1C_DOS,
   Creatinine_ContentValue, Creatinine_DOS
 FROM         dbo.vwDiabetic_CreatinineTop3
) tbl1

 

')

Anything else that I can provide for someone to help me? I appreciate any/all feedback!