Click here to Skip to main content
15,867,453 members
Home / Discussions / Database
   

Database

 
GeneralRe: Choosing a proper database for mobile messenger app Pin
Richard MacCutchan18-Apr-23 0:29
mveRichard MacCutchan18-Apr-23 0:29 
GeneralRe: Choosing a proper database for mobile messenger app Pin
jschell18-Apr-23 5:15
jschell18-Apr-23 5:15 
QuestionHow do I retrieve the manipulated blob? Pin
lookilok4-Apr-23 21:09
lookilok4-Apr-23 21:09 
AnswerRe: How do I retrieve the manipulated blob? Pin
jschell5-Apr-23 6:35
jschell5-Apr-23 6:35 
GeneralRe: How do I retrieve the manipulated blob? Pin
lookilok5-Apr-23 21:51
lookilok5-Apr-23 21:51 
GeneralRe: How do I retrieve the manipulated blob? Pin
jschell6-Apr-23 5:20
jschell6-Apr-23 5:20 
AnswerRe: How do I retrieve the manipulated blob? Pin
Richard MacCutchan6-Apr-23 6:08
mveRichard MacCutchan6-Apr-23 6:08 
QuestionTSQL, Order by case, and I need to order by version Pin
jkirkerx21-Mar-23 8:09
professionaljkirkerx21-Mar-23 8:09 
This worked fine until I got to version 11, where the version numbers sorted like this - vers_id
0, 1, 10, 2, 3, 4, 5, 6, 7, 8, 9, I was expecting 0, 1, 2, 3, 4, ....

I'm thinking that I need another sort clause but sure how to integrate it into my case
But then I could be wrong, and my case statements may just need to be better.
Everything I tried failed. Looking for help on this to keep my customers project clean.
SQL
SELECT
    Proj_Stage,
    vers_id,
    vers_note, 
    markup_price, 
    sell_price, 
    CONVERT(CHAR(19), sell_date, 120)<br />
FROM proj_vers 
WHERE proj_id = '$projectNumber'
ORDER BY CASE 
    WHEN CONVERT(VARCHAR, Proj_Stage) = 'designing' THEN 0
    WHEN CONVERT(VARCHAR, Proj_Stage) = 'engineering' THEN 1
    WHEN CONVERT(VARCHAR, Proj_Stage) = 'construction' THEN 2
    WHEN CONVERT(VARCHAR, Proj_Stage) = 'finished' THEN 3<br />
END

I tried this
SQL
END, vers_id

And I tried this
SQL
WHEN CONVERT(VARCHAR, Proj_Stage) = 'construction' THEN 2, vers_id DESC
If it ain't broke don't fix it
Discover my world at jkirkerx.com

AnswerRe: TSQL, Order by case, and I need to order by version Pin
Ron Nicholson21-Mar-23 8:22
professionalRon Nicholson21-Mar-23 8:22 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jkirkerx21-Mar-23 8:36
professionaljkirkerx21-Mar-23 8:36 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
Mycroft Holmes21-Mar-23 12:23
professionalMycroft Holmes21-Mar-23 12:23 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jkirkerx21-Mar-23 13:17
professionaljkirkerx21-Mar-23 13:17 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jsc4222-Mar-23 0:17
professionaljsc4222-Mar-23 0:17 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jkirkerx22-Mar-23 6:42
professionaljkirkerx22-Mar-23 6:42 
GeneralRe: TSQL, Order by case, and I need to order by version Pin
jkirkerx21-Mar-23 8:46
professionaljkirkerx21-Mar-23 8:46 
GeneralRe: TSQL, Order by case, and I need to order by version Pin
Ron Nicholson21-Mar-23 11:17
professionalRon Nicholson21-Mar-23 11:17 
AnswerRe: TSQL, Order by case, and I need to order by version Pin
jschell23-Mar-23 6:26
jschell23-Mar-23 6:26 
GeneralRe: TSQL, Order by case, and I need to order by version Pin
jkirkerx23-Mar-23 9:03
professionaljkirkerx23-Mar-23 9:03 
QuestionSQL where clause variability up against coding standards Pin
Brian L Hughes10-Mar-23 15:59
Brian L Hughes10-Mar-23 15:59 
AnswerRe: SQL where clause variability up against coding standards Pin
Dave Kreskowiak11-Mar-23 5:37
mveDave Kreskowiak11-Mar-23 5:37 
AnswerRe: SQL where clause variability up against coding standards Pin
Eddy Vluggen11-Mar-23 9:00
professionalEddy Vluggen11-Mar-23 9:00 
AnswerRe: SQL where clause variability up against coding standards Pin
jschell13-Mar-23 6:56
jschell13-Mar-23 6:56 
AnswerRe: SQL where clause variability up against coding standards Pin
jsc4223-Mar-23 7:32
professionaljsc4223-Mar-23 7:32 
GeneralRe: SQL where clause variability up against coding standards Pin
Brian L Hughes23-Mar-23 14:52
Brian L Hughes23-Mar-23 14:52 
GeneralRe: SQL where clause variability up against coding standards Pin
jsc4227-Mar-23 23:00
professionaljsc4227-Mar-23 23:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.