| Newbie | | Join Date: Jun 2007
Posts: 19
| |
| re: Query Save Error
Quote:
Originally Posted by JKing Could you post the SQL for the query? This is the query. - SELECT "S0400016" AS LINE_HEADER, Format(TK_TCK_SALE_DETAILS1.DATE,'mmddyyyy') & Format(TK_TCK_SALE_DETAILS1.TIME,'hhnn') AS PURCHASE_TIME, Mid(TK_TCK_SALE_DETAILS1.WORKCODE,9,2) & '.' & FORMAT(RIGHT(CSTR(TK_TCK_SALE_DETAILS1.TCK_NBR),3),'000') & '.' & Format(TK_TCK_SALE_DETAILS1.DATE,'mmddyy') AS TRANSACTION_CODE, TK_IMPORT_TICKET1.TK_SERIAL_EXTERNAL AS TICKET_BARCODE, TK_PROGRAM_DETAILS1.SHORT_NAME AS TICKET_CODE, Format((TK_TCK_SALE_DETAILS1.TRANS_PRICE-TK_TCK_SALE_DETAILS1.USH_REVENUE)*100,'00000') AS TICKET_REVENUE, Replace(Space(25),Space(1),'0') & '00011' & Replace(Space(10),Space(1),'0') & Space(35) & Replace(Space(20),Space(1),'0') AS HARD_CODED_PARK_ID, TK_CATEGORY.CAT_SUB_NAME, TK_PROGRAM_DETAILS1.PROGRAM_ID
-
FROM ((TK_IMPORT_TICKET1 INNER JOIN TK_TCK_SALE_DETAILS1 ON TK_IMPORT_TICKET1.TK_SERIAL_INTERNAL = TK_TCK_SALE_DETAILS1.TK_SERIAL) INNER JOIN (TK_TICKET_TYPE INNER JOIN TK_CATEGORY ON TK_TICKET_TYPE.CAT_ID = TK_CATEGORY.CAT_ID) ON TK_TCK_SALE_DETAILS1.TCK_TYPE = TK_TICKET_TYPE.TCK_TYPE) INNER JOIN TK_PROGRAM_DETAILS1 ON TK_TICKET_TYPE.TCK_TYPE = TK_PROGRAM_DETAILS1.TCK_TYPE
-
WHERE (((TK_CATEGORY.CAT_SUB_NAME)="ONLINE TICKET STORE") AND ((TK_PROGRAM_DETAILS1.PROGRAM_ID)="SCVP" Or (TK_PROGRAM_DETAILS1.PROGRAM_ID)="SCVPI") AND ((TK_TCK_SALE_DETAILS1.DATE) Between [Start_Purchase_Date] And [End_Purchase_Date]))
-
ORDER BY TK_TCK_SALE_DETAILS1.DATE;
THanks.
|
