Viewing 15 posts - 46 through 60 (of 128 total)
Hi,
Don't you need a Return stament on the VB function??
July 17, 2012 at 9:32 am
Hi Parajuli,
I like your formula, is neat. But i found it does not produce a correct result for one case.
Look, if the bussinesweek is Monday to Friday, and I run...
July 13, 2012 at 12:48 pm
The lack of that index is producing two table scans that are consuming 64 % of execution time.
July 5, 2012 at 2:06 pm
You migth need a index on the field BOOKING_ID of the table MG_BOOKING_COMMODITY
July 5, 2012 at 2:05 pm
Hi,
I don't know but "AND (MB.SC_NUM NOT IN (SELECT SC_NUM from MiniFCA..MF_SC_NUMBER)
OR MB.SC_NUM IS NULL)
" is not something like a Catch All Query and it produces a table scan?
July 5, 2012 at 1:50 pm
i had a revelation when i wake up. This is what you migth need.
NewDocumentBodies
AS
(
SELECT BodyId,
NewBodyText =...
May 31, 2012 at 8:01 am
Hi Rabisco,
Please post your complete query code. The code i sent is intendeed to add <body> at the beggining and the end of one body id, just as you...
May 30, 2012 at 3:36 pm
That why the replace is for:
NewBodyText = REPLACE(REPLACE(NewBodyText,'<','<'),'>','>')
should be like :
NewBodyText = REPLACE(REPLACE(NewBodyText,'ampersand lt semicolon','<'),' ampersand gt semicon','>')
Using the actual chars that we cant post in the forum
May 22, 2012 at 4:31 pm
Wait so your problem is that the new link is something like
semicolon ampersand lt p semicolon ampersand gt ??
May 22, 2012 at 4:24 pm
Try setting more space in the following line:
LinkText = CONVERT(VARCHAR(200),Link.query('.')),
Change it to 1000, just to try
May 22, 2012 at 4:21 pm
can you send the body text you are testing and the code you have updated?
May 22, 2012 at 4:03 pm
How many links a paragraph may contain?
May 22, 2012 at 3:57 pm
Also, you can try this other aproach if there is only one link inside each parragraph.
;WITH XmlDocuments
AS
(
select *,XmlDoc = convert(xml,'<?xml version = "1.0"?>'+bodytext)
from documentbody d
where BodyText IS NOT NULL
),
LinkCodes
AS
(
select...
May 22, 2012 at 3:52 pm
Hi there,
You can try his for LinkCodes cte. What happens is that the old query is looking for the atribute code1 or code2 in the node, but as the node...
May 22, 2012 at 3:48 pm
This is just an option that came to my mind ...
declare @Sectionid int=1984
DECLARE @Assessments nvarchar(max), @Total nvarchar(max)
SELECT @Assessments =
STUFF(
(
select ',' + quotename(cast(AssessmentID as nvarchar(15)))
from GradeBook.Assessment as A
where SectionID=@SectionID
and A.Deleted=0
for xml...
May 22, 2012 at 1:02 pm
Viewing 15 posts - 46 through 60 (of 128 total)