Database

Quote:

SQL

select distinct(Emp_Status),
       count ( Att_Mints/60) as OTHOUR,
       COUNT (Att_Totalmints /60 ) as ProductionHours
       from Attendence
       inner join EmployeeMaster on fk_Att_EmpCode=fk_Att_EmpCode
where year(Att_Date)='2014' and Month (Att_Date)='1'
 group by Emp_Status

in above query Count of

Att_Mints

is =150
and count of

Att_Totalmints

is 120

i want output of OTHOURS=1:30min
and

ProductionHours

=2 hour


please help me

<pre lang="vb">DECLARE @CheckQuantity INT
         SET @ParmDefinition = N&#39;@CheckQuantity INT&#39;
         SET @SQL = N&#39;
         SET @CheckQuantity= 12&#39;
                        PRINT @SQL

            EXEC [dbo].sp_executesql @SQL, @ParmDefinition,
            @CheckQuantity=@CheckQuantity;
            PRINT @CheckQuantity</pre>

It Should Print 12 but the output is NULL , Please tell me How to SET VALUE For the VAriable declare outside the SQL Text cretaed for dynamic query

my query like this

cte3_persen (per) as 
(select ((cte1.totalcount/cte2.TotaCount)* 100 ) 
from cte1,cte2) 

i am creating one new cte table shown above 
from that value '2'coming from cte1.totalcount and value '500' coming from cte2.TotaCount 
 i want percentage of those value it should be in 0.00% format   
i want ans of per from cte3_persen table is =0.40%  
 please help some one