Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Raul2005
  • Order by date
  1. Raul2005

    Create an xml file and stored at hard drive

    Thanks for your help I am working on that.
  2. Raul2005

    Create an xml file and stored at hard drive

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

    Create an xml file and stored at hard drive

    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 {...
  4. Raul2005

    Generate an xml using c# and sql server

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

    Generate an xml using c# and sql server

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

    Avoid duplicate numbers

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

    Find and Replace string

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

    Replace

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

    Find duplicates

    Thanks Raul
  10. Raul2005

    Find duplicates

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

    Group and count Problem

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

    group problem

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

    Grouping problem

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

    Performance issues

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

    Performance issues

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

    Performance issues

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

    exclude records

    Thanks for your support guys.
  18. Raul2005

    exclude records

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

    exclude records

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

    exclude records

    That is what I as looking for.. Thanks

Part and Inventory Search

Back
Top