I have written the sql query but I am getting error as
Incorrect syntax near 'company_name'.
I am using SQL server 2005
SELECT top 1 month(a.dt_of_leave)MONTH,
year(a.dt_of_leave)YEAR FROM emp_mst a WHERE MONTH(a.dt_of_leave) >= MONTH(getdate())-1
AND YEAR(a.dt_of_leave)= CASE WHEN MONTH(getdate())=1 THEN YEAR(getdate())-1 ELSE YEAR(getdate()) company_name 'COMPANY NAME',
Deputed_Company_Name 'DEPUTED COMPANY NAME' emp_card_no 'EMP CODE',
emp_name 'EMPLOYEE NAME',
LWP,
'' Remarks,
Adj_Days Gain_Loss_LOP_Days,
VAL_DAY LOP_Days_Desc,
MONTH,
YEAR
FROM XXACL_EMP_INFO_LWP_OTDAYS_HRS_V WHERE emp_type='C'
AND MONTH = '3'
AND YEAR = '2016'
AND emp_card_no IN(312,
1250,
362)
Aucun commentaire:
Enregistrer un commentaire