Parameter Question

Question

Post reply

Parameter Question

Viewing 7 posts - 16 through 21 (of 21 total)

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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

HTH. Make sure you don't forget the tip about between... might save you a lot of troubles.

Kerrie Sorrell SSC Eights! Points: 921 More actions · Answer 2

I GOT IT !!!!!

THANK YOU!!!! to everyone.

I will remember what you said rqR'us, in fact I am printing this out and keeping by my desk.

Thank you again!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

HTH 2. Now that reminds me of this thread .

Do we need paper?

Kerrie Sorrell SSC Eights! Points: 921 More actions · Answer 4

There will always be paper. Every office I have worked at was "paperless", what a joke!!! The day there is an actual "paperless office" is the day the world will fold in an itself.

Thanks, Kerrie

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

So true... but there's something to be said for less paper even if paperless out of the question .

Kerrie Sorrell SSC Eights! Points: 921 More actions · Answer 6

Thats True, more trees, more oxygen, less pollution......

Martin N Ten Centuries Points: 1216 More actions · Answer 7

Change your ORDER BY from

ORDER BY RTRIM(CAST(DATEPART(Year, TimeLineDate) AS char(4)) + '/' + CAST(DATEPART(Month, TimeLineDate) AS char)) DESC

to ...

ORDER BY DATEPART(Year, TimeLineDate) ASC, DATEPART(Month, TimeLineDate) ASC

Kindest Regards,

Martin