Click here to Skip to main content
15,867,308 members
Home / Discussions / Database
   

Database

 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik17-Aug-22 19:46
Nick Katditsik17-Aug-22 19:46 
QuestionHow would you... (synchronization between 2 databases) Pin
Joan M6-Aug-22 7:18
professionalJoan M6-Aug-22 7:18 
AnswerRe: How would you... (synchronization between 2 databases) Pin
Gerry Schmitz6-Aug-22 8:06
mveGerry Schmitz6-Aug-22 8:06 
GeneralRe: How would you... (synchronization between 2 databases) Pin
Joan M6-Aug-22 12:08
professionalJoan M6-Aug-22 12:08 
AnswerRe: How would you... (synchronization between 2 databases) Pin
Mycroft Holmes6-Aug-22 12:48
professionalMycroft Holmes6-Aug-22 12:48 
Questionsql query problem Pin
pitwi27-Jul-22 23:06
pitwi27-Jul-22 23:06 
AnswerRe: sql query problem Pin
Richard Deeming27-Jul-22 23:54
mveRichard Deeming27-Jul-22 23:54 
GeneralRe: sql query problem Pin
jsc4217-Aug-22 6:20
professionaljsc4217-Aug-22 6:20 
Do you really need something as complex as a CTE? Couldn't you simply do the following (off the top of my head, not tested; so caveat emptor):
SQL
SELECT TOP (100) PERCENT
   Nbr,
   Ort
FROM
   Fotos
WHERE
   Type = 'D'
ORDER BY
   SUBSTRING(Nbr, 1, 8) DESC,
   Ort

GeneralRe: sql query problem Pin
Richard Deeming17-Aug-22 6:26
mveRichard Deeming17-Aug-22 6:26 
GeneralRe: sql query problem Pin
jsc4217-Aug-22 22:40
professionaljsc4217-Aug-22 22:40 
Question.sql script in c# Pin
Member 1373522830-Jun-22 2:15
Member 1373522830-Jun-22 2:15 
AnswerRe: .sql script in c# Pin
Dave Kreskowiak30-Jun-22 3:59
mveDave Kreskowiak30-Jun-22 3:59 
QuestionPivot works, but spread column values not as expected Pin
#realJSOP19-Jun-22 1:58
mve#realJSOP19-Jun-22 1:58 
AnswerRe: Pivot works, but spread column values not as expected Pin
Richard Deeming19-Jun-22 21:52
mveRichard Deeming19-Jun-22 21:52 
GeneralRe: Pivot works, but spread column values not as expected Pin
#realJSOP19-Jun-22 22:20
mve#realJSOP19-Jun-22 22:20 
GeneralRe: Pivot works, but spread column values not as expected Pin
Richard Deeming19-Jun-22 22:36
mveRichard Deeming19-Jun-22 22:36 
GeneralRe: Pivot works, but spread column values not as expected Pin
#realJSOP19-Jun-22 23:19
mve#realJSOP19-Jun-22 23:19 
QuestionDatabase design for a project Pin
Gopika Ravikumar16-Jun-22 6:35
Gopika Ravikumar16-Jun-22 6:35 
AnswerRe: Database design for a project Pin
Craig Robbins16-Jun-22 7:31
Craig Robbins16-Jun-22 7:31 
AnswerRe: Database design for a project Pin
Mycroft Holmes16-Jun-22 12:44
professionalMycroft Holmes16-Jun-22 12:44 
AnswerRe: Database design for a project Pin
Gopika Ravikumar30-Oct-22 4:38
Gopika Ravikumar30-Oct-22 4:38 
QuestionHow to get this result in oracle database? Pin
HowardCheng22-May-22 4:58
professionalHowardCheng22-May-22 4:58 
AnswerRe: How to get this result in oracle database? Pin
Mycroft Holmes22-May-22 13:18
professionalMycroft Holmes22-May-22 13:18 
QuestionSQL SERVER STORE PROCEDURE Pin
Luis M. Rojas28-Apr-22 3:45
Luis M. Rojas28-Apr-22 3:45 
AnswerRe: SQL SERVER STORE PROCEDURE Pin
Richard Deeming28-Apr-22 4:34
mveRichard Deeming28-Apr-22 4:34 

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.