Click here to Skip to main content
15,567,221 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to remove a 1000 seperator from a number Pin
Mycroft Holmes14-Apr-15 15:15
professionalMycroft Holmes14-Apr-15 15:15 
Questionhow to write xml code to manually create pdf without using third party in oracle apex Pin
Member 1159668313-Apr-15 20:28
Member 1159668313-Apr-15 20:28 
QuestionVB.NET MYSQL loop through records while adding Pin
Pauls Pauls13-Apr-15 10:40
Pauls Pauls13-Apr-15 10:40 
QuestionRe: VB.NET MYSQL loop through records while adding Pin
ZurdoDev13-Apr-15 11:09
professionalZurdoDev13-Apr-15 11:09 
AnswerRe: VB.NET MYSQL loop through records while adding Pin
Pauls Pauls13-Apr-15 11:48
Pauls Pauls13-Apr-15 11:48 
AnswerRe: VB.NET MYSQL loop through records while adding Pin
Mycroft Holmes13-Apr-15 15:21
professionalMycroft Holmes13-Apr-15 15:21 
GeneralRe: VB.NET MYSQL loop through records while adding Pin
Pauls Pauls13-Apr-15 21:09
Pauls Pauls13-Apr-15 21:09 
GeneralRe: VB.NET MYSQL loop through records while adding Pin
Mycroft Holmes13-Apr-15 21:39
professionalMycroft Holmes13-Apr-15 21:39 
Ah my bad, I missed the add. You may need a nested select. First build your query to get the records you need and then wrap that in an aggregate query
SQL
select GroupID, sum(marks) 
from(select GroupID, marks 
From Table
Where Group = 'some code') X
group by GroupID

The query X gets the records you need and the outer query aggregates those records.
Never underestimate the power of human stupidity
RAH

GeneralRe: VB.NET MYSQL loop through records while adding Pin
Pauls Pauls14-Apr-15 2:47
Pauls Pauls14-Apr-15 2:47 
QuestionPICTUREBOX IMAGE IN VB.NET Pin
Pauls Pauls13-Apr-15 1:18
Pauls Pauls13-Apr-15 1:18 
AnswerRe: PICTUREBOX IMAGE IN VB.NET Pin
Corporal Agarn13-Apr-15 1:35
professionalCorporal Agarn13-Apr-15 1:35 
QuestionSystem.Data.SqlClient.SqlException: Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied. Pin
indian1437-Apr-15 16:22
indian1437-Apr-15 16:22 
AnswerRe: System.Data.SqlClient.SqlException: Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied. Pin
Sascha Lefèvre7-Apr-15 17:42
professionalSascha Lefèvre7-Apr-15 17:42 
GeneralRe: System.Data.SqlClient.SqlException: Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied. Pin
indian1437-Apr-15 20:59
indian1437-Apr-15 20:59 
GeneralRe: System.Data.SqlClient.SqlException: Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied. Pin
Sascha Lefèvre7-Apr-15 21:54
professionalSascha Lefèvre7-Apr-15 21:54 
QuestionA data source instance has not been supplied for the data source Pin
indian1436-Apr-15 13:55
indian1436-Apr-15 13:55 
QuestionHow Do I Insert Only Recently Updated Row From Table1 To 2 in MySQL Pin
RevathySanthanam2-Apr-15 5:10
RevathySanthanam2-Apr-15 5:10 
Rant[REPOST] How Do I Insert Only Recently Updated Row From Table1 To 2 in MySQL Pin
Richard Deeming2-Apr-15 5:41
mveRichard Deeming2-Apr-15 5:41 
Questionmultiple joins, works in sql manager but not in asp.net Pin
jkirkerx1-Apr-15 13:47
professionaljkirkerx1-Apr-15 13:47 
Answer[solved] Pin
jkirkerx1-Apr-15 14:02
professionaljkirkerx1-Apr-15 14:02 
SuggestionRe: multiple joins, works in sql manager but not in asp.net Pin
Richard Deeming2-Apr-15 3:30
mveRichard Deeming2-Apr-15 3:30 
GeneralRe: multiple joins, works in sql manager but not in asp.net Pin
jkirkerx2-Apr-15 13:09
professionaljkirkerx2-Apr-15 13:09 
Questionimage in database Pin
vinay dahiya1-Apr-15 12:40
vinay dahiya1-Apr-15 12:40 
GeneralRe: image in database Pin
PIEBALDconsult1-Apr-15 13:08
professionalPIEBALDconsult1-Apr-15 13:08 
GeneralRe: image in database Pin
vinay dahiya1-Apr-15 13:15
vinay dahiya1-Apr-15 13:15 

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.