title: Problem in converting the varchar value '1.33' to data type int
body: <p>I have 5 case statements (just showing 2 case statements only).</p>
  
  <pre><code>SELECT DISTINCT 
         CASE [GRADE1]
           when 1 then 1
           when 2 then 3
           when 3 then 5
           when 4 then 7
           when 5 then 9
         End as Q1,
         CASE [GRADE2]
           when 1 then 1
           when 2.3 then 3
           when 3.33 then 5
           when 4.67 then 7
           when 1 then 9
         End as Q2
    FROM abcd
  </code></pre>
  
  <hr>
  
  <p>Here I am trying to put the values in temp  table which I need to map in later select syntax</p>
  
  <pre><code>SELECT a,b     
    INTO #Temp_Q
    FROM xyz 
   WHERE [ds]= 'Data'
  
     select distinct t.[b] as [Q]
       from abcd s
  left join #Temp_Q t on s.[GRADE1]  = t.[a]
                         s.[GRADE2]  = T.[a]
  </code></pre>
  
  <p>Instead of hardcoding all these values  i am asked to write code.</p>
  
  <p>Now i am getting error.. And don't know how to convert. [GRADE2] (FLOAT,NULL) is the datatype assinged in the column.</p>
  
  <blockquote>
    <p>Msg 245, Level 16, State 1, Line 14
    Conversion failed when converting the varchar value '1.33' to data type int.</p>
  </blockquote>