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

Database

 
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 
GeneralRe: Pivot works, but spread column values not as expected Pin
#realJSOP19-Jun-22 22:20
mva#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
mva#realJSOP19-Jun-22 23:19 
They both worked great, but I went with the non-pivot version. Thanks, man.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

QuestionDatabase design for a project Pin
Gopika Ravikumar16-Jun-22 6:35
MemberGopika Ravikumar16-Jun-22 6:35 
AnswerRe: Database design for a project Pin
Craig Robbins16-Jun-22 7:31
MemberCraig Robbins16-Jun-22 7:31 
AnswerRe: Database design for a project Pin
Mycroft Holmes16-Jun-22 12:44
professionalMycroft Holmes16-Jun-22 12:44 
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
MemberLuis 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
Memberjschell8-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
MemberJame_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
MemberCraig 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
MemberDavid Mujica12-Apr-22 11:12 
AnswerRe: Best practice for creating a limited access ms-sql user ? Pin
jschell8-May-22 8:11
Memberjschell8-May-22 8:11 
QuestionMysql How to sort row ORDER BY another query? Pin
Zac Ang3-Apr-22 10:45
MemberZac Ang3-Apr-22 10:45 
SuggestionRe: Mysql How to sort row ORDER BY another query? Pin
Richard Deeming3-Apr-22 21:46
mveRichard Deeming3-Apr-22 21:46 
AnswerRe: Mysql How to sort row ORDER BY another query? Pin
CHill606-Apr-22 2:57
mveCHill606-Apr-22 2:57 

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.