Viewing 15 posts - 5,281 through 5,295 (of 7,484 total)
Jim Murphy (10/25/2011)
October 25, 2011 at 7:41 pm
SQLRNNR (10/25/2011)
ChrisM@Work (10/25/2011)
Brandie Tarvin (10/25/2011)
ChrisM@Work (10/25/2011)
Brandie Tarvin (10/25/2011)
Got my new smart phone. Setting up my tethering connection now. Thanks for all the help.
A nice pair of ski socks will prevent...
October 25, 2011 at 10:53 am
SQLRNNR (10/25/2011)
SSPI
Not from MA, are you, Jason? So I don't have to wonder too much what that stands for?
October 25, 2011 at 10:37 am
If 51022059 genuinely is one of the policy numbers with which you have this problem, run
select len(pa_policy), pa_policy from pa_payts where pa_policy like '51022059%' and pa_policy <> '51022059'
That...
October 25, 2011 at 5:21 am
The_V (10/24/2011)
Case
when Len(F.Comments)...
October 25, 2011 at 5:03 am
gmmastros (10/21/2011)
October 25, 2011 at 4:49 am
Nice easy question.
Maybe a bit too long in the sql.
October 25, 2011 at 4:23 am
Evil Kraig F's signature (10/24/2011)
This space for Rent.- Payment will only be accepted in non-mobile Electrons.
The wonderful thing about non-mobile electrons is that you know their momentum exactly (it's...
October 24, 2011 at 11:18 am
I noticed there are some copies of http://beta.sqlservercentral.com/articles/Normalization/74241/ out there. There's an unattributed one at http://www.developerstalk.com/post/2011/06/29/SQL-First-Normal-Form-%281NF%29.aspx, a fully attributed one at http://www.slideshare.net/adrianmiranda/primera-forma-normal and two with attribution to sqlservercentral.com (both...
October 24, 2011 at 10:22 am
Hugo Kornelis (10/24/2011)
Captain Miserable (10/24/2011)
I agree - a simple case statement seems much more straight forward. Is there a reason why the subquery would be more effective?
No.
Either...
October 24, 2011 at 9:00 am
It's a nice easy question, but I have to agree with Joe:
CELKO (10/23/2011)
UPDATE Table1SET col1 = -(col1 - 1);
Why make it so insanely complex?
I...
October 24, 2011 at 5:54 am
Fal (10/23/2011)
Ah bugger. New Zealand won the Rugby Union World Cup. A certain someone is gonna be absolutely intolerable now. 😛Steve.
No change, then?
October 23, 2011 at 6:08 am
Revenant (10/21/2011)
SQLRNNR (10/21/2011)
musketeerthree
plus le garçon Gascon de Gers (was the fourth of the three).
October 21, 2011 at 11:14 am
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?
How about basic database security -...
October 21, 2011 at 7:01 am
Britt Cluff (10/21/2011)
Thanks for the question. What's the point in using TOP in a view?
OK, here is a real example that I had in one job.
In an interactive entertainment system,...
October 21, 2011 at 6:34 am
Viewing 15 posts - 5,281 through 5,295 (of 7,484 total)