|
|
-
|
|
Is it possible to set the value of an attribute in an xml fragment using a relation variable. For example, let's day I declare and initialise a variable using T-SQL:
> DECLARE @FullFileName varchar(100)
SET @FullFileName = 'C:\DBA_Share\SSRS\Output\M...
|
|
-
|
|
Hi,
I would like to write CTE Query to get expected results.
Here are the table and expected results.
1)
declare @t table(zid int,dok varchar(100),stawka int)
insert into @t values
(1,'333',10),
(2,'333',10),
(3,'333',20),
(4,'3...
|
|
-
|
|
Hi,
I would like to write CTE Query to get expected results.
Here are the table and expected results.
1)
declare @t table(zid int,dok varchar(100),stawka int)
insert into @t values
(1,'333',10),
(2,'333',10),
(3,'333',20),
(4,'3...
|
|
-
|
|
How do I get node text based on attribute values (and NOT hard coded indexes like 1, 2, 3 etc.)
For example, I should get **abc** if I query **field1**
abc
def
g
hij
klm
nop
hij
qrs
...
|
|
-
|
|
Hi Jacob
By your posts your are probably the most authoritative author on the subject of XML handling in SQL Server. I stumbled on a problem for which I have not a single hint. May be you can be of some help for me.
I have this sample to illustrate ...
|
|
-
|
|
Dear Sir,
I am very much new to SSIS.
I have created a package , there around 70 connections is there
daily i have to load 70 excel sheet , every sheet have diffrent structure.
after loading all the fileare are deleted using script task,
my conecrn is...
|
|
-
|
|
HI Jacob
Can you please tell me how to code t-sql for following xml data
I have a t-sql script upto /tns:InjuredParty
but I don’t know how to code element and attributes for - tns:ClaimRREKey> of following xml example
I have replaced the less tha...
|
|