Click here to Skip to main content
15,507,755 members
Home / Discussions / Database
   

Database

 
AnswerRe: How would you... (synchronization between 2 databases) Pin
Mycroft Holmes6-Aug-22 13:48
professionalMycroft Holmes6-Aug-22 13:48 
Questionsql query problem Pin
pitwi28-Jul-22 0:06
pitwi28-Jul-22 0:06 
AnswerRe: sql query problem Pin
Richard Deeming28-Jul-22 0:54
mveRichard Deeming28-Jul-22 0:54 
GeneralRe: sql query problem Pin
jsc4217-Aug-22 7:20
professionaljsc4217-Aug-22 7:20 
GeneralRe: sql query problem Pin
Richard Deeming17-Aug-22 7:26
mveRichard Deeming17-Aug-22 7:26 
The problem is that the OP wants to extract the first record for each unique 8-character prefix, whereas your code will return all records for each prefix. Smile | :)

For example, given the input data:
| Nbr          | Ort |
|--------------|-----|
| 20220717-001 | A   |
| 20220717-002 | B   |
| 20220717-003 | C   |
Your code would return all three, whereas the OP only wants the first one.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: sql query problem Pin
jsc4217-Aug-22 23:40
professionaljsc4217-Aug-22 23:40 
Question.sql script in c# Pin
Member 1373522830-Jun-22 3:15
Member 1373522830-Jun-22 3:15 
AnswerRe: .sql script in c# Pin
Dave Kreskowiak30-Jun-22 4:59
mveDave Kreskowiak30-Jun-22 4:59 
QuestionPivot works, but spread column values not as expected Pin
#realJSOP19-Jun-22 2:58
mva#realJSOP19-Jun-22 2:58 
AnswerRe: Pivot works, but spread column values not as expected Pin
Richard Deeming19-Jun-22 22:52
mveRichard Deeming19-Jun-22 22:52 
GeneralRe: Pivot works, but spread column values not as expected Pin
#realJSOP19-Jun-22 23:20
mva#realJSOP19-Jun-22 23:20 
GeneralRe: Pivot works, but spread column values not as expected Pin
Richard Deeming19-Jun-22 23:36
mveRichard Deeming19-Jun-22 23:36 
GeneralRe: Pivot works, but spread column values not as expected Pin
#realJSOP20-Jun-22 0:19
mva#realJSOP20-Jun-22 0:19 
QuestionDatabase design for a project Pin
Gopika Ravikumar16-Jun-22 7:35
Gopika Ravikumar16-Jun-22 7:35 
AnswerRe: Database design for a project Pin
Craig Robbins16-Jun-22 8:31
Craig Robbins16-Jun-22 8:31 
AnswerRe: Database design for a project Pin
Mycroft Holmes16-Jun-22 13:44
professionalMycroft Holmes16-Jun-22 13:44 
AnswerRe: Database design for a project Pin
Gopika Ravikumar30-Oct-22 5:38
Gopika Ravikumar30-Oct-22 5:38 
QuestionHow to get this result in oracle database? Pin
HowardCheng22-May-22 5:58
professionalHowardCheng22-May-22 5:58 
AnswerRe: How to get this result in oracle database? Pin
Mycroft Holmes22-May-22 14:18
professionalMycroft Holmes22-May-22 14:18 
QuestionSQL SERVER STORE PROCEDURE Pin
Luis M. Rojas28-Apr-22 4:45
Luis M. Rojas28-Apr-22 4:45 
AnswerRe: SQL SERVER STORE PROCEDURE Pin
Richard Deeming28-Apr-22 5:34
mveRichard Deeming28-Apr-22 5:34 
AnswerRe: SQL SERVER STORE PROCEDURE Pin
Mycroft Holmes28-Apr-22 12:59
professionalMycroft Holmes28-Apr-22 12:59 
GeneralRe: SQL SERVER STORE PROCEDURE Pin
jschell8-May-22 9:07
jschell8-May-22 9:07 
QuestionGiven two dates, count the number of dates in the range that is within month X Pin
Jame_T13-Apr-22 4:43
Jame_T13-Apr-22 4:43 
AnswerRe: Given two dates, count the number of dates in the range that is within month X Pin
Craig Robbins13-Apr-22 5:10
Craig Robbins13-Apr-22 5:10 

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.