jeudi 14 avril 2016

SQL query error not working

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