Viewing 15 posts - 4,756 through 4,770 (of 5,590 total)
Paul White (2/21/2010)
Wayne,Thanks for that. I'm a bit old-school and also include an INDEX(0) too. I was rather hoping for a quirky implementation for the updated requirements though...
I...
February 22, 2010 at 6:05 am
Paul White (2/21/2010)
So, would anyone like to post a correct quirky-update solution to the updated requirement, just for completeness?
Good idea Paul... we've talked about the need for doing it right,...
February 21, 2010 at 11:10 pm
Jeff Moden (2/21/2010)
"Downtime"? Heh... I've gotta Google that and find out what it means. 😉
Let me help you out... it's the term for the free time you'll be having...
February 21, 2010 at 8:50 pm
From my perspective, answering the same basic question repeatedly just reinforces what I'm in the process of learning. For instance, I wouldn't have learned as much as I have about...
February 21, 2010 at 8:25 pm
Okay... I'm looking at the recent posts, by clicking on the "Recent Posts | Posts added today". I know that this times out after a while, and you need to...
February 21, 2010 at 7:09 pm
Jeff Moden (2/21/2010)
[Please see the article others are pointing to and if you're not going to use the method correctly, then do use it at all.
Jeff, don't you mean "then...
February 21, 2010 at 7:05 pm
Paul White (2/20/2010)
WayneS (2/20/2010)
...you also wouldn't be able to use the CROSS APPLY from Paul's post (which I see he has already provided a totally awesome solution that considers this).
Fixed...
February 21, 2010 at 7:30 am
Paul White (2/20/2010)
sachin1sharma (2/20/2010)
Because I am using SQL Server 2000Oh for the love of small fluffy bunnies!!! :w00t:
You did see that this is the 2008 Forum, right?
Well, this certainly...
February 20, 2010 at 7:35 am
sachin1sharma (2/20/2010)
AGAIN I don't want to use CTE to achieve this.
A CTE is a pretty powerful tool - why don't you want to use it?
In a lot of cases, a...
February 20, 2010 at 6:05 am
You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...
February 20, 2010 at 5:54 am
Hey guys... Please read this article[/url] for all the rules in using this form of the update statement - they must be followed or you can get erroneous results!
February 19, 2010 at 9:01 pm
You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...
February 19, 2010 at 3:43 pm
Lynn Pettis (2/18/2010)
CirquedeSQLeil (2/18/2010)
When will we see books from Jack, Lynn and Gus?
Would like to write one, just not too sure about what to write. Some people can write...
February 19, 2010 at 1:36 pm
Alvin Ramard (2/17/2010)
After that I have to decide which edition of Win7 I put on the netbook. Do I really need more than Home Premium????????
When I got my Vista...
February 17, 2010 at 8:37 pm
Viewing 15 posts - 4,756 through 4,770 (of 5,590 total)