Click here to Skip to main content
15,897,968 members
Home / Discussions / Database
   

Database

 
AnswerRe: Converting JET to SQL Database Pin
Stephen McGuire8-Sep-06 9:06
Stephen McGuire8-Sep-06 9:06 
Questionfew queries in Stored procedures Pin
ParagGupta8-Sep-06 4:57
ParagGupta8-Sep-06 4:57 
AnswerRe: few queries in Stored procedures Pin
Stephen McGuire8-Sep-06 9:12
Stephen McGuire8-Sep-06 9:12 
GeneralRe: few queries in Stored procedures Pin
Stephen McGuire10-Sep-06 16:18
Stephen McGuire10-Sep-06 16:18 
AnswerRe: few queries in Stored procedures Pin
Colin Angus Mackay10-Sep-06 9:34
Colin Angus Mackay10-Sep-06 9:34 
AnswerRe: few queries in Stored procedures Pin
Uma Kameswari10-Sep-06 20:49
Uma Kameswari10-Sep-06 20:49 
AnswerRe: few queries in Stored procedures Pin
Amit Kumar G12-Sep-06 16:35
Amit Kumar G12-Sep-06 16:35 
QuestionHow can I set the output format of "FOR XML"? Pin
Red_Wizard_Shot_The_Food8-Sep-06 2:56
Red_Wizard_Shot_The_Food8-Sep-06 2:56 
At the moment I have a query that returns data about meetings in XML format using the
"FOR XML AUTO, ELEMENTS" clause

The problem is that if there is a meeting with the same person on the same day (I know, its hardly a common occurance) the XML output comes out like this:

<br />
<mdate><br />
<![CDATA[02/06/2006]]><br />
</mdate><br />
<br />
<Meetings><br />
<id><br />
<![CDATA[92]]><br />
</id><br />
<complete><br />
<![CDATA[1]]><br />
</complete><br />
</Meetings><br />
<br />
<Meetings><br />
<id><br />
<![CDATA[93]]><br />
</id><br />
<complete><br />
<![CDATA[2]]><br />
</complete><br />
</Meetings><br />


Unfortunatley because of the XSL file doing the formating it does not make table entries for the second meeting (id:93 in this example).

What I want idealy is for the XML output to contain all the meeting information in seperate entries ... and NOT cluster together meetings with the same people one the same date like it is doing.

Any ideas? or should i make a different XSL file to handle this out put? (and if so any hints on doing that as I mostly just loop through output in a very simple manner)

Thanks
AnswerRe: How can I set the output format of "FOR XML"? Pin
Tushar Kothari11-Sep-06 3:51
Tushar Kothari11-Sep-06 3:51 
QuestionHow to install the Postgre SQL using Silent Mode in Windows 2000? Pin
Arul Joseph8-Sep-06 0:52
Arul Joseph8-Sep-06 0:52 
Questionxp_smtp_sendmail/xpsmtp80.dll Pin
Arghya_mp7-Sep-06 23:55
Arghya_mp7-Sep-06 23:55 
QuestionRegarding Cursor Pin
param thaker7-Sep-06 23:05
param thaker7-Sep-06 23:05 
AnswerRe: Regarding Cursor Pin
Stephen McGuire8-Sep-06 9:23
Stephen McGuire8-Sep-06 9:23 
QuestionDatabase for Java [modified] Pin
eMtek7-Sep-06 20:33
eMtek7-Sep-06 20:33 
AnswerRe: Database for Java Pin
Dominic Pettifer8-Sep-06 2:36
Dominic Pettifer8-Sep-06 2:36 
QuestionParameterized Queries in the SELECT portion? Pin
Dominic Pettifer7-Sep-06 13:51
Dominic Pettifer7-Sep-06 13:51 
AnswerRe: Parameterized Queries in the SELECT portion? Pin
Not Active7-Sep-06 18:53
mentorNot Active7-Sep-06 18:53 
GeneralRe: Parameterized Queries in the SELECT portion? Pin
Dominic Pettifer8-Sep-06 2:31
Dominic Pettifer8-Sep-06 2:31 
GeneralRe: Parameterized Queries in the SELECT portion? Pin
Colin Angus Mackay10-Sep-06 9:27
Colin Angus Mackay10-Sep-06 9:27 
Questionupdating an IMAGE column Pin
jszpila7-Sep-06 5:15
jszpila7-Sep-06 5:15 
AnswerRe: updating an IMAGE column Pin
Michael Potter7-Sep-06 5:50
Michael Potter7-Sep-06 5:50 
Questioncombining multiple rows into single column Pin
Uma Kameswari7-Sep-06 2:32
Uma Kameswari7-Sep-06 2:32 
AnswerRe: combining multiple rows into single column Pin
Michael Potter7-Sep-06 6:02
Michael Potter7-Sep-06 6:02 
AnswerRe: combining multiple rows into single column Pin
Eric Dahlvang7-Sep-06 9:26
Eric Dahlvang7-Sep-06 9:26 
Questionfunction vs stored procedure in sqlserver 2000 Pin
yazan_zahi7-Sep-06 1:42
yazan_zahi7-Sep-06 1:42 

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.