[cswtsjaij]

How would go about creating a cursor FOR loop for the following:

a. Retrieve the id, firstname, and lastname of the employee who lives in Chicago

b. Insert that employee's id, firstname and lastname into a temp table, that you will create.

c. The temp table can have whatever column names you decide, but must include the id, firstname, and lastname of the employee who lives in Chicago.

I just need help getting this started.

THANKS

[rockstar_]

cswtsjaij, on 20 Oct, 2006 - 12:41 PM, said:

c. The temp table can have whatever column names you decide, but must include the id, firstname, and lastname of the employee who lives in Chicago.

May I ask why you'd like to create a temporary table? What's the implementation for it? I currently am experiencing growing pains in a web application I work on. Temporary tables, as databases get larger, cause the most HELLACIOUS overhead. In fact, I've got a few MySQL experts completely stumped on how to remedy this situation.

And so I ask why because I'm trying to get away from them, and you're trying to make one.

rockstar_