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: 3356

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

Download FREE API for Word, Excel and PDF in ASP.Net

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

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

Company

Explore

Follow us

Contact Us