Recent content by Raul2005

Thanks for your help I am working on that.

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...

Need some help to Generate an XML file from SQL server by using a sql statement or store procedure with c#. Thanks

This store procedure generate ramdom numbers but there is a slight probability that it could generates duplicate numbers. Can some one help me to modified it so at the time it is inserted in a table field it could verify if the same number exist.In case it exist generate another number verify...

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...

id code 1 ABC_GB 2 DCF_GB 3 RTF_US NEED HELP TOto change the records that contain _GB to _US

Thanks Raul

ID Account Client DealerNam MSEG Tier 01 3949 ALLIUK ABN S_HG 3 02 3949 ALLIUK ABN S_HG 3 03 3949 ALLIUK TRB S_HG 3 04 3949 ALLIUK CRO S_HG 3 05 4000 Ahold CUS M_KG 3 06 4000 Ahold CUS...

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...

Select distinct trunc(sessions.starttime) as date, comp.name, comp.HC, sessions.ctype, count (sessions.userid) from S_USERSESSION sessions, S_USER users, S_COMPANY comp where sessions.userid = users.userid and users.companyid = comp.companyid and sessions.starttime > trunc(sysdate) - 10 AND...

Select distinct trunc(sessions.starttime) as date, comp.name, comp.HC, sessions.ctype, count (sessions.userid) from S_USERSESSION sessions, S_USER users, S_COMPANY comp where sessions.userid = users.userid and users.companyid = comp.companyid and sessions.starttime > trunc(sysdate) - 10 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