Viewing 15 posts - 18,901 through 18,915 (of 26,490 total)
Couple of things first.
One, read the first article I reference in my signature block about asking for assistance. Please following the instructions in that article on what and how...
September 10, 2009 at 12:12 am
All I'm saying is that how you build the query is based on what the question asked. The OP indicated (right or wrong) that what he posted as was...
September 9, 2009 at 9:30 pm
I'm going to go with "it depends." Which result set is the correct one? Only the user knows for sure:
IF EXISTS(SELECT name FROM sysobjects WHERE name = N'test_maintable'...
September 9, 2009 at 8:59 pm
Sergiy (9/9/2009)
No, you should leave criteria on "FROM" table in WHERE:WHERE c.contest_id = 2
Only criteria on LEFT JOIN table go into ON.
I think it is a wash either way...
September 9, 2009 at 7:22 pm
CirquedeSQLeil (9/9/2009)
Lynn Pettis (9/9/2009)
September 9, 2009 at 4:18 pm
I find much value in getting published. Having authored 4 articles (2 here on SSC and 2 on SSWUG.ORG), I find it a way to give back to a...
September 9, 2009 at 3:46 pm
george sibbald (9/9/2009)
It comes under the heading of not installing sample databases on a production server for me.
Now this I fully agree with, no sample databases on the production servers.
September 9, 2009 at 3:08 pm
Lynn Pettis (9/9/2009)
lleemon13 (9/9/2009)
September 9, 2009 at 3:01 pm
lleemon13 (9/9/2009)
September 9, 2009 at 10:47 am
Lynn Pettis (9/4/2009)
gugan_ta (9/4/2009)
Hi,Thanks a lot...query works fine. Its saves huge processing time and an alternate to cursor.
Nice to know, but as you were given several alternatives, what is your...
September 9, 2009 at 9:02 am
GilaMonster (9/9/2009)
GilaMonster (9/8/2009)
Only in South Africa - http://pigeonrace2009.co.za/pigeon-race-2009My money's on the pigeon.
The pigeon won. By a significant amount. The download was 4% complete by the time the pigeon arrived
That's sad,...
September 9, 2009 at 8:50 am
I install BOL on production servers. If things are bad enough that I have to be physically on the server to resolve system problems I want BOL there and...
September 9, 2009 at 8:39 am
Laptop - Yes
Desktop - Yes
SQL Books - Yes (Lots of them)
University - Yes (BS Computer Science and Business Adminstration;MA Computer Information Resource...
September 8, 2009 at 9:05 am
Not thinking about the extremely small stat set provided, I answered Query 1. If you look at the where clauses for all four queries you find that the proposed...
September 7, 2009 at 9:40 am
First, I'm glad to see that you finally took the time to post your question on SSC instead of attempting to get help via a PM. As you can...
September 6, 2009 at 1:43 pm
Viewing 15 posts - 18,901 through 18,915 (of 26,490 total)