Forum Replies Created

Viewing 15 posts - 781 through 795 (of 2,010 total)

  • RE: Order of tables in a from line

    Jeffrey Williams (7/10/2009)


    I could see a different execution plan being generated - but not different results. Both queries should return the same results and the fact that they are...

  • RE: Order of tables in a from line

    egads! apparently I just found another bug with the code="SQL" windows....

    here they are in plain text...

    Q1

    SELECT *

    FROM Tab1 t1

    INNER JOIN Tab2 t2

    ON t1.[Identifier] = t2.[Identifier]

    INNER JOIN...

  • RE: Order of tables in a from line

    No, haven't flushed the cache, I have only been able to id the problem on my Prod instance at the moment, I'm waiting on a maintenance window this weekend to...

  • RE: Order of tables in a from line

    Lynn Pettis (7/10/2009)


    Lynn Pettis (7/10/2009)


    That's because we don't have the data to see what is going on behind the scenes. I'll wait and see what Luke comes back with...

  • RE: Order of tables in a from line

    Right, that's my issue with it also. At first I thought it was the where vs join issue... but all fo the filtering is being done in the where...

  • RE: Order of tables in a from line

    Positive, if I run both queries in the same batch, I get 2 resultsets, one that's blank and one with 2 records... It's not that I'm dealing with 100's...

  • RE: Are the posted questions getting worse?

    Kit G (7/9/2009)


    GilaMonster (7/9/2009)


    Kit G (7/9/2009)


    By the way Steve, I'm not getting e-mail notifications of postings. Not sure if others are still experiencing this.

    I suspect the lack of emails...

  • RE: Posting a reply throws error

    Same experience here. Yesterday right after the outage, posting a reply gave me the full error details. I didn't save them as I figured the site wasn't all...

  • RE: Scripts to create AdventureWorks

    I've not actually seen the scripts anywhere, also only the .MSIs. What kinds of issues are you seeing with the MSIs? Perhaps we can help?

    -Luke.

  • RE: Are the posted questions getting worse?

    OK, who tripped over the power cord!

  • RE: SSC Not askign me to login in

    Perhaps it's not a cookies thing, but I suspect that it is... Currently I'm using FF3.0.11 WinXPsp3, but the same thing happens at home with Vista and at other locations...

  • RE: Are the posted questions getting worse?

    The really sad thing is I had to really expend a fair amount of mental energy to try to understand what half of those words were...

    Sheesh..

  • RE: SSC Not askign me to login in

    Sorry I just re-read my original post, that should have been the past few weeks... It seems to happen when a) I'm on a PC I've never used before, or...

  • RE: SSRS skipping records

    The body of your report looks OK. Can you upload the entire Rdl? That may be more helpful.

    Thanks,

    -Luke.

  • RE: SSRS skipping records

    Have a look at the attached XML. It's from the Body of the RDL I wrote that does exactly what you are requesting. check for differences between what...

Viewing 15 posts - 781 through 795 (of 2,010 total)