Click here to Skip to main content
15,438,321 members
Home / Discussions / Database
   

Database

 
AnswerRe: Chinese antique furniture Pin
Colin Angus Mackay16-Oct-05 0:10
MemberColin Angus Mackay16-Oct-05 0:10 
AnswerRe: Chinese antique furniture Pin
Christian Graus16-Oct-05 12:57
mveChristian Graus16-Oct-05 12:57 
QuestionApply UNIQUE using Visual Studio.Net Pin
Aayush Puri15-Oct-05 5:05
MemberAayush Puri15-Oct-05 5:05 
Questionchecking database Pin
abhinish15-Oct-05 1:11
Memberabhinish15-Oct-05 1:11 
AnswerRe: checking database Pin
Colin Angus Mackay15-Oct-05 2:07
MemberColin Angus Mackay15-Oct-05 2:07 
GeneralRe: checking database Pin
abhinish16-Oct-05 0:01
Memberabhinish16-Oct-05 0:01 
Questionado vc++ - datetime string or numbers to variant Pin
compoundeye14-Oct-05 20:55
Membercompoundeye14-Oct-05 20:55 
Questioncomplex query Pin
Joshua Lunsford14-Oct-05 12:02
MemberJoshua Lunsford14-Oct-05 12:02 
I need to pull a FIELD value from multiple records from the same table based off of like fields from the records and I dont know how to construct such a query. Here is some sample data:
<br />
71N7R61	GX280	APL	VER	1	8.0.0<br />
71N7R61	GX280	APL	VDF	1	4417<br />
71N7R61	GX280	APL	DRL	1	10/13/2005<br />
71N7R61	GX280	APL	ACT	1	VirusScan Running<br />
71N7R61	GX280	APL	DIN	1	05/05/2005<br />
71N7R61	GX280	APL	NMM	1	Network Associates<br />
71N7R61	GX280	APL	NMP	1	McAfee VirusScan Enterprise<br />
71N7R61	GX280	APL	NMP	2	MarimbaEndPoint<br />
71N7R61	GX280	APL	NMM	2	Marimba Inc.<br />
71N7R61	GX280	APL	DIN	2	04/01/2004<br />
71N7R61	GX280	APL	ACT	2	Marimba Running<br />
71N7R61	GX280	APL	VER	2	6.0<br />

the first 2 fields doesn't matter... primary keys. Third is a component code field, fourth field is a code tells me what the data in the 6th field means, 5th field is the is a sequence number... so in the sample VirusScan is '1' in the sequence of 'apl' applications and marimba is '2'...

now... what i would really like... is a query that would spit out this:
McAfee VirusScan Enterprise	VER	1	8.0.0<br />
McAfee VirusScan Enterprise	VDF	1	4417<br />
McAfee VirusScan Enterprise	DRL	1	10/13/2005<br />
McAfee VirusScan Enterprise	ACT	1	VirusScan Running<br />
McAfee VirusScan Enterprise	DIN	1	05/05/2005<br />
McAfee VirusScan Enterprise	NMM	1	Network Associates<br />
MarimbaEndPoint	NMM	2	Marimba Inc.<br />
MarimbaEndPoint	DIN	2	04/01/2004<br />
MarimbaEndPoint	ACT	2	Marimba Running<br />
MarimbaEndPoint	VER	2	6.0


any clues?

-- modified at 18:12 Friday 14th October, 2005
using c#, asp.net, and sql2000 BTW
AnswerRe: complex query Pin
Colin Angus Mackay14-Oct-05 13:14
MemberColin Angus Mackay14-Oct-05 13:14 
GeneralRe: complex query Pin
Joshua Lunsford17-Oct-05 11:49
MemberJoshua Lunsford17-Oct-05 11:49 
AnswerRe: complex query Pin
miah alom17-Oct-05 4:46
Membermiah alom17-Oct-05 4:46 
QuestionADO.NET Update / delete without primary keys Pin
Jasonc22114-Oct-05 11:10
MemberJasonc22114-Oct-05 11:10 
AnswerRe: ADO.NET Update / delete without primary keys Pin
miah alom17-Oct-05 5:52
Membermiah alom17-Oct-05 5:52 
GeneralRe: ADO.NET Update / delete without primary keys Pin
Jasonc22117-Oct-05 7:33
MemberJasonc22117-Oct-05 7:33 
GeneralRe: ADO.NET Update / delete without primary keys Pin
miah alom17-Oct-05 8:35
Membermiah alom17-Oct-05 8:35 
GeneralRe: ADO.NET Update / delete without primary keys Pin
Jasonc22118-Oct-05 9:22
MemberJasonc22118-Oct-05 9:22 
GeneralRe: ADO.NET Update / delete without primary keys Pin
l a u r e n21-Oct-05 15:04
Memberl a u r e n21-Oct-05 15:04 
AnswerRe: ADO.NET Update / delete without primary keys Pin
S Douglas20-Oct-05 1:45
professionalS Douglas20-Oct-05 1:45 
AnswerRe: ADO.NET Update / delete without primary keys Pin
l a u r e n21-Oct-05 15:06
Memberl a u r e n21-Oct-05 15:06 
GeneralRe: ADO.NET Update / delete without primary keys Pin
Jasonc22124-Oct-05 12:37
MemberJasonc22124-Oct-05 12:37 
QuestionSQL connection in servicedcomponents Pin
eliprand14-Oct-05 5:43
Membereliprand14-Oct-05 5:43 
AnswerRe: SQL connection in servicedcomponents Pin
eliprand14-Oct-05 6:08
Membereliprand14-Oct-05 6:08 
QuestionHow does Oracle support unicode text? Pin
Xiangyang Liu 刘向阳14-Oct-05 5:35
MemberXiangyang Liu 刘向阳14-Oct-05 5:35 
AnswerRe: How does Oracle support unicode text? Pin
DiWa14-Oct-05 19:30
MemberDiWa14-Oct-05 19:30 
GeneralRe: How does Oracle support unicode text? Pin
Xiangyang Liu 刘向阳14-Oct-05 19:50
MemberXiangyang Liu 刘向阳14-Oct-05 19:50 

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.