I was "poking" around some of the RMS reports and came across a STORED PROCEDURE (ListDailySalesByCashier). Can someone tell me WHERE I can find this stored procedure and what OTHER stored procedures are there?
RMS SQL Stored Procedures
Jan 11, 2008
6 Replies
Try editing the Daily Sales By Cashier report ... take a look at the line "ProcedureCall = "ListDailySalesByCashier".
"Doug Pic-N-Pac" wrote:
Hi guys - a stored procedure is kind of like a set of sql statements that are saved in the database; they are usually created to "save" complex queries in order to speed up the actual query by saving it as a stored procedure; if you google "stored procedure" or check out the SQL books on line you'll get additional info on stored procedures, but they are not meant to be "used" by RMS users, they "came" with the software to speed up the reports where they are called (as you found out) Experienced SQL users can come up with their own stored procedures and save them in the database but its not for the faint of heart. Happy googling...
-- There is no excepti> Hummm ok i see it but i d>
Hey
I don't see it in the list of store procedures - so I think its a function call inside of the RMS code.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required