Click here to Skip to main content
15,394,799 members
Home / Discussions / Database
   

Database

 
QuestionORA-01722 Error Pin
Rane14-Oct-08 2:04
MemberRane14-Oct-08 2:04 
AnswerRe: ORA-01722 Error Pin
Wendelius14-Oct-08 5:22
mveWendelius14-Oct-08 5:22 
Questionhow to execute this oracle function ??? Pin
dilipmca0413-Oct-08 23:37
Memberdilipmca0413-Oct-08 23:37 
AnswerRe: how to execute this oracle function ??? Pin
Wendelius14-Oct-08 5:05
mveWendelius14-Oct-08 5:05 
QuestionDatabase design Questions? Pin
sepel13-Oct-08 23:23
Membersepel13-Oct-08 23:23 
AnswerRe: Database design Questions? Pin
bcozican14-Oct-08 2:09
Memberbcozican14-Oct-08 2:09 
GeneralRe: Database design Questions? Pin
Mark Churchill14-Oct-08 2:42
MemberMark Churchill14-Oct-08 2:42 
QuestionQuery Help Pin
Jaffer Mumtaz13-Oct-08 20:20
MemberJaffer Mumtaz13-Oct-08 20:20 
Hi,

I have the following query

SELECT iAccountID,iViolatorID,Count(iViolatorID) FROM tbTempQNotificationRequest (NOLOCK)
	WHERE IsProcessed = 0 AND sdtStatusDate >= @sdtCurrentDate AND sdtStatusDate < @sdtCurrentDate + 1
	GROUP BY iAccountID,vcGroupByValue,iViolatorID  


Is it possible say when I group by the result set return

iAccount|iViolatorID|Count
1-------|1----------|3
2-------|2----------|5

I would like to have a fourth column say AccountNo and I want that it should contain comma seperated values of AccountNo against the group by columns.e.g.

iAccount|iViolatorID|Count|AcccountNo
1-------|1----------|3----|X12,X23,X34
2-------|2----------|5----|X45,X56,X65,X32,X98

I hope my question is clear and understandable
AnswerRe: Query Help Pin
bcozican14-Oct-08 2:18
Memberbcozican14-Oct-08 2:18 
GeneralRe: Query Help Pin
Jaffer Mumtaz14-Oct-08 18:41
MemberJaffer Mumtaz14-Oct-08 18:41 
QuestionMultiple columns in LIKE Pin
N a v a n e e t h13-Oct-08 15:58
MemberN a v a n e e t h13-Oct-08 15:58 
AnswerRe: Multiple columns in LIKE Pin
Mycroft Holmes13-Oct-08 17:42
professionalMycroft Holmes13-Oct-08 17:42 
GeneralRe: Multiple columns in LIKE Pin
N a v a n e e t h13-Oct-08 19:23
MemberN a v a n e e t h13-Oct-08 19:23 
GeneralRe: Multiple columns in LIKE Pin
Andrew Rissing14-Oct-08 6:43
MemberAndrew Rissing14-Oct-08 6:43 
QuestionLoading column having $ sign to SQL Server... Pin
notes4we13-Oct-08 7:56
Membernotes4we13-Oct-08 7:56 
AnswerRe: Loading column having $ sign to SQL Server... Pin
Wendelius13-Oct-08 9:22
mveWendelius13-Oct-08 9:22 
QuestionArchiving a record Pin
Bolivarian13-Oct-08 7:07
MemberBolivarian13-Oct-08 7:07 
AnswerRe: Archiving a record Pin
Wendelius13-Oct-08 9:25
mveWendelius13-Oct-08 9:25 
GeneralRe: Archiving a record Pin
Bolivarian14-Oct-08 0:12
MemberBolivarian14-Oct-08 0:12 
GeneralRe: Archiving a record Pin
Wendelius14-Oct-08 4:54
mveWendelius14-Oct-08 4:54 
QuestionLEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
polishprogrammer13-Oct-08 7:05
Memberpolishprogrammer13-Oct-08 7:05 
AnswerRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
Wendelius13-Oct-08 7:36
mveWendelius13-Oct-08 7:36 
GeneralRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
polishprogrammer13-Oct-08 11:01
Memberpolishprogrammer13-Oct-08 11:01 
GeneralRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
Wendelius13-Oct-08 18:12
mveWendelius13-Oct-08 18:12 
GeneralRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
polishprogrammer14-Oct-08 3:38
Memberpolishprogrammer14-Oct-08 3:38 

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.