Viewing 15 posts - 20,236 through 20,250 (of 26,484 total)
Florian Reischl (6/26/2009)
Jeff Moden (6/26/2009)
Florian Reischl (6/26/2009)
Lynn Pettis (6/25/2009)
I only hope he reads the blog, but I doubt it.I hope (s)he did. Next posts have been really okay.
Heh... I'm not...
June 26, 2009 at 9:57 am
I don't see anything in the your query that indicates that you have a triangular join. All criteria are using equality comparisions.
June 26, 2009 at 9:49 am
Going to need some things from you. First, if you haven't already, please read the first article I reference below in my signature block about asking for assistance.
We need...
June 26, 2009 at 9:44 am
Just MHO, it is probably by design as recursion by nature is a loop.
June 26, 2009 at 9:20 am
Sinshith S Anand (6/26/2009)
Hello Friends,I made necessary changes on the program. Now it will work smoothly..I will be careful from next time
Okay, this is a two way...
June 26, 2009 at 9:06 am
Paul White (6/26/2009)
Steve Jones - Editor (6/26/2009)
Alright, I'm leaving for a week. Behave yourselves on the thread.
Have fun whatever you're doing. I'm sure we'll all try hard to be...
June 26, 2009 at 8:59 am
On a totally different subject, but something you should starting thining about. You need to get away from using three (and possibly) four part naming conventions iin your SELECT...
June 26, 2009 at 8:57 am
Is this what you are looking for?
--dateStart and dateEnd
--22/10/2008 19/01/2009
--
--and IN ONE query i'd like to have :
--
--- the total of day BETWEEN the two date
--- the total day...
June 26, 2009 at 8:47 am
Eswin (6/26/2009)
Lynn Pettis (6/25/2009)
Have you read the articles that I asked you to read yet in my post above? If not, please go read them.
I know he is slow...
June 26, 2009 at 7:44 am
Sinshith S Anand (6/26/2009)
Hi friends,I am really happy to see Lots of ideas....You can visit my blog also
http://sinshith.wordpress.com/
And let me know your comments...I started writing blog recently
You still...
June 26, 2009 at 7:40 am
Table variables are just like temporary tables, just light weight. Both are created in tempdb, table variable just have a few more restrictions. They do not have statistics...
June 26, 2009 at 7:37 am
gururajan (6/9/2009)
I want use Cursors in my query. How to use the cursors in sql2000. i want to some eample with any other link for...
June 26, 2009 at 12:39 am
DBA with OCD (6/25/2009)
- Are you trying to save the 90 percent of the rows you need to get rid of?
...
June 26, 2009 at 12:21 am
Could you explain your problem in a little more detail and perhaps show us what you are looking for with a couple of examples?
Your initial post is a little vaque...
June 26, 2009 at 12:14 am
And then, based on the other thread where it looks like you want the names from TableA with no match in TableB:
SELECT
tA.Id,
tA.Name
FROM
...
June 26, 2009 at 12:11 am
Viewing 15 posts - 20,236 through 20,250 (of 26,484 total)