Re: Store procedure Error 1064

[Fernando Genao]

from the Developer Server, I got.

mysql> call AgentTracking;
+--------------------------+--------------+---------+------+------+-----------+-----------+------------+-----------+-----------------+
| agentName | A | B | C | D | E | F | G | H |I |
+--------------------------+--------------+---------+------+------+-----------+-----------+------------+-----------+-----------------+
| Aaron Dilworth | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Aaron Johnson | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| Adriene Johnson | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 |
| Carli Cushman | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 |
| Darish Still | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| Elizabeth Schill | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| Fatima Brown | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
| Fernando Genao | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 2 |
| Food Belly | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| Francisco Murrieta | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| Jeff Gardner | 1 | 1 | 3 | 1 | 0 | 1 | 0 | 0 | 0 |
| Jose Francisco | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| Jose Lopez | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| Julio Lopez | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| Patrick Mooney | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 |
| Ricardo Marquez Gonzalez | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| Tim Taylor | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 |
| Trinette Fisher | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| Vtest Vtest | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
+--------------------------+--------------+---------+------+------+-----------+-----------+------------+-----------+-----------------+

From the Production Server I got;

mysql> call AgentTracking;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM QA.vwTrack r
WHERE (r.qaCreated BETWEEN @startDate AND @endDa' at line 2