Getting null back instead of value

• Santiago E. Perez

  Right there with Babe

  Points: 715

  More actions

  March 20, 2009 at 1:48 pm

  #202173

  I am new to the world of XML in SQL and trying to return a basic resultset from exeecuting the following:

  exec get_lcm_laneclosure_Filter @IncludeInactiveRequestSOurces=1,@IncludeSpecialEvents=0,

  @RequestSOurcesIDs=N'

  ',@RoadtobeClosed_ID=12,@BeginMP=20,@EndMP=70,@DirectionID=4

  ALTER PROCEDURE [dbo].[get_lcm_laneclosure_Filter]

  @Laneclosure_IDint = null,

  @IncludeInactiveRequestSOurcesbit = null,

  @Closure_Type_IDint = null,

  @RequestSOurcesIDsXML = null,

  @IncludeSpecialEventsbit = null ,

  @DaytimeClosuresOnlybit = null,

  @Status_IDint = null,

  @RoadtobeClosed_IDint = null,

  @BeginMPdecimal(6,3) = null ,

  @EndMPdecimal(6,3) = null ,

  @BICint = null,

  @DirectionIDint = null,

  @StartDateDateTime = null,

  @EndDateDateTime = null,

  @DateEnteredStartDateTime = null,

  @DateEnteredEndDateTime = null

  AS

  Select T.c.value('RSourceID[1]','int') from @RequestSOurcesIDs.nodes('/RSources/RSource') as T(c)

  return

  Any ideas?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  March 20, 2009 at 2:14 pm

  #963784

  Since the forums don't display XML well, please attach a copy of your query and such, stored as a txt file.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon