DD string value as DateTime in SQL Server Query

Prasunje...

SOLVED CLOSED ACTIVE ANSWERED
User: Prasunjeet
Posted: on Sep 04, 2015 03:55 AM
Forum: SQL Server
Answer: 1
Views: 4006

i have a table with follwing structure:

tblname - userinfo

userid - int

free - boolean

premium - boolean

udate - datetime

i want to know the query by which i can see result like follows

userid free preminum udate

3 no yes 02/05/2015

2 no yes 01/05/2015

4 yes no 02/05/2015

1 yes no 31/04/2015

two condition to show record:

1. show premium record with date desc order

2.after that free record with date desc order

please provide query help to get this result

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Sep 04, 2015 04:37 AM
Modified: on Aug 28, 2017 06:48 AM
Report

Hi Prasunjeet,

Please refer the below code which full-fill your requirement.

SQL

DECLARE @userinfo TABLE (userid INT, free VARCHAR(10),premium VARCHAR(10),udate DATETIME)
INSERT INTO @userinfo VALUES(1,'yes','no','2015/05/31'),
							(2,'no','yes','2015/01/05'),
							(3,'no','yes','2015/02/05'),
							(4,'yes','no','2015/02/05'),
							(5,'yes','no','2015/06/30')
SELECT userid,free,premium,CONVERT(VARCHAR(20),udate,101) udate 
FROM @userinfo ORDER BY ISNULL(UPPER(free),'NO'),udate DESC

Screenshot

Convert and Sort YYYY/MM/DD string value as DateTime in SQL Server Query

Company

Explore

Follow us

Contact Us