Viewing 15 posts - 5,041 through 5,055 (of 5,502 total)
Hi,
I'd recommend to read through Jacob Sebastians articles "XML Workshop ..." (search for those keywords in this site).
It covers a lot of subject on how to deal with xml data.
I...
August 20, 2009 at 6:00 am
Hi,
could you please provide table structure and sample data the same way you just did but for table wce_ilr and wce_contact together with some sample data that show the effect...
August 20, 2009 at 5:22 am
I strongly recommend to stay with a relational data model, meaning to have three columns: EMPCODE, Date, value.
Therewith you don't need any code to add a new column for a...
August 20, 2009 at 12:22 am
Lowell (8/19/2009)
noone has mentioned the TSQL bitwise operators yet. pipe (|)and carat(^) for flipping bits, and ampersand for comparisons(&)
The OP mentioned it in the first post:
JohnG (8/19/2009)
August 19, 2009 at 11:51 pm
It looks like it's an issue with your OR condition in your left outer join.
Check if your suspicious results have rows in wce_contact with the same company name, but none...
August 19, 2009 at 3:05 pm
How about the following formula?
DECLARE @bitPos TINYINT
SET @bitPos = 4 -- EDIT: was 3
SELECT @i - ( ( FLOOR(@i/(POWER(2,(@bitPos-1)))) % 2 - @b) * (POWER(2,(@bitPos-1))))
Some explanation:
Step 1:
@bitPos is used to...
August 19, 2009 at 2:33 pm
I'm not sure if the logic you're trying to implement will help to achieve the goal you're looking for:
As far as I can see your EXIST statement is pretty much...
August 19, 2009 at 4:06 am
Hi,
to begin with a short advise: When posting xml data please use the relevant code tags (a list of IFCode Shortcuts is on the left side of the input box...
August 19, 2009 at 3:50 am
the cte (AKA as CommonTableExpression) basically is a subquery / derived table and could also be written as
SELECT id,
x.od.value('batch[1]','varchar(10)') AS batch,
x.od.value('cardexpirationdate[1]','VARCHAR(50)') AS cardexpirationdate,
y.c.value ('merchantRefCode[1]','VARCHAR(50)') AS merchantRefCode
FROM (SELECT id, cast (data...
August 18, 2009 at 5:18 pm
Would something like this meet your requirement?
;WITH
cte AS (
SELECT id, cast (data AS xml) AS xml FROM #t
)
SELECT id,
x.od.value('batch[1]','varchar(10)') AS batch,
x.od.value('cardexpirationdate[1]','VARCHAR(50)') AS cardexpirationdate,
y.c.value ('merchantRefCode[1]','VARCHAR(50)') AS merchantRefCode
FROM cte
CROSS APPLY xml.nodes('payment') x(od)
CROSS...
August 18, 2009 at 4:15 pm
cos_ta393 (8/18/2009)
3) Finally I reviewed Lutz's articles but this solution will be implemented against a 2000 engineThanks,
Three things to notice:
a) you posted in a SQL2K5 forum so someone could expect...
August 18, 2009 at 3:58 pm
Let's go for the next turn....
How about this version?
It returns all the values from the xml document rather than the selective ones you requested but I decided to leave it...
August 18, 2009 at 3:44 pm
Would something like the following meet your (new) requirement in terms of showing the values (leaving out the ID for the moment)?
It's not exactly what you've requested but it follows...
August 18, 2009 at 3:26 am
Now I'm totally lost....
Why don't you use one or any combination of the tags within the OrderDocumentRequest element, like caseId(2923029), partitionCode (ADK), BatchNumber (3012578260) or tag(TadID)?
It's really hard to guess...
August 17, 2009 at 4:11 pm
something like SELECT newid() AS ID,
Breq.value('caseId[1]','varchar(200)') AS [caseID],
Doc.value('Name[1]', 'varchar(200)') AS [Name],
Doc.value('Value[1]', 'varchar(max)') AS [Value]
FROM @xml.nodes('/OrderDocumentBatch/OrderDocumentRequest') AS B(Breq)
...
August 17, 2009 at 3:22 pm
Viewing 15 posts - 5,041 through 5,055 (of 5,502 total)