2. PHPRunner General questions
  3. [SOLVED]  CONVERT EXCEL FORMULAS TO SQL QUERIES
This topic is locked
[SOLVED]

 CONVERT EXCEL FORMULAS TO SQL QUERIES

 		11/14/2012 03:00:29
PHPRunner General questions
C
 chrispa author

HOW EASY IS TO CONVERT EXCEL FORMULAS TO SQL QUERIES AND GET ON THE FLY RESULTS
FOR EXAMPLE FOLLOWING EXPRESSION
=COUNTIF(B13:AA13,"X")/2+COUNTIF(AB12:AW12,"X")/2
THANKS YOU VERY MUCH IN ADVANCE
RGDS
C
 		cgphp 11/14/2012
SELECT

sum(

(

(case when B13 = 'X' then 1 else 0 end) +

(case when C13 = 'X' then 1 else 0 end) +

(case when D13 = 'X' then 1 else 0 end) +

(case when E13 = 'X' then 1 else 0 end) +

(case when F13 = 'X' then 1 else 0 end) +

(case when G13 = 'X' then 1 else 0 end) +

(case when H13 = 'X' then 1 else 0 end) +

(case when I13 = 'X' then 1 else 0 end) +

(case when J13 = 'X' then 1 else 0 end) +

(case when K13 = 'X' then 1 else 0 end)

) / 2) as total

from your_table_name

WHERE id in (12,13)