Search results for query: *

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

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

Thanks for your support guys.

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.

However what happens if the following situation occur. The dates in record1 are the same, the query will fail . declare @Record1 table(ID int, pname varchar(20),[date] datetime) insert into @Record1 values (1,'Issue','2005-11-17 10:53:03.237') insert into @Record1 values...

That is what I as looking for.. Thanks