select datename(mm,res_date),* from Tablename order by convert(int,right(

please bar with my english
i having a database called tblhallreservation in which
res_date is date field
has to select all the fields in table deponding on month
either has to display all details for the month jan or feb
and so on

Question Posted / kiran bala rath

1 Answers
3594 Views
I also Faced
E-Mail Answers

Answer Posted / kiran bala rath

select datename(mm,res_date),* from Tablename order by
convert(int,right(left(convert(varchar,res_date,105),5),2))
asc

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to return the date part only from a sql server datetime datatype?

1168

State a few properties of relational databases?

1181

Can we call stored procedure in trigger?

999

What are the advantages of using a stored procedure?

1063

what is datawarehouse?

1159

Define left outer join?

1028

What is the partitioning method?

1067

Why is replication required on the sql server?

1107

How do you rename a table in sql server?

1103

What security features are available for stored procedure?

1080

what are the new features in SSRS?

147

What is the new security features added in sql server 2014? : sql server security

1050

How to change the name of a database user?

1012

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1171

What is named query? : sql server analysis services, ssas

1005