Viewing 15 posts - 1,456 through 1,470 (of 8,416 total)
If the data set is not very large, a brute-force method works well enough:
DECLARE @Example TABLE
(
[user_id] ...
December 13, 2011 at 10:51 am
DATALENGTH is a safer bet than LEN, due to the problem with trailing spaces.
DECLARE @String VARCHAR(100) = 'Physician->Scotland->Scotland North->NOS431 Core Medical Training ';
SELECT LEFT(@String, LEN(@String) - CHARINDEX('>-', REVERSE(@String))-1)
SELECT LEFT(@String, DATALENGTH(@String)...
December 13, 2011 at 9:43 am
I suppose we could also wonder about the relevance of the title, whether there is any guarantee the join will produce any rows or not, and what is meant by...
December 13, 2011 at 9:18 am
Wayne's LAST_VALUE bug has been updated (it will be fixed for RTM).
December 12, 2011 at 11:50 pm
Koen Verbeeck (12/11/2011)
What do you guys think of this:http://www.sqlservercentral.com/Forums/Topic1219134-364-1.aspx#bm1219795
I ask for more info, he gives a link to a site, which my company firewall immediately marks as suspicious.
The link itself...
December 12, 2011 at 12:01 am
L' Eomot Inversé (12/11/2011)
You are clearly a more patient person than me, or maybe I'm just getting less prepared to waste my time as I get older.
That's probably not generally...
December 11, 2011 at 8:52 pm
Steve Jones - SSC Editor (12/10/2011)
SQL Kiwi (12/10/2011)
Dev (12/10/2011)
Paul's Time Travel :Whistling: (see the attachment)
Yes, I had an email today saying it would be republished on that date...
December 10, 2011 at 5:43 pm
GilaMonster (12/10/2011)
SQL Kiwi (12/10/2011)
GilaMonster (12/10/2011)
Go listen to this. Seriously. http://dotnetrocks.com/default.aspx?showNum=690Seriously? You want me to spend 45 minutes listening to someone talk about Agile development with .NET?
That episode has nothing...
December 10, 2011 at 5:34 pm
GilaMonster (12/10/2011)
Go listen to this. Seriously. http://dotnetrocks.com/default.aspx?showNum=690
Seriously? You want me to spend 45 minutes listening to someone talk about Agile development with .NET?
December 10, 2011 at 3:43 pm
mpdillon (12/10/2011)
Did I do something wrong? If so it was not intentional.
Hi Pat,
No! Not at all. Steve Jones (the editor) chooses to republish articles based on questions that...
December 10, 2011 at 11:15 am
Dev (12/10/2011)
Paul's Time Travel :Whistling: (see the attachment)
Yes, I had an email today saying it would be republished on that date (no doubt you saw my post about...
December 10, 2011 at 3:33 am
Ah so this explains why I got a republication email for my SSC article today 🙂
December 10, 2011 at 3:05 am
Turns out the parser is sending 'range between unbounded and current' for both FIRST_VALUE and LAST_VALUE with the CTE. This doesn't cause a problem for FIRST_VALUE (naturally!) but definitely...
December 10, 2011 at 12:08 am
Wayne,
Still digging into the details, but this is a much-simplified repro:
DECLARE @Example TABLE
(
order_date DATE NOT NULL,
total_due MONEY NOT NULL
)
INSERT...
December 9, 2011 at 11:50 pm
WayneS (12/9/2011)
December 9, 2011 at 11:05 pm
Viewing 15 posts - 1,456 through 1,470 (of 8,416 total)