Click here to Skip to main content
11,703,632 members (66,768 online)


GeneralRe: Fault Exception in WCF Services Pin
Phanindra26114-Nov-12 8:05
memberPhanindra26114-Nov-12 8:05 
QuestionRelation multiple table using in C# Pin
YBG13-Nov-12 2:53
memberYBG13-Nov-12 2:53 
AnswerRe: Relation multiple table using in C# Pin
Phanindra26114-Nov-12 8:23
memberPhanindra26114-Nov-12 8:23 
QuestionTrying to get a MySQL subquery to return multiple records Pin
SQL Ed12-Nov-12 8:19
memberSQL Ed12-Nov-12 8:19 
The following subquery returns 1024 records with a single count column. I am trying to return multiple columns with 1024 records. When I make changes to return multiple columns I get 17,000 records instead of 1024 records. I have very litle experience with subqueries. Does anyone have any suggestions?

SELECT IFNULL(COUNT(DISTINCT A.computerid),0) AS 'Machine Count',
A.hotfixID AS 'Last Contact'
FROM (SELECT HF.computerid, HF.hotfixID
FROM hotfixdata HFD

ON HF.hotfixid = HFD.hotfixid
AND HFD.ignore <> 1
ON C.ComputerID=HF.ComputerID

WHERE INSTR(C.os,"microsoft")>0
AND HF.installed <> 1
AND HF.Approved = 1
GROUP BY HF.hotfixID, HF.ComputerID) A;
AnswerRe: Trying to get a MySQL subquery to return multiple records Pin
Eddy Vluggen12-Nov-12 11:33
memberEddy Vluggen12-Nov-12 11:33 
QuestionSending data to database Pin
Phanindra26111-Nov-12 19:03
memberPhanindra26111-Nov-12 19:03 
AnswerRe: Sending data to database Pin
jschell12-Nov-12 10:08
memberjschell12-Nov-12 10:08 
AnswerRe: Sending data to database Pin
Mycroft Holmes12-Nov-12 12:51
memberMycroft Holmes12-Nov-12 12:51 
GeneralRe: Sending data to database Pin
Phanindra26113-Nov-12 18:40
memberPhanindra26113-Nov-12 18:40 
QuestionHow to create reports effectively Pin
Frygreen9-Nov-12 0:52
memberFrygreen9-Nov-12 0:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 26 Aug 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid