Click here to Skip to main content
       

Database

 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 18:50 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 18:55 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 19:28 
GeneralRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 19:43 
GeneralRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 19:51 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201128-Feb-13 2:41 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes28-Feb-13 11:34 
Questionsql server 2008 query, Pinmembergavindon27-Feb-13 15:57 
Ok here is my issue. I know how to do a count, count distinct and all that.
I have a column in my table that has 3 different values(only three, never more), so every row that is entered with have one of those three values.
The values are,
Bundle
Bowed Board
Jam
 

 
I am trying to figure out how to write a query that will count how many times of EACH value there is in the table. ie... 55 bundles... 10 bowed boards.... 5 jams...
 
for some reason I just cant get this one in my head. any help to be had? I do need it to be a single query as it is going in a dataset for a SSRS report Matrix.
Treat stressful situations like a dog, if you can't eat it, play with it or screw it, then just piss on it and walk away.
 
Be careful which toes you step on today, they might be connected to the foot that kicks your butt tomorrow.

AnswerRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 16:11 
GeneralRe: sql server 2008 query, Pinmembergavindon27-Feb-13 17:14 
GeneralRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 17:34 
AnswerRe: sql server 2008 query, PinmemberMycroft Holmes27-Feb-13 18:45 
GeneralRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 18:53 
GeneralRe: sql server 2008 query, PinmemberMycroft Holmes27-Feb-13 19:26 
AnswerRe: sql server 2008 query, Pinmembergvprabu28-Feb-13 21:28 
QuestionSQL Server 2012 annoyance... Pinmember_Damian S_27-Feb-13 15:21 
AnswerRe: SQL Server 2012 annoyance... Pinmember_Damian S_27-Feb-13 19:27 
GeneralRe: SQL Server 2012 annoyance... PinmemberMycroft Holmes27-Feb-13 19:57 
GeneralRe: SQL Server 2012 annoyance... Pinmember_Damian S_27-Feb-13 20:06 
GeneralRe: SQL Server 2012 annoyance... PinmemberMycroft Holmes27-Feb-13 20:47 
QuestionWhat order to be followed while generating schema upgrade script? PinmemberMember 313707826-Feb-13 18:10 
AnswerRe: What order to be followed while generating schema upgrade script? PinmemberMycroft Holmes27-Feb-13 20:01 
GeneralRe: What order to be followed while generating schema upgrade script? PinmemberMember 313707827-Feb-13 21:40 
GeneralRe: What order to be followed while generating schema upgrade script? PinmemberMycroft Holmes27-Feb-13 22:15 
QuestionSQL weirdness when aliasing columns PinmemberGregory.Gadow22-Feb-13 11:19 

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
Web01 | 2.8.140916.1 | Last Updated 17 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid