Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by davidna2002
-
installing ODBC driver to access Micros
Hello All, I have read through numerous posts and have not found a clear way of installing an ODBC driver on a PC thats non-micros to access the Micros Database. I see the Adaptive Server Anywhere 9.0 ODBC driver on the server and it what i use there, as well as dbisql. I just want to set up...- davidna2002
- Thread
- Replies: 3
- Forum: Point of sale systems
-
MICROS :: Need query for totaling indivdual department totals.
Awesome thanks!!! I was able to get the revenue center daily details with the following query for example date 8/29/2013. select * from micros.v_R_rvc_sales where dateformat(business_date, 'yyyymmdd') = '20130829' order by micros.v_R_rvc_sales.rvc_number- davidna2002
- Post #6
- Forum: Point of sale systems
-
MICROS :: Need query for totaling indivdual department totals.
Here is the quesry that gets me the summation for a particular days sales. SELECT sales.*, trk.* FROM micros.v_R_sys_sales sales INNER JOIN micros.v_R_sys_trk trk ON sales.business_date=trk.business_date WHERE DATEFORMAT(sales.business_date, 'yyyymmdd') = '20130829'- davidna2002
- Post #4
- Forum: Point of sale systems
-
MICROS :: Need query for totaling indivdual department totals.
Hello All, And thank you for even looking at this thread. I am new to Micros, but have good SQL knowledge. I also have access to dbisql on the Micros Client server to run the queries. I can already extract by SQL query the daily totals as a whole from all the individual department summed up...- davidna2002
- Thread
- Replies: 5
- Forum: Point of sale systems
