Viewing 15 posts - 1 through 15 (of 61 total)
mister.magoo (5/24/2013)
you probable want something more like this:
select point_range,count(*)
from (
select
jp.userid
,...
May 24, 2013 at 5:56 pm
Evil Kraig F (5/24/2013)
If you would like us to be able to provide solutions that...
May 24, 2013 at 5:48 pm
mister.magoo (5/24/2013)
Try this:
select
x.point_range
, count(jp.userid) as countofusers
from StatusLevelPnt jp
inner join user ju...
May 24, 2013 at 5:29 pm
rVadim (8/11/2012)
Check this article:http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
Thanks.
August 12, 2012 at 10:48 am
Lynn Pettis (8/3/2012)
rabisco (8/3/2012)
Lynn Pettis (8/3/2012)
August 6, 2012 at 8:54 am
Lynn Pettis (8/3/2012)
August 3, 2012 at 11:34 am
rabisco (8/2/2012)
uid fieldid vaue
1172 5000
1172 5001 Development,support,management
1172 5002
1172 5003 Other
1172 5004 Computing
1172 5004 ...
August 3, 2012 at 10:35 am
adrian.facio (5/31/2012)
NewDocumentBodies
AS
(
SELECT BodyId,
NewBodyText...
June 1, 2012 at 2:15 pm
adrian.facio (5/30/2012)
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...
May 30, 2012 at 3:50 pm
rabisco (5/22/2012)
adrian.facio (5/22/2012)
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
Ah...
May 30, 2012 at 2:48 pm
adrian.facio (5/22/2012)
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
Ah ok...
May 22, 2012 at 4:34 pm
adrian.facio (5/22/2012)
Wait so your problem is that the new link is something likesemicolon ampersand lt p semicolon ampersand gt ??
Correct.
May 22, 2012 at 4:26 pm
adrian.facio (5/22/2012)
can you send the body text you are testing and the code you have updated?
This is one paragraph from the body text I'm testing
<p>Text before <a __macro_name="productLink" class="macro_productLink _macro_uid_13317485981859923"...
May 22, 2012 at 4:17 pm
adrian.facio (5/22/2012)
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...
May 22, 2012 at 3:58 pm
adrian.facio (5/21/2012)
<a name ="FirstName" name = "SecondName" Code1...
May 22, 2012 at 3:11 pm
Viewing 15 posts - 1 through 15 (of 61 total)