Click here to Skip to main content
13,048,584 members (81,084 online)
   

Database

 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 19:05
member_Damian S_27-Feb-13 19:05 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 19:08
memberjojoba201127-Feb-13 19:08 
AnswerRe: sql server table records to sqlite Pin
_Damian S_27-Feb-13 19:15
member_Damian S_27-Feb-13 19:15 
QuestionRe: sql server table records to sqlite Pin
jojoba201128-Feb-13 2:40
memberjojoba201128-Feb-13 2:40 
AnswerRe: sql server table records to sqlite Pin
Eddy Vluggen28-Feb-13 9:25
mvpEddy Vluggen28-Feb-13 9:25 
QuestionRe: sql server table records to sqlite Pin
jojoba20111-Mar-13 20:23
memberjojoba20111-Mar-13 20:23 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 18:50
memberMycroft Holmes27-Feb-13 18:50 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 18:55
memberjojoba201127-Feb-13 18:55 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 19:28
memberMycroft Holmes27-Feb-13 19:28 
GeneralRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 19:43
memberjojoba201127-Feb-13 19:43 
GeneralRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 19:51
memberMycroft Holmes27-Feb-13 19:51 
QuestionRe: sql server table records to sqlite Pin
jojoba201128-Feb-13 2:41
memberjojoba201128-Feb-13 2:41 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes28-Feb-13 11:34
memberMycroft Holmes28-Feb-13 11:34 
Questionsql server 2008 query, Pin
gavindon27-Feb-13 15:57
membergavindon27-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, Pin
_Damian S_27-Feb-13 16:11
member_Damian S_27-Feb-13 16:11 
GeneralRe: sql server 2008 query, Pin
gavindon27-Feb-13 17:14
membergavindon27-Feb-13 17:14 
GeneralRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 17:34
member_Damian S_27-Feb-13 17:34 
AnswerRe: sql server 2008 query, Pin
Mycroft Holmes27-Feb-13 18:45
memberMycroft Holmes27-Feb-13 18:45 
GeneralRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 18:53
member_Damian S_27-Feb-13 18:53 
GeneralRe: sql server 2008 query, Pin
Mycroft Holmes27-Feb-13 19:26
memberMycroft Holmes27-Feb-13 19:26 
AnswerRe: sql server 2008 query, Pin
gvprabu28-Feb-13 21:28
membergvprabu28-Feb-13 21:28 
QuestionSQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 15:21
member_Damian S_27-Feb-13 15:21 
AnswerRe: SQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 19:27
member_Damian S_27-Feb-13 19:27 
GeneralRe: SQL Server 2012 annoyance... Pin
Mycroft Holmes27-Feb-13 19:57
memberMycroft Holmes27-Feb-13 19:57 
GeneralRe: SQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 20:06
member_Damian S_27-Feb-13 20:06 
GeneralRe: SQL Server 2012 annoyance... Pin
Mycroft Holmes27-Feb-13 20:47
memberMycroft Holmes27-Feb-13 20:47 
QuestionWhat order to be followed while generating schema upgrade script? Pin
Member 313707826-Feb-13 18:10
memberMember 313707826-Feb-13 18:10 
AnswerRe: What order to be followed while generating schema upgrade script? Pin
Mycroft Holmes27-Feb-13 20:01
memberMycroft Holmes27-Feb-13 20:01 
GeneralRe: What order to be followed while generating schema upgrade script? Pin
Member 313707827-Feb-13 21:40
memberMember 313707827-Feb-13 21:40 
GeneralRe: What order to be followed while generating schema upgrade script? Pin
Mycroft Holmes27-Feb-13 22:15
memberMycroft Holmes27-Feb-13 22:15 
QuestionSQL weirdness when aliasing columns Pin
Gregory.Gadow22-Feb-13 11:19
memberGregory.Gadow22-Feb-13 11:19 
AnswerRe: SQL weirdness when aliasing columns Pin
gvprabu22-Feb-13 18:18
membergvprabu22-Feb-13 18:18 
AnswerRe: SQL weirdness when aliasing columns Pin
Mycroft Holmes24-Feb-13 13:08
memberMycroft Holmes24-Feb-13 13:08 
GeneralRe: SQL weirdness when aliasing columns Pin
Gregory.Gadow28-Feb-13 9:09
memberGregory.Gadow28-Feb-13 9:09 
GeneralRe: SQL weirdness when aliasing columns Pin
Mycroft Holmes28-Feb-13 12:04
memberMycroft Holmes28-Feb-13 12:04 
GeneralRe: SQL weirdness when aliasing columns Pin
Gregory.Gadow1-Mar-13 5:10
memberGregory.Gadow1-Mar-13 5:10 
AnswerSolution Pin
Gregory.Gadow1-Mar-13 9:28
memberGregory.Gadow1-Mar-13 9:28 
GeneralRe: Solution Pin
Mycroft Holmes1-Mar-13 11:53
memberMycroft Holmes1-Mar-13 11:53 
QuestionDatabase Pin
Member 961179522-Feb-13 8:52
memberMember 961179522-Feb-13 8:52 
AnswerRe: Database Pin
jschell22-Feb-13 9:30
memberjschell22-Feb-13 9:30 
AnswerRe: Database Pin
mark merrens22-Feb-13 10:38
membermark merrens22-Feb-13 10:38 
GeneralRe: Database Pin
Member 961179523-Feb-13 1:05
memberMember 961179523-Feb-13 1:05 
GeneralRe: Database Pin
S Douglas28-Feb-13 7:58
memberS Douglas28-Feb-13 7:58 
AnswerRe: Database Pin
Jörgen Andersson22-Feb-13 11:11
memberJörgen Andersson22-Feb-13 11:11 
AnswerRe: Database Pin
PIEBALDconsult22-Feb-13 13:38
memberPIEBALDconsult22-Feb-13 13:38 
QuestionSQL Server + Procedure or function has too many arguments specified Pin
Hemant Thaker21-Feb-13 18:53
memberHemant Thaker21-Feb-13 18:53 
AnswerRe: SQL Server + Procedure or function has too many arguments specified Pin
Sandeep Mewara21-Feb-13 19:00
mvpSandeep Mewara21-Feb-13 19:00 
AnswerRe: SQL Server + Procedure or function has too many arguments specified Pin
Mycroft Holmes21-Feb-13 20:29
memberMycroft Holmes21-Feb-13 20:29 
AnswerRe: Resolved --> SQL Server + Procedure or function has too many arguments specified Pin
Hemant Thaker21-Feb-13 22:11
memberHemant Thaker21-Feb-13 22:11 
QuestionDual Primary Key? Pin
Richard.Berry10021-Feb-13 6:25
memberRichard.Berry10021-Feb-13 6:25 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 24 Jul 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid