Comments by Nirmal Chandru

Nirmal Chandru 28-Feb-17 7:20am View

I want Below Query wise result
sp_name -->Storeprocedure Name

Sql Query:
SELECT sp.Column1,sp.Column2,sp.Column3, t.column1,t.column2
FROM sp_name (any Argumnets) sp INNER JOIN table2 t ON t.no = sp.no

Nirmal Chandru 4-Feb-15 6:58am View

I want above me joined two table But Latetedate with earlyoutdate at the
the same time order the below result wise want.
EmpID LateDate EarlyOutDate
1001 2-Dec-14 NULL
1001 10-Dec-14 NULL
1001 NULL 18-Dec-14
1001 NULL 26-Dec-14
1001 29-Dec-14 NULL

Nirmal Chandru 18-Dec-14 9:12am View

Thank you

Nirmal Chandru 18-Dec-14 7:45am View

above code wise i am worked but not came particularly 2014-12-01 this date result but came that month all data came.

I want particularly 2014-12-01 this date record only

Thanks

Nirmal Chandru 18-Dec-14 7:19am View

Hai sir,

Your send query wise check but Previous month date also came below that query me given.
query already given

StaffID StaffName Fromdate ToDate TotalDays Applied
1059 T T SIVAM 29-Nov-14 7-Dec-14 7 24-Nov-14
1029 ROY CHOUDURY P K 1-Dec-14 31-Jan-15 54 13-Nov-14

Result first record is last month record came so i don't want display that record.
this is my problem.
Thanks

Nirmal Chandru 6-Dec-14 8:39am View

I want Current month selected get last month record
ex:
Dropdown selected "September" so i want result is "october" month Record

Comments by Nirmal Chandru (Top 6 by date)