i want to order by name as well as status in my order the status = A , T, C .. since the status is oder by it gives me the results as A, C, T ... my sql is,
SELECT A.EE_NAME,A.EE_STATUS FROM EMPLOYEE_PERSONAL A INNER JOIN COMPANY_LIST B ON A.BROKERID = B.BROKERID AND A.CLIENTID = B.CLIENTID WHERE A.BROKERID =1 AND B.BROKERID = 1 AND A.CLIENTID = 1 AND B.CLIENTID = 2 ORDER BY A.EE_STATUS, A.EE_NAME;
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…