Viewing 15 posts - 1 through 15 (of 29 total)
yes, script provided in the link is not entirely suitable for my requirement.
September 9, 2016 at 11:57 am
Hi Allen,
I tried this using below query and I am not able add the elements inside other elements like doc
SELECT *
FROM [#XMLTable]
for xml path(''), root('Batch')
I need line one...
August 2, 2016 at 8:08 pm
Hi Sir,
I need to extract values from XML column in table instead of variable.
Here I'm attaching the sql file for test data (some part of xml data). Could you...
May 31, 2015 at 12:13 am
Thank you very much sir, I'm able to write the sql script for other elements 🙂
May 24, 2015 at 11:45 pm
Hi Eirik,
I need to add the count element in between <continents>and <continent> , <countries> and <country>, ....
something like below
<continents>
<count>2</count>
<continent>
-----------
...
March 22, 2015 at 8:19 am
Hi Mark,
Is this possible to add counts at each level in xml like below .
<continents>
<count>xx</count>
<continent>
..........
...........
<countries>
...
March 21, 2015 at 11:39 pm
Perfect Mark, Thank you very much...!!!
March 11, 2015 at 9:12 am
Thanks a lot Mark for providing query and it helps.
Also Could you please add below mentioned <Records>,<header>and </body>elements to the same query.
<?xml version="1.0" encoding="UTF-8"?>
<Records>
<header>
<FileDate> YYYYDDMM </FileDate>
</header>
<body>
.......Here,I will use query...
March 10, 2015 at 6:22 pm
Can you please give me the just raw calculations on the size of the page (file) with out using queries.
Want to understand it from general calculations instead of sql...
February 4, 2015 at 9:22 am
Please ignore this as created a new thread in SQL Server 2008 - General forum for the same.
February 4, 2015 at 8:58 am
Thank you very much Eiriksson and Luis for your valuable solutions.
November 30, 2014 at 1:48 am
Luis/Erickur,
Instead of computing every time, I am planing to insert all the unique sequences into one look up table.
CREATE TABLE Lkup_UniqueSequenceValues
(
Id bigint identity(1,1) primary...
November 29, 2014 at 11:16 pm
Eirikur Eiriksson (11/29/2014)
Jampandu (11/29/2014)
November 29, 2014 at 6:41 pm
Thanks Eiriksson .. I need to add this logic in computed column along with bigint identity(5,5). will try to exclude alphabet letters like I and O while computing ...
November 29, 2014 at 1:52 am
Viewing 15 posts - 1 through 15 (of 29 total)