RMS SQL Stored Procedures


L

Luminox

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?
 
Ad

Advertisements

D

Doug Pic-N-Pac

What is a stored Procedure and where did you find it? Sounds very
interesting .....
 
L

Luminox

Try editing the Daily Sales By Cashier report ... take a look at the line
"ProcedureCall = "ListDailySalesByCashier".
 
D

Doug Pic-N-Pac

Hummm ok i see it but i dont know what it would be..maybesomeone else can
tell us.
 
C

convoluted

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 exception to the rule that everyone thinks they are the
exception to the rule --
 
D

Danny

Hey

I don't see it in the list of store procedures - so I think its a function
call inside of the RMS code.

Danny
 
Ad

Advertisements

L

Luminox

I didn't see it within SQL procedures either ... hence, my initial question.
Plus, you cannot execute it as you would a normal SQL store procedure. Just
was curious if any had any knowledge of their presence.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top