|
Home > Archive > MS SQL XML > July 2005 > SQL 2000 data to Custom XLM
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 2000 data to Custom XLM
|
|
|
| Hi,
How can I create a (custom) xml file looking like this:
<STORE>
<AUTH_KEY>carp1di3m</AUTH_KEY>
<REQUEST_ID> W;;123456;2714;15900
;JUDGMENT;[0];2005-03-22;14:48:28;NJ</REQUES
T_ID>
<WEB_ORDER>12345</WEB_ORDER>
<REFERENCE>test</REFERENCE>
<REPORT>
<REPORT_TYPE>UCC</REPORT_TYPE>
<REPORT_FOLDER>1111591708</REPORT_FOLDER>
<REPORT>
<STORE>
an so on
from SQL 2000 tables or SP?.
Thanks
Dib
| |
|
| Sorry I am using VB 6
Thanks
Dib
"Dib" < NOTdibsSPAM@comNOSPA
Mcast.net> wrote in message
news:%23ffjX0%23iFHA
.3144@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> How can I create a (custom) xml file looking like this:
>
> <STORE>
> <AUTH_KEY>carp1di3m</AUTH_KEY>
>
<REQUEST_ID> W;;123456;2714;15900
;JUDGMENT;[0];2005-03-22;14:48:28;NJ</ REQUES
> T_ID>
> <WEB_ORDER>12345</WEB_ORDER>
> <REFERENCE>test</REFERENCE>
> <REPORT>
> <REPORT_TYPE>UCC</REPORT_TYPE>
> <REPORT_FOLDER>1111591708</REPORT_FOLDER>
> <REPORT>
>
> <STORE>
> an so on
>
> from SQL 2000 tables or SP?.
>
> Thanks
> Dib
>
>
| |
| Bertan ARI [MSFT] 2005-07-18, 8:24 pm |
| How does your database schema look like?
--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dib" < NOTdibsSPAM@comNOSPA
Mcast.net> wrote in message
news:%23ffjX0%23iFHA
.3144@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> How can I create a (custom) xml file looking like this:
>
> <STORE>
> <AUTH_KEY>carp1di3m</AUTH_KEY>
> <REQUEST_ID> W;;123456;2714;15900
;JUDGMENT;[0];2005-03-22;14:48:28;NJ</REQUES
> T_ID>
> <WEB_ORDER>12345</WEB_ORDER>
> <REFERENCE>test</REFERENCE>
> <REPORT>
> <REPORT_TYPE>UCC</REPORT_TYPE>
> <REPORT_FOLDER>1111591708</REPORT_FOLDER>
> <REPORT>
>
> <STORE>
> an so on
>
> from SQL 2000 tables or SP?.
>
> Thanks
> Dib
>
>
| |
|
| I don't know much about schema, and not sure where to look, I am new to SQL
server.
I do not have any created, all I know that I have are the tables, views and
SP.
Thanks
Dib
"Bertan ARI [MSFT]" <bertan@online.microsoft.com> wrote in message
news:%23VlG5R$iFHA.2852@TK2MSFTNGP14.phx.gbl...
> How does your database schema look like?
>
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
>
> "Dib" < NOTdibsSPAM@comNOSPA
Mcast.net> wrote in message
> news:%23ffjX0%23iFHA
.3144@TK2MSFTNGP12.phx.gbl...
<REQUEST_ID> W;;123456;2714;15900
;JUDGMENT;[0];2005-03-22;14:48:28;NJ</ REQUES[color=darkred
]
>
>
| |
| Bertan ARI [MSFT] 2005-07-26, 8:24 pm |
| Check out using For Xml AUTO. Books online has several example how to use
For Xml AUTO.
If that doesn't work for you because of limitations, try using Annotated
Schema from SQLXML3 SP3 which needs to be installed seperately. Check out
http:\\www.msdn.microsoft.com\sqlxml.
--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dib" < NOTdibsSPAM@comNOSPA
Mcast.net> wrote in message
news:uXjOTvFjFHA.3144@TK2MSFTNGP12.phx.gbl...
>I don't know much about schema, and not sure where to look, I am new to SQL
> server.
> I do not have any created, all I know that I have are the tables, views
> and
> SP.
>
> Thanks
> Dib
>
>
>
> "Bertan ARI [MSFT]" <bertan@online.microsoft.com> wrote in message
> news:%23VlG5R$iFHA.2852@TK2MSFTNGP14.phx.gbl...
> rights.
> <REQUEST_ID> W;;123456;2714;15900
;JUDGMENT;[0];2005-03-22;14:48:28;NJ</REQUES
>
>
|
|
|
|
|