[SOLVED]  CONVERT EXCEL FORMULAS TO SQL QUERIES

This topic is locked

[SOLVED] CONVERT EXCEL FORMULAS TO SQL QUERIES	11/14/2012 3:00:29 AM
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)`