Skip to Content
0
Former Member
Sep 09, 2010 at 07:37 AM

Report

26 Views

i have these two query i want to club them

1.SELECT T0.[U_empName], T0.[U_NetAmt] FROM [dbo].[@BIZ_SALLOG] T0 WHERE T0.[U_Code] ='EPF' And T0.[U_MthID] Like '%%[%0]%%'

2.SELECT T0.[U_empName], T0.[U_NetAmt] FROM [dbo].[@BIZ_SALLOG] T0 WHERE T0.[U_Code] ='ESI' And T0.[U_MthID] Like '%%[%0]%%'

the out put i want like this

Emp name, EPF Amt., ESI Amt.