Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
DECLARE @VSTARTDATE DATETIME = '2014-09-01', @VENDDATE DATETIME = '2014-09-23'; SELECT AVG(TOT_AMT) AS [Average Basket Total] , COUNT(TRAN_ID) AS [Transaction Count] FROM TRANS_HEADER TH WHERE CONVERT( DATE, TH.TRAN_STRT_TS) BETWEEN @VSTARTDATE AND @VENDDATE AND TH.TRAN_CD = 1 -- TRAN CODE = 1, SALES ONLY AND TH.VOID_CD = 0 -- NO VOIDS AND TH.TRNING_MDE_FG = 0 -- NOT TRAINING MODE
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.