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

Database

 
SuggestionRe: Get columns name Pin
Richard Deeming31-Aug-21 5:50
mveRichard Deeming31-Aug-21 5:50 
QuestionSQL statements Pin
Erick Kaira27-May-21 9:09
Erick Kaira27-May-21 9:09 
AnswerRe: SQL statements Pin
Victor Nijegorodov27-May-21 9:40
Victor Nijegorodov27-May-21 9:40 
AnswerRe: SQL statements Pin
SeanChupas27-May-21 10:02
SeanChupas27-May-21 10:02 
QuestionRe: SQL statements Pin
David Crow27-May-21 10:12
David Crow27-May-21 10:12 
AnswerRe: SQL statements Pin
Mycroft Holmes27-May-21 13:19
professionalMycroft Holmes27-May-21 13:19 
QuestionSQL query dilemma Pin
David Crow20-May-21 11:31
David Crow20-May-21 11:31 
AnswerRe: SQL query dilemma Pin
Mycroft Holmes20-May-21 14:05
professionalMycroft Holmes20-May-21 14:05 
You need to make the query quite a bit more complex. Probably half a dozen based on each vehicle and service type and the date and the mileage

Select Top 1 fieldname from tablename order by (date or mileage)
filter by vehicle and service type.

You can then either pivot the results or accept multiple rows.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

QuestionAccounting problem in SQL Pin
Member 1400680616-May-21 0:23
Member 1400680616-May-21 0:23 
AnswerRe: Accounting problem in SQL Pin
Mycroft Holmes16-May-21 13:17
professionalMycroft Holmes16-May-21 13:17 
AnswerRe: Accounting problem in SQL Pin
CHill6019-May-21 3:55
mveCHill6019-May-21 3:55 
QuestionSQL Server Execution Timeout Expired Pin
idkd13-May-21 0:00
idkd13-May-21 0:00 
AnswerRe: SQL Server Execution Timeout Expired Pin
SeanChupas13-May-21 2:49
SeanChupas13-May-21 2:49 
QuestionIn-memory database with acid transactions and high availability Pin
Mathieu Seillier12-May-21 3:54
Mathieu Seillier12-May-21 3:54 
AnswerRe: In-memory database with acid transactions and high availability Pin
Mycroft Holmes12-May-21 14:00
professionalMycroft Holmes12-May-21 14:00 
AnswerRe: In-memory database with acid transactions and high availability Pin
Richard MacCutchan12-May-21 22:08
mveRichard MacCutchan12-May-21 22:08 
AnswerRe: In-memory database with acid transactions and high availability Pin
Meysam Toluie29-Jan-22 0:06
Meysam Toluie29-Jan-22 0:06 
GeneralRe: In-memory database with acid transactions and high availability Pin
OriginalGriff29-Jan-22 0:08
mveOriginalGriff29-Jan-22 0:08 
GeneralRe: In-memory database with acid transactions and high availability Pin
Meysam Toluie29-Jan-22 0:25
Meysam Toluie29-Jan-22 0:25 
QuestionSQL Server round trip issue between server and client pc Pin
Mou_kol1-May-21 7:35
Mou_kol1-May-21 7:35 
AnswerRe: SQL Server round trip issue between server and client pc Pin
Mycroft Holmes1-May-21 12:57
professionalMycroft Holmes1-May-21 12:57 
AnswerRe: SQL Server round trip issue between server and client pc Pin
Gerry Schmitz1-May-21 18:12
mveGerry Schmitz1-May-21 18:12 
GeneralRe: SQL Server round trip issue between server and client pc Pin
Mycroft Holmes2-May-21 13:24
professionalMycroft Holmes2-May-21 13:24 
GeneralRe: SQL Server round trip issue between server and client pc Pin
Gerry Schmitz2-May-21 19:53
mveGerry Schmitz2-May-21 19:53 
QuestionSqlServer (and ADO.NET) mystery... Pin
Super Lloyd27-Apr-21 20:19
Super Lloyd27-Apr-21 20:19 

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.