Click here to Skip to main content
15,399,788 members
Home / Discussions / Database
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 3:10
cofounderChris Maunder16-Jul-09 3:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 16:30
cofounderChris Maunder10-Nov-05 16:30 
QuestionOLE DB provider Pin
suren ramakrishnan1 hr 50mins ago
Membersuren ramakrishnan1 hr 50mins ago 
AnswerRe: OLE DB provider Pin
Richard MacCutchan1 hr 35mins ago
mveRichard MacCutchan1 hr 35mins ago 
QuestionReplacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik7-Aug-22 4:00
MemberNick Katditsik7-Aug-22 4:00 
AnswerRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Mycroft Holmes7-Aug-22 12:44
professionalMycroft Holmes7-Aug-22 12:44 
GeneralRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik8-Aug-22 5:42
MemberNick Katditsik8-Aug-22 5:42 
AnswerRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Richard Deeming7-Aug-22 21:50
mveRichard Deeming7-Aug-22 21:50 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik17-Aug-22 5:07
MemberNick Katditsik17-Aug-22 5:07 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Craig Robbins17-Aug-22 6:53
MemberCraig Robbins17-Aug-22 6:53 
AnswerRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
CHill6017-Aug-22 7:00
mveCHill6017-Aug-22 7:00 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik17-Aug-22 19:46
MemberNick 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
Memberpitwi27-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 
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
MemberMember 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
mva#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

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.