DQ's picture
Nov 01, 2013
4208 views
Reputation: 5

SQL query to retrieving recent 8 tickets

Hello,

  I am implementing Kitchen display for my store where I need to display last 8 tickets with items, void and other details.  What would be the SQL query to retrieve this data?

 

My idea is running a python web server on a back office computer where MS SQL Server is running.   Web Server will process incoming request, execute SQL query to retrieve recent 8 tickets details and return data in a formated HTML page.

Client (Raspberry Pi) will be accessing web page and refresh every 1 minute.

Thanks,

DQ

 

1 answers

QMcKay's picture
QMcKay
Nov 01, 2013
Reputation: 17
We have already answers to
1029 questions
E-Posta Facebook Twitter RSS Skype
Telefon (212) 252 0634