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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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... -
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>... -
Creating a date loop
Thanks for your reply, should have clarified, I am using SQL 2005 not 2008- elder81
- Post #5
- Forum: Microsoft SQL Server: Programming
-
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...- elder81
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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...- elder81
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
