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!

Register Log in
  • Congratulations derfloh 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: *

  1. elder81

    Querying XML using Oracle SQL developer

    Thank you to Taupiro. I actually ended up using a similar script to yours before I saw your reply. My script is as below: XMLREQBODY,substr(xmlreqbody,(Instr(xmlreqbody,'PersonNumber')+13),(Instr(xmlreqbody,'/PersonNumber'))-(Instr(xmlreqbody,'PersonNumber')+14)) as PersonNumber (This is...
  2. elder81

    Querying XML using Oracle SQL developer

    Hi all, First let me set the scene. I am very new to XML and got a reasonable understanding of sql. I have a database that amongst other things has a column in a table that contains the following XML. "<Request action="Update"> <Personality>...
    • elder81
    • Thread
    • Replies: 3
    • Forum: XML
  3. elder81

    Creating a date loop

    Thanks for your reply, should have clarified, I am using SQL 2005 not 2008
  4. elder81

    Creating a date loop

    Thanks, I think I have fixed and appreciate you not "SHowing" me. This is my fix: (It works but not sure if it is right or not) USE [kdemo] GO /****** Object: StoredProcedure [dbo].[DAYDATELIST] Script Date: 07/02/2010 13:59:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER...
  5. elder81

    Creating a date loop

    Hello all, I moving to another area of the comany I work in and I am learning SQL by being set challenges by my new manager. The request in this case was to return a list of dates from today, 14 days into the future. I have got this far, USE [kdemo] GO SET ANSI_NULLS ON GO SET...

Part and Inventory Search

Back
Top