Click here to Skip to main content
15,881,588 members
Home / Discussions / Database
   

Database

 
GeneralRe: ADO and DAO Pin
Tom Archer14-Nov-03 17:02
Tom Archer14-Nov-03 17:02 
GeneralIs Oracle really so much faster than MS Sql Pin
CillyMe11-Nov-03 22:21
CillyMe11-Nov-03 22:21 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
Mike Dimmick11-Nov-03 23:49
Mike Dimmick11-Nov-03 23:49 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
CillyMe12-Nov-03 3:09
CillyMe12-Nov-03 3:09 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
Bill Priess12-Nov-03 8:36
Bill Priess12-Nov-03 8:36 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
Matt Gullett12-Nov-03 17:15
Matt Gullett12-Nov-03 17:15 
GeneralSql help Pin
pankajdaga11-Nov-03 11:57
pankajdaga11-Nov-03 11:57 
GeneralRe: Sql help Pin
Edbert P11-Nov-03 18:23
Edbert P11-Nov-03 18:23 
Try this:

SELECT COUNT(*), state, value
FROM table
GROUP BY state, value

The statement above will group your result based on state and value, e.g.
Count State Value
2 1 0
2 1 1
2 2 1
1 2 0

If you need to add a condition, add HAVING state = 1 AND value = 0 (for example).
GeneralRe: Sql help Pin
pankajdaga11-Nov-03 20:35
pankajdaga11-Nov-03 20:35 
GeneralRe: Sql help Pin
jeff_martin12-Nov-03 7:44
jeff_martin12-Nov-03 7:44 
GeneralRe: Sql help Pin
pankajdaga12-Nov-03 21:42
pankajdaga12-Nov-03 21:42 
GeneralRe: Sql help Pin
jeff_martin13-Nov-03 3:36
jeff_martin13-Nov-03 3:36 
GeneralRe: Sql help Pin
pankajdaga13-Nov-03 10:15
pankajdaga13-Nov-03 10:15 
Generalaccess permissions Pin
ranjjj11-Nov-03 3:57
ranjjj11-Nov-03 3:57 
GeneralRe: access permissions Pin
ranjjj11-Nov-03 4:04
ranjjj11-Nov-03 4:04 
GeneralRe: access permissions Pin
Jeff Varszegi11-Nov-03 4:41
professionalJeff Varszegi11-Nov-03 4:41 
Generalextended procedure for sql server Pin
mhmoud rawas11-Nov-03 1:21
mhmoud rawas11-Nov-03 1:21 
GeneralRe: extended procedure for sql server Pin
Mike Dimmick11-Nov-03 10:08
Mike Dimmick11-Nov-03 10:08 
GeneralRe: extended procedure for sql server Pin
mhmoud rawas11-Nov-03 18:21
mhmoud rawas11-Nov-03 18:21 
GeneralRe: extended procedure for sql server Pin
Mike Dimmick11-Nov-03 23:02
Mike Dimmick11-Nov-03 23:02 
GeneralRe: extended procedure for sql server Pin
mhmoud rawas11-Nov-03 23:16
mhmoud rawas11-Nov-03 23:16 
GeneralMore DTS questions Pin
Megan Forbes10-Nov-03 23:49
Megan Forbes10-Nov-03 23:49 
QuestionDataGrid - stopping additions, while allowing edits: possible? Pin
Pauwll10-Nov-03 23:46
Pauwll10-Nov-03 23:46 
AnswerRe: DataGrid - stopping additions, while allowing edits: possible? Pin
Mike Dimmick11-Nov-03 10:13
Mike Dimmick11-Nov-03 10:13 
GeneralRe: DataGrid - stopping additions, while allowing edits: possible? Pin
Pauwll11-Nov-03 17:56
Pauwll11-Nov-03 17:56 

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.