Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT CONVERT(Varchar(10), GeneratedDate, 101) AS GeneratedDate
- FROM dbo.ProviderProcessGeneratedDate
- ORDER BY GeneratedDate
- SELECT CONVERT(Varchar(10), a.GeneratedDate, 101) AS GeneratedDate
- FROM (SELECT DISTINCT Convert(DATETIME,CONVERT(Varchar(10), GeneratedDate, 101)) AS GeneratedDate
- FROM dbo.ProviderProcessGeneratedDate) a
- ORDER BY a.GeneratedDate DESC
- SELECT DISTINCT Convert(DATETIME,CONVERT(Varchar(10), GeneratedDate, 101))
- AS GeneratedDate,
- A.GeneratedDate OrderByDate
- FROM dbo.ProviderProcessGeneratedDate A
- Order By A.GeneratedDate Desc
- WITH Dates(GeneratedDate) AS
- (
- SELECT DISTINCT CONVERT(Varchar(10), GeneratedDate, 101) AS GeneratedDate
- FROM dbo.ProviderProcessGeneratedDate
- )
- SELECT GeneratedDate FROM Dates ORDER BY GeneratedDate
- ORDER BY ProviderProcessGeneratedDate.GenerateDate
- SELECT
- Convert(DATETIME,CONVERT(Varchar(10), GeneratedDate, 101))
- FROM
- ProviderProcessGeneratedDate
- GROUP BY
- GeneratedDate
- ORDER BY
- GeneratedDate
- SELECT
- Convert(DATETIME,CONVERT(Varchar(10), DATEADD(DAY, DATEDIFF(DAY, 0, GeneratedDate), 0), 101))
- FROM
- ProviderProcessGeneratedDate
- GROUP BY
- DATEADD(DAY, DATEDIFF(DAY, 0, GeneratedDate), 0)
- ORDER BY
- DATEADD(DAY, DATEDIFF(DAY, 0, GeneratedDate), 0)
- ORDER BY dbo.ProviderProcessGeneratedDate.GeneratedDate
- FROM dbo.ProviderProcessGeneratedDate ppgd
- SELECT DISTINCT CONVERT(Varchar(10), GeneratedDate, 101) AS GeneratedDateString
- FROM dbo.ProviderProcessGeneratedDate
- ORDER BY GeneratedDate
- SELECT DISTINCT CONVERT(Varchar(10), GeneratedDate, 101) AS GeneratedDate
- FROM dbo.ProviderProcessGeneratedDate
- ORDER BY CONVERT(Varchar(10), GeneratedDate, 112)
- SELECT
- CONVERT(Varchar(10), GeneratedDate, 101) AS GeneratedDate
- FROM
- dbo.ProviderProcessGeneratedDate AS BaseDates
- GROUP BY
- BaseDates.GeneratedDate,
- CONVERT(Varchar(10), GeneratedDate, 101)
- ORDER BY
- BaseDates.GeneratedDate
- select * from
- (
- SELECT DISTINCT CONVERT(varchar, GeneratedDate, 101) AS GeneratedDate
- FROM ProviderProcessGeneratedDate
- -- no need for ORDER BY, it is implicitly performed when DISTINCTing rows
- ) as y
- order by convert(datetime, GeneratedDate) DESC
Add Comment
Please, Sign In to add comment