Click here to Skip to main content
15,867,568 members

Comments by narendrag999 (Top 9 by date)

narendrag999 2-Oct-12 3:22am View    
Hi sir thanks i am able to get the reports, but data inside the report is missing for one report.
And also both are generating in single window.Need to generate separately.
Hope u got me..
thanks,
Nareeen
narendrag999 25-Sep-12 23:44pm View    
Thank you sir...
narendrag999 23-Sep-12 23:10pm View    
Hi pls find the query.

Insert into temp_a2_dly_work (STORE_ID,DAILY_DATE,SALES_CCAR,SALES_PCAR,SALES_OTC,MAST_TOTAL,VOID_ORDER ,
BAD_ORDER, TOT_SALES, SALES_TAX, BOTTLE_DEP, NET_SALES, COUPONS,NON_ROYAL_SALES,ROYAL_SALES,FOOD_BOUGHT,
CUST_CHARGE,RAISE_TILL,MILEAGE,CONT_LABOR,CPO_01_DESC,CPO_01,CPO_02_DESC,CPO_02,CPO_03_DESC,CPO_03,CPO_04_DESC,
CPO_04,CPO_05_DESC,CPO_05,CPO_06_DESC,CPO_06,CPO_07_DESC,CPO_07,CPO_08_DESC,CPO_08,CPO_09_DESC,CPO_09,CPO_10_DESC,
CPO_10,CPO_11_DESC,CPO_11,CPO_12_DESC,CPO_12,CPO_13_DESC,CPO_13,CPO_14_DESC,CPO_14,CPO_15_DESC,CPO_15,CPO_TOTAL,
FOOD_SOLD,CUST_PAY,LOWER_TILL,MROTS_01_DESC,MROTS_01,MROTS_02_DESC,MROTS_02,MROTS_03_DESC,MROTS_03,MROTS_04_DESC,
MROTS_04,MROTS_05_DESC,MROTS_05,MROTS_06_DESC,MROTS_06,MROTS_07_DESC,MROTS_07,MROTS_TOTAL,TOT_ACCT,DEP_TOTAL,
CASH_OS,END_TILL,CARRY_OUT,CO_COUPON,DLRY_COUPON,LUNCH_SALE,FC_FOOD,FC_COLA,FC_PAPER,FC_NON,IFC_FOOD,
IFC_COLA,IFC_PAPER,IFC_NON,LAB_SALARY,LAB_HOURLY,LAB_INSIDE,LAB_OUTSIDE,LAB_OVERTIME,TOT_MILE,TOT_COUPON_COST,
IN_CHARGE,BEG_ORDER,END_ORDER,HOLIDAY,NUM_PIZZA,PIZZA_SALE,NUM_ORD,ORDER_SALE,TOT_ORD,COMMENT1,COMMENT2,
COMMENT3,COMMENT4,COMMENT5,COMMENT6,NUM_OT_TIME,TOT_OT_TIME,NUM_LOAD_TIME,TOT_LOAD_TIME,NUM_OTD_TIME,
TOT_OTD_TIME,NUM_DLRY_TIME,TOT_DLRY_TIME,REPORT_DATE_TIME , YEAR_PD, USERID,CRED_CARD_TOTAL,GOVT_TAX,
CRED_VISA_TOTAL,CRED_MASTER_TOTAL,CASH_SALES_TOTAL,FOOD , LABOR, COUPON1, KMETER, FOODPER, LABORPER,
COUPONPER,KMETERPER , DELCOMPPER, DELPERSPER, OTCPER,flcmcost,flcmcostper,pctotal,WEBCASH_TOTAL,TOT_ACCT_BEF_ROUND,
TOT_ACCT_ROUND_DIFF)

SELECT STORE_ID,DAILY_DATE,SALES_CCAR,SALES_PCAR,SALES_OTC,MAST_TOTAL,VOID_ORDER , BAD_ORDER, TOT_SALES, SALES_TAX, BOTTLE_DEP, NET_SALES, COUPONS,NON_ROYAL_SALES,ROYAL_SALES,FOOD_BOUGHT,CUST_CHARGE,RAISE_TILL,MILEAGE,CONT_LABOR,CPO_01_DESC,CPO_01,CPO_02_DESC,CPO_02,CPO_03_DESC,CPO_03,CPO_04_DESC,CPO_04,CPO_05_DESC,CPO_05,CPO_06_DESC,CPO_06,CPO_07_DESC,CPO_07,CPO_08_DESC,CPO_08,CPO_09_DESC,CPO_09,CPO_10_DESC,CPO_10,CPO_11_DESC,CPO_11,CPO_12_DESC,CPO_12,CPO_13_DESC,CPO_13,CPO_14_DESC,CPO_14,CPO_15_DESC,CPO_15,CPO_TOTAL,FOOD_SOLD,CUST_PAY,LOWER_TILL,MROTS_01_DESC,MROTS_01,MROTS_02_DESC,MROTS_02,MROTS_03_DESC,MROTS_03,MROTS_04_DESC,MROTS_04,MROTS_05_DESC,MROTS_05,MROTS_06_DESC,MROTS_06,MROTS_07_DESC,MROTS_07,MROTS_TOTAL,TOT_ACCT,DEP_TOTAL,CASH_OS,END_TILL,CARRY_OUT,CO_COUPON,DLRY_COUPON,LUNCH_SALE,FC_FOOD,FC_COLA,FC_PAPER,FC_NON,IFC_FOOD,IFC_COLA,IFC_PAPER,IFC_NON,LAB_SALARY,LAB_HOURLY,LAB_INSIDE,LAB_OUTSIDE,LAB_OVERTIME,TOT_MILE,TOT_COUPON_COST,IN_CHARGE,BEG_ORDER,END_ORDER,HOLIDAY,NUM_PIZZA,PIZZA_SALE,NUM_ORD,ORDER_SALE,TOT_ORD,COMMENT1,COMMENT2,COMMENT3,COMMENT4,COMMENT5,COMMENT6,NUM_OT_TIME,TOT_OT_TIME,NUM_LOAD_TIME,TOT_LOAD_TIME,NUM_OTD_TIME,TOT_OTD_TIME,NUM_DLRY_TIME,TOT_DLRY_TIME,REPORT_DATE_TIME , YEAR_PD, 'MIS',CRED_CARD_TOTAL,GOVT_TAX,CRED_VISA_TOTAL,CRED_MASTER_TOTAL,CASH_SALES_TOTAL,'14226.93','17026.94','527.2','4.6','1053.61','1260.97','39.04','0.34','78.27','0','18.16','31785.67','2353.96','0',WEBCASH_TOTAL,TOT_ACCT_BEF_ROUND,TOT_ACCT_ROUND_DIFF from a2_dly_work where store_id = '85004' and daily_date = 'YYYY-MM-DD'


Thanks,
Naren
narendrag999 23-Sep-12 22:37pm View    
thank you..
narendrag999 18-Sep-12 3:22am View    
Hello Sir,

Need some info for my question if possible

Thanks,
Narrin