Click here to Skip to main content
15,791,771 members
Home / Discussions / Database
   

Database

 
AnswerRe: Retail inventory management DB Design Pin
Victor Nijegorodov13-Apr-21 1:54
Victor Nijegorodov13-Apr-21 1:54 
AnswerRe: Retail inventory management DB Design Pin
RedDk13-Apr-21 13:10
RedDk13-Apr-21 13:10 
QuestionRe: Retail inventory management DB Design Pin
Eddy Vluggen13-Apr-21 14:00
professionalEddy Vluggen13-Apr-21 14:00 
AnswerRe: Retail inventory management DB Design Pin
Mycroft Holmes14-Apr-21 14:32
professionalMycroft Holmes14-Apr-21 14:32 
QuestionConvert date, did I go too far Pin
jkirkerx8-Apr-21 13:50
professionaljkirkerx8-Apr-21 13:50 
AnswerRe: Convert date, did I go too far Pin
Victor Nijegorodov8-Apr-21 21:22
Victor Nijegorodov8-Apr-21 21:22 
AnswerRe: Convert date, did I go too far Pin
Richard Deeming8-Apr-21 23:03
mveRichard Deeming8-Apr-21 23:03 
GeneralRe: Convert date, did I go too far Pin
jkirkerx9-Apr-21 7:14
professionaljkirkerx9-Apr-21 7:14 
This makes more sense to me now.
so I need to make sure that I craft the dates, like 04 for April by adding the 0.

And on the Select statement, I can convert to string to get the output in the format that I want,
But on the condition statement, convert to the format that SQL server works the best with.

No wonder why I crashed the database server.

I'll give it a try today.

Thanks Richard.
And Thanks to the other guy about the Floor
If it ain't broke don't fix it
Discover my world at jkirkerx.com

GeneralRe: Convert date, did I go too far Pin
Mycroft Holmes9-Apr-21 13:21
professionalMycroft Holmes9-Apr-21 13:21 
GeneralRe: Convert date, did I go too far Pin
jkirkerx9-Apr-21 15:20
professionaljkirkerx9-Apr-21 15:20 
GeneralRe: Convert date, did I go too far Pin
Richard Deeming11-Apr-21 22:10
mveRichard Deeming11-Apr-21 22:10 
AnswerRe: Convert date, did I go too far, Sort of solved Pin
jkirkerx10-Apr-21 15:06
professionaljkirkerx10-Apr-21 15:06 
QuestionExcel Spreadsheet To Database Migration Assistance Pin
Glen McHale7-Apr-21 0:55
Glen McHale7-Apr-21 0:55 
SuggestionRe: Excel Spreadsheet To Database Migration Assistance Pin
CHill607-Apr-21 1:57
mveCHill607-Apr-21 1:57 
AnswerRe: Excel Spreadsheet To Database Migration Assistance Pin
Mycroft Holmes7-Apr-21 13:54
professionalMycroft Holmes7-Apr-21 13:54 
QuestionSQLite query Pin
David Crow23-Mar-21 11:02
David Crow23-Mar-21 11:02 
AnswerRe: SQLite query Pin
k505423-Mar-21 15:42
mvek505423-Mar-21 15:42 
GeneralRe: SQLite query Pin
David Crow23-Mar-21 17:10
David Crow23-Mar-21 17:10 
AnswerRe: SQLite query Pin
Richard Deeming24-Mar-21 0:31
mveRichard Deeming24-Mar-21 0:31 
GeneralRe: SQLite query Pin
David Crow24-Mar-21 4:16
David Crow24-Mar-21 4:16 
QuestionDisallowed implicit conversion from data type smalldatetime to data type float Pin
jkirkerx18-Mar-21 12:56
professionaljkirkerx18-Mar-21 12:56 
AnswerRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
Victor Nijegorodov18-Mar-21 22:15
Victor Nijegorodov18-Mar-21 22:15 
GeneralRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
jkirkerx19-Mar-21 7:58
professionaljkirkerx19-Mar-21 7:58 
GeneralRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
jsc4219-Mar-21 8:45
professionaljsc4219-Mar-21 8:45 
GeneralRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
jkirkerx19-Mar-21 9:54
professionaljkirkerx19-Mar-21 9:54 

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.