Click here to Skip to main content
15,848,407 members
Home / Discussions / Database
   

Database

 
QuestionHow do I retrieve the manipulated blob? Pin
lookilok4-Apr-23 22:09
lookilok4-Apr-23 22:09 
AnswerRe: How do I retrieve the manipulated blob? Pin
jschell5-Apr-23 7:35
jschell5-Apr-23 7:35 
GeneralRe: How do I retrieve the manipulated blob? Pin
lookilok5-Apr-23 22:51
lookilok5-Apr-23 22:51 
GeneralRe: How do I retrieve the manipulated blob? Pin
jschell6-Apr-23 6:20
jschell6-Apr-23 6:20 
AnswerRe: How do I retrieve the manipulated blob? Pin
Richard MacCutchan6-Apr-23 7:08
mveRichard MacCutchan6-Apr-23 7:08 
QuestionTSQL, Order by case, and I need to order by version Pin
jkirkerx21-Mar-23 9:09
professionaljkirkerx21-Mar-23 9:09 
AnswerRe: TSQL, Order by case, and I need to order by version Pin
Ron Nicholson21-Mar-23 9:22
professionalRon Nicholson21-Mar-23 9:22 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jkirkerx21-Mar-23 9:36
professionaljkirkerx21-Mar-23 9:36 
Great idea!

I just checked the table and vers_id was set to char.

Just crafted this and it does what I want now. I didn't think of that, where it sorted as chars and not numbers.

Good eye, or stab in the dark, very helpful and spot on.
SQL
SELECT
    Proj_Stage,
    CAST(vers_id AS int),
    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, CAST(vers_id AS int) ASC
If it ain't broke don't fix it
Discover my world at jkirkerx.com

GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
Mycroft Holmes21-Mar-23 13:23
professionalMycroft Holmes21-Mar-23 13:23 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jkirkerx21-Mar-23 14:17
professionaljkirkerx21-Mar-23 14:17 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jsc4222-Mar-23 1:17
professionaljsc4222-Mar-23 1:17 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jkirkerx22-Mar-23 7:42
professionaljkirkerx22-Mar-23 7:42 
GeneralRe: TSQL, Order by case, and I need to order by version Pin
jkirkerx21-Mar-23 9:46
professionaljkirkerx21-Mar-23 9:46 
GeneralRe: TSQL, Order by case, and I need to order by version Pin
Ron Nicholson21-Mar-23 12:17
professionalRon Nicholson21-Mar-23 12:17 
AnswerRe: TSQL, Order by case, and I need to order by version Pin
jschell23-Mar-23 7:26
jschell23-Mar-23 7:26 
GeneralRe: TSQL, Order by case, and I need to order by version Pin
jkirkerx23-Mar-23 10:03
professionaljkirkerx23-Mar-23 10:03 
QuestionSQL where clause variability up against coding standards Pin
Brian L Hughes10-Mar-23 16:59
Brian L Hughes10-Mar-23 16:59 
AnswerRe: SQL where clause variability up against coding standards Pin
Dave Kreskowiak11-Mar-23 6:37
mveDave Kreskowiak11-Mar-23 6:37 
AnswerRe: SQL where clause variability up against coding standards Pin
Eddy Vluggen11-Mar-23 10:00
professionalEddy Vluggen11-Mar-23 10:00 
AnswerRe: SQL where clause variability up against coding standards Pin
jschell13-Mar-23 7:56
jschell13-Mar-23 7:56 
AnswerRe: SQL where clause variability up against coding standards Pin
jsc4223-Mar-23 8:32
professionaljsc4223-Mar-23 8:32 
GeneralRe: SQL where clause variability up against coding standards Pin
Brian L Hughes23-Mar-23 15:52
Brian L Hughes23-Mar-23 15:52 
GeneralRe: SQL where clause variability up against coding standards Pin
jsc4228-Mar-23 0:00
professionaljsc4228-Mar-23 0:00 
GeneralRe: SQL where clause variability up against coding standards Pin
jschell28-Mar-23 7:23
jschell28-Mar-23 7:23 
QuestionCode: 1292 SQL State: 22007 --- Incorrect datetime value Pin
Siavash.BRY6-Mar-23 21:56
Siavash.BRY6-Mar-23 21:56 

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.