Instead of your verbal description would you mind sharing the results you'd expect as the result of "SELECT * FROM InventoryThatNeedsReorders"?

Based on your sample data, what would be the expected output?

Steve Jones - Editor (2/5/2010)

---

Lutz,

I could track back the person, but I don't think it's appropriate, at least without a subpoena or other legal instrument. We worked hard to protect...

Please provide table def, sample data, expected result and what you've tried so far as described in the first link in my signature.

It's much easier to demonstrate what you're trying...

I truly hope just in terms of SQL stuff!! Family/social life is even more important than SQL! 😉

Paul White (2/4/2010)

---

lmu92 (2/4/2010)

---

Special thanks to the standard purchasing guidelines to have an RFQ process that involves at least 10 suppliers (each one having your contact information) if you need...

I'm glad I could help! 😀

Sometimes those rather...

Thank you for your response.

I'm still not sure what I should learn from it:

On one hand it shows that it's important to notice if an OP obviously posts "real data"...

I can't see a reason why the following concept wouldn't work...

DECLARE @orderby VARCHAR(30)

SET @orderby='MSDue'

SELECT *

FROM myTable

ORDER BY

CASE @orderby

WHEN 'Job' THEN Col1

WHEN 'Author' THEN Col2

WHEN...

No. Not in this thread, since I don't think there should be a parallel discussion.

mbookout (2/4/2010)

---

One more question. I'm running a query that is pulling username, but sometimes there are trailing spaces at the end of the username that I don't want. ...

Just a short update regarding the real life address data I talked about a few dozens posts ago:

I talked to my friend and he forwarded the info to his IT...

You need to convert your date values to varchar using CONVERT() function.

You could use CONVERT(VARCHAR(19),Job.[MS Due Date],120) to get a date format which can be sorted.

Duplicate post.

Please continue discussion here.

Would you mind providing some more test data to play with?

I'm thinking of a solution that might work but I'd like to test it a little further...