Help: SQL Developer question
I have xml data in a column called OriginalString as follows. I need to extract all "Item Key" values from this column. I can use the CHARINDEX and SUBSTRING function combination to extract the first occurance of ItemKey, but how do I do this when I have multiple "Item Key"
bajara · Jan 15, 2015 1:18 PM · 10,057 views
If i understand your question correctly: Select OriginalString.value('(Addyourrootnodehere/AttributenameHere/@ItemKey)[1]','varchar(max)') as [AlchiLagyo] from dbo.YourTableNameHere i wud deff love to see your implementation using CHARINDEX AND SUBSTRING though :P
alece · Jan 15, 2015 2:20 PM
This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.
Start a New DiscussionYou might be interested in...
-
Room Available for Rent USD 850.00Melrose, MA ·
-
One bed room available for rent USD 1,300.00Germantown, MD ·
-
Malden, MA, United States · Reposted Originally posted
-
Big Room with Parking Next to bus stop USD 1,100.00Everett, MA ·
-
Rooms Available for Rent USD 2,700.00Reston, VA ·
-
Oct 4, 2026 7:00 PM · Boston / New England · 517 views -
Nepal Festival Perth 2026 FestivalOct 10, 2026 10:00 AM · Perth / Western Australia · 226 views -
Grand Dashain Mela 2026 FestivalOct 10, 2026 11:00 AM · Bay Area / Northern California · 215 views -
Oct 11, 2026 11:00 AM · DMV / Greater Washington · 228 views · Dashain -
Dashain Festival Fulpati PartyOct 17, 2026 10:00 PM · Greater London · 189 views · Dashain
-
✓Vianet Communications OtherKathmandu · · 286 views
-
Aama Lama RestaurantMalden, MA · · 244 views
-
Ailaa Himalayan Bar & Grill RestaurantStoneham, MA · · 247 views
-
Ailaa Himalayan Bar & Grill RestaurantBedford, TX · · 222 views
-
Annapurna Curry & Sekuwa House RestaurantManchester, NH · · 225 views