Issue with duplicate data

Question

Post reply

Issue with duplicate data

Viewing 5 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

Oh, I see what you mean now.

Change ORDER BY to:

ORDER BY [Employee Name]

,CAST('01 '+ [Month] + ' ' + CAST([Year] AS VARCHAR) AS DATE)

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

pwalter83 SSChampion Points: 14575 More actions · Answer 2

Eugene Elutin (5/3/2012)
Oh, I see what you mean now.
Change ORDER BY to:
ORDER BY [Employee Name]
,CAST('01 '+ [Month] + ' ' + CAST([Year] AS VARCHAR) AS DATE)

Thanks for this Eugene,

Will try this tomorrow at my office...Good Night !!

pwalter83 SSChampion Points: 14575 More actions · Answer 3

Eugene Elutin (5/3/2012)
Oh, I see what you mean now.
Change ORDER BY to:
ORDER BY [Employee Name]
,CAST('01 '+ [Month] + ' ' + CAST([Year] AS VARCHAR) AS DATE)

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 4

Good Luck!

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

pwalter83 SSChampion Points: 14575 More actions · Answer 5

pwalter83

SSChampion

Points: 14575

January 27, 2014 at 7:38 am

#1683546

no issues.