Hi
My Table and data like this
Create Table Monthtable
(
Dateval Date
)
Insert into Monthtable values('06/07/2015')
Insert into Monthtable values('06/08/2015')
Insert into Monthtable values('06/09/2015')
Insert into Monthtable values('06/10/2015')
Insert into Monthtable values('06/11/2015')
Insert into Monthtable values('06/12/2015')
Insert into Monthtable values('06/13/2015')
DayNames DayNo
============================
Sunday 1
Monday 2
Tuesday 3
Wednesday 4
Thursday 5
Friday 6
Saturday 7
-- But I need output like this
DayNames DayNo
============================
Monday 1
Tuesday 2
Wednesday 3
Thursday 4
Friday 5
Saturday 6
Sunday 7
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com