Thanks for the support I obtained this xml file.
There is a way to go from this XML1 to XML2
(XML 1)
<NewDataSet>
<Table>
<First_Name>Terry</First_Name>
<Last_Name>Adams</Last_Name>
<Email>adams@hotmail</Email>
<Company_Name>COMPANY1</Company_Name>
<Address_2>203rd...
The next code display a dataset in an xml format. Could some one provide a technique to create an xml file out of this.
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace XMLBond_Hub
{
class Program
{...
I create a C# console application and this code provide me what I want, but I would like to
create from the result I obtained an xml file store at the c drive. An additional require is to apply a
dtd file for validation purpose. Could some one help me to complete this code...
Any help will be appreciated
ID text
1 RTS_US SalesCov for HGU_SEC
2 GRT_UK SalesCov for All Euro
3 JJJ_US SalesCov for All Euro
4 COM_US SalesCov for HGU_SEC
From the previous record I need an output like this
I need to create an additional colum CODE and the value has to be...
I need some help to modify the following query
QUERY I
Select distinct
trunc(sessions.starttime) as date,
comp.CompanyID,
comp.HC,
sessions.userid
from
S_USERSESSION sessions,
S_USER users,
S_COMPANY comp
where
sessions.userid = users.userid and
users.companyid = comp.companyid and...
D.table_name = 'PCCDES' yes there is just one table with the name PCCDES so it is unique.
I table has 2 regions.
J_history A,
J_pages B,
J_items C,
B AND C HAS FOREING KEY IN A
Thanks
AND D.table_name = 'PCCDES' yes there is just one table with that name. we have 2 regions.
J_history A,
J_pages B,
J_items C,
B AND HAS FOREING KEY IN A
The folloing query return the query I am looking for however the performance is not too goog. Could some one provide some technical advise how to improve performance.
select f. s_name_1,
g.company_name,
g. s_name_1,
k.full_name,
j.p_name,
e.edit_date,
e.status...
All of them are views
Record1 returns all Maximum dates for an specific product the only thing I need from this is the ID because I want to use this to obtain data on record2. However record 2 will return all data including data from record1 which I don't need it.
...insert into @Record2 values (2,'UGrade','2005-11-15 10:43:02.963')
insert into @Record2 values (2,'Grade','2005-11-17 10:53:03.237')
SELECT *
FROM @Record2 a
WHERE [date] NOT IN (
SELECT [date] FROM @Record1
WHERE ID = a.ID
)
Let me know if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.