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

Database

 
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 
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 
#realJSOP wrote:
Currently, all VehImage columns are null (intentionally).
...
SQL
FOR VehImage IN (...)
If all of the VehImage values are Null, they won't match the IN filter.

And it seems odd to be pivoting on the same column you're aggregating.

What are you actually trying to do?



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

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 
AnswerRe: SQL SERVER STORE PROCEDURE Pin
Mycroft Holmes28-Apr-22 11:59
professionalMycroft Holmes28-Apr-22 11:59 
GeneralRe: SQL SERVER STORE PROCEDURE Pin
jschell8-May-22 8:07
jschell8-May-22 8:07 
QuestionGiven two dates, count the number of dates in the range that is within month X Pin
Jame_T13-Apr-22 3:43
Jame_T13-Apr-22 3:43 
AnswerRe: Given two dates, count the number of dates in the range that is within month X Pin
Craig Robbins13-Apr-22 4:10
Craig Robbins13-Apr-22 4:10 
AnswerRe: Given two dates, count the number of dates in the range that is within month X Pin
CHill6020-Apr-22 7:04
mveCHill6020-Apr-22 7:04 
QuestionBest practice for creating a limited access ms-sql user ? Pin
David Mujica12-Apr-22 11:12
David Mujica12-Apr-22 11:12 

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.