Click here to Skip to main content
15,883,416 members
Home / Discussions / Database
   

Database

 
GeneralRe: ADO and DAO Pin
Hesham Amin12-Nov-03 7:00
Hesham Amin12-Nov-03 7:00 
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 
Hi everyone,

I have not been in touch with SQL for a long time. I had to start using it again since a few weeks and it has been quite a struggle.

I have a question and I would be really grateful if someone can help me with it. Consider the following table structure:

ID TESTNUMBER STATE VALUE
1 100 1 0
2 100 1 1
3 100 2 1
4 100 2 0
5 101 1 1
6 101 1 0
7 101 2 1

Now, what I want to do is get the DISTINCZ count of TESTNUMBER, say where (State = 1, Value = 0) and (State = 2, Value = 1). So basically this should give me a count of 2 because TestNumber 100 has an entry for (State = 1, Value = 0) and (State = 2, Value = 1). Also, entry 101 has (State = 1, Value = 0) and (State = 2, Value = 1) entries. However, I am unable to write this using a query. Please help!

Thanks,
Sincerely,
Pankaj



Without struggle, there is no progress
GeneralRe: Sql help Pin
Edbert P11-Nov-03 18:23
Edbert P11-Nov-03 18:23 
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 

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.