Click here to Skip to main content
15,868,016 members
Home / Discussions / Database
   

Database

 
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 
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 
I'm stuck with the existing database to make it backwards capable, with older construction projects. Every record has a ...

project number
project stage
version number

This table keeps track of the versions of the construction project. As typical, customers that have construction done always change their mind during the construction process, and don't understand once you pull a permit from the city, you can't change the project. But they change it anyways and then you have to get a new permit.

I didn't get any documentation, nor useful comments and had to reverse engineer the old version to make this new version of the software. And it was very broken and needed fixing, thus below ...
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
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 
GeneralRe: SQL where clause variability up against coding standards Pin
jschell28-Mar-23 6:23
jschell28-Mar-23 6:23 
QuestionCode: 1292 SQL State: 22007 --- Incorrect datetime value Pin
Siavash.BRY6-Mar-23 20:56
Siavash.BRY6-Mar-23 20:56 
AnswerRe: Code: 1292 SQL State: 22007 --- Incorrect datetime value Pin
Richard MacCutchan6-Mar-23 21:26
mveRichard MacCutchan6-Mar-23 21:26 
GeneralRe: Code: 1292 SQL State: 22007 --- Incorrect datetime value Pin
Siavash.BRY6-Mar-23 21:52
Siavash.BRY6-Mar-23 21:52 

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.