Search results for query: *

Nomed, can you post an example query of what you are seeing? Or post what column, table you are getting this info from. This will be a huge relief if this is the answer. Thank you.

So was anyone able to get this sorted?

Correction.... I mean micros.trans_dtl.type = S for all the rows

All M

A check is created with one bottle of wine. And sent in. This check is split in two. And sent in. [I'm assuming you split the wine equally, so at this point you'll have 2 checks with 1/2 bottle on each] Food Items are put on both checks separately. And sent in. The checks are combined back onto...

pmegan The 1 = 1 , is just there for testing and readability. This allows you to comment out some of the filters easily w/o having to rewrite the code. Like so: where 1 = 1 --and d.record_type <> 'R' and d.dtl_type <> 'N' But as you state beautifully " There are no entries linking the mi_seq...

I've been trying to retrieve what's printed on a guest check with a SQL query, stored procedure, or find a view that does this. I seem to be getting additional information with just a query. select ckdtl.chk_num, tdtl.chk_emp_seq as Check_Emp, tdtl.chk_seq as Check_Seq...

Hello Moregelen and RitwickGupta I am so glad I found this forum I was wondering if you could tell me: What is the name of the stored Proc to get the Current Menu items details, quantity, price (excluding items that have been moved from one ticket to another or split) in other words, the...