Viewing 15 posts - 61 through 75 (of 128 total)
Hi Komal,
Are you trying to achieve something like this?. It's just my guessing.
SELECT ta.EntryId,NewInfoDate = ta.Event_datetime,Pendant.Event_DateTime ,ta.UserName
FROM TableA ta
INNER JOIN TableA Pendant
ON Pendant.EntryId = ta.EntryId AND
Pendant.Event_Type_Id =...
May 22, 2012 at 12:32 pm
Is this another correct aproach?
SELECT *
FROM #basetable a
INNER JOIN #dailytable b ON a.Component LIKE '%'+b.Process+'%'
May 22, 2012 at 12:07 pm
The second errors is caused by one of the test data elements, it contains the same attribute twice, for example :
<a name ="FirstName" name = "SecondName" Code1 =""123>...
May 21, 2012 at 3:28 pm
Hi, what happens is that you need to add a select that uses the CTE. a CTE by itself can't run. Try this please
;WITH XmlDocuments
as
(
select *,XmlDoc = convert(xml,'<?xml version =...
May 21, 2012 at 3:24 pm
This one looks slightly better i could not make it show "semicolor ampersan lt " instead of <, but if you copie the code the text is good.
;WITH XmlDocuments
AS
(
select *,XmlDoc...
May 18, 2012 at 5:04 pm
mmm the code was posted weirdly, let see if this is shown better.
;WITH XmlDocuments
AS
(
select *,XmlDoc = convert(xml,'<?xml version = "1.0"?>'+bodytext)
from documentbody d
where BodyText IS NOT NULL
),
LinkCodes
AS
(
select BodyId,
Link = Link.query('.'),
LinkText...
May 18, 2012 at 5:02 pm
The thing with xml usage is that the links need to be well formed. Some of the test data was lack of the char ". For example in the following...
May 18, 2012 at 5:00 pm
No worries, hey this is something closer of what is was trying to achieve, a set based updated of complete body text.
;WITH XmlDocuments
AS
(
select *,XmlDoc = convert(xml,'<?xml version = "1.0"?>'+bodytext)
from documentbody...
May 18, 2012 at 4:56 pm
Ok you too have a good wekeend, by the way my name is Adrian, SSC-Enthusiasthic is a title of the forum. This is the last update, try this one out...
May 18, 2012 at 3:47 pm
i forgot the exec (@updates) stamentent in the end.
May 18, 2012 at 3:37 pm
Oh that is good,
Well this query is kinda the same that the past one but it's clearer. I was trying to recreate all the bodytext handling them as a xml...
May 18, 2012 at 3:35 pm
Hey buddy,
What sql server version are you using? do you have xml variables?
May 18, 2012 at 12:36 pm
Hi,
I made this using a split with jeff modden style . It migth be useful if you are restricted to not use CLR.
DECLARE @sql AS VARCHAR(MAX)
SET @sql = ''
;WITH BodySplit...
May 18, 2012 at 11:40 am
Well, i just did not tougth that "Widowed To Divorced" could be ok, i think i made my conclusion there, if you guys feel this change is ok, then the...
May 3, 2012 at 1:31 pm
Viewing 15 posts - 61 through 75 (of 128 total)