Click here to Skip to main content
15,885,767 members
Home / Discussions / Database
   

Database

 
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 
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 
Hi,

It had takem me a while but I figured that out. Thanks a lot for replying. I have a more complex one for you. I am really no good with SQL and unfortunately I have to work with it on this one Frown | :(

Consider the following table again:

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
8 101 2 0
9 103 1 1
10 103 3 1

Now, I have to get all TESTNUMBER which have different sets of State and Values. So, this table will return 2 sets...

Set 1:

1 0
1 1
2 0
2 1
(Since, 100 and 101 share a common set)

Set 2:
1 1
3 1
(102 does have an identical set as 100 and 101. Common items are allowed but the sets must be identical (same elements))

Any suggestions on how to achieve this?

Thanks a lot,
Pankaj


Without struggle, there is no progress
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 
GeneralMigrate SQL to Oracle Pin
TPN10-Nov-03 16:40
TPN10-Nov-03 16:40 
GeneralRe: Migrate SQL to Oracle Pin
Guillermo Rivero12-Nov-03 7:31
Guillermo Rivero12-Nov-03 7:31 
GeneralRe: Migrate SQL to Oracle Pin
Mike Dimmick13-Nov-03 2:54
Mike Dimmick13-Nov-03 2:54 

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.