I have 2 stored procedures one that selects the column and the other to insert. My select is no problem but to insert is the tricky part.
basically I know how to insert but to insert for example...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Studio_.NET_2005/Q_23271...
I am trying to get a stored p to return the result of the following query. There's my sp syntax, i get a 1064 at line 3. This query works just fine stand alone in query browser.
DELIMITER $$...
http://www.experts-exchange.com/Database/MySQL/Q_21805573.html
Zones:
MySQL ServerDate Answered: 04/07/2006 Grade: A Views: 0
Background:
I have two tables (there are no keys on either table)
Table A has columns Acct Num, Inv Num, Inv Date
Example: 123, 9998, 2007-01-01
224,1010, 2007-02-...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23174861.html
I have two tables, one contains sales and another credits.
Example: Sales:
Acct # Inv Date Item Num Qty Unit Price Vendor ID Desc
...
http://www.experts-exchange.com/Database/MySQL/Q_23187157.html
SELECT S.*
FROM Credit C
INNER JOIN
Sales S ON (C.[Acct num] = S.[Acct num] AND
C.[Item Num] = S.[Item Num] AND
ABS(C.[Qty]) > ABS(...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23187572.html
I need to create a query or a stored procedure that will return all the time entry records for all employees - even if the employee didn't record time for the given day.
Time_Table
* Employee...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23420773.html
