Forum Replies Created

Viewing 15 posts - 5,986 through 6,000 (of 10,144 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (7/30/2012)

    ChrisM@Work (7/30/2012)

    GilaMonster (7/30/2012)

    ChrisM@Work (7/30/2012)

    Someone's just posted a reply to a request from Gail and my best guess is that she's fallen of her chair laughing. You're a bad lady,...

    July 30, 2012 at 5:40 am

    #1519097

  • RE: Are the posted questions getting worse?

    GilaMonster (7/30/2012)

    ChrisM@Work (7/30/2012)

    Someone's just posted a reply to a request from Gail and my best guess is that she's fallen of her chair laughing. You're a bad lady, Gail. ...

    July 30, 2012 at 5:05 am

    #1519089

  • RE: Are the posted questions getting worse?

    Someone's just posted a reply to a request from Gail and my best guess is that she's fallen of her chair laughing. You're a bad lady, Gail. 😎

    July 30, 2012 at 4:49 am

    #1519081

  • RE: Order without Order by

    danielfountain (7/30/2012)

    Phil Parkin (7/30/2012)

    Doesn't the execution plan give you any clues as to which index it is using?

    Thats what i was hoping - but still cant see it. Dont...

    July 30, 2012 at 4:33 am

    #1519078

  • RE: any order max, min in simple way

    aspanwar27 (7/23/2012)

    Comments posted to this topic are about the item <A HREF="/scripts/92227/">any order max, min in simple way</A>

    Its not clear what you're trying to do. We use these queries to...

    July 30, 2012 at 4:30 am

    #1519077

  • RE: Order without Order by

    danielfountain (7/30/2012)

    Thanks for the explainations.

    Unfortunately i do have to worry about it. Obviously the execution plan hasnt changed in a while as people have got used to the order....

    July 30, 2012 at 4:08 am

    #1519062

  • RE: Join operation over String non-index fields

    You're welcome Paul.

    paul.pauldj54 (7/30/2012)

    ...the business keys always hold numeric values and they are defined as Strings...

    A column containing values with leading zero's can only be a string.

    ...For a fact table...

    July 30, 2012 at 4:04 am

    #1519060

  • RE: NonClustered index on Clustered table

    Brandie Tarvin (7/27/2012)

    SQL Server has pointers that tell it which indexes refer to which records. Your James names with different IDs won't get lost. However, if you don't have your...

    July 30, 2012 at 3:29 am

    #1519049

  • RE: Case Statement Problem

    schauhan13 (7/29/2012)

    Sorry if I was unclear , when I try to run this stored procedure, it gives me error that 'Incorrect syntax near Case'

    Code is much easier to debug outside...

    July 30, 2012 at 3:21 am

    #1519042

  • RE: Order without Order by

    Hi Daniel

    Without an ORDER BY, SQL Server will return the results in whatever order they fall out of the execution plan. If the plan changes - and there are many...

    July 30, 2012 at 3:14 am

    #1519039

  • RE: CTE in Infinite Loop

    santlou (7/30/2012)

    I have a CTE that is in a loop. I need to limit the recursive query so that data that has already been selected is not selected again.

    ...To...

    July 30, 2012 at 3:05 am

    #1519035

  • RE: Join operation over String non-index fields

    Hi Paul

    Apart from the fact that a simple join between the two tables on konsumfeld

    SELECT ...

    FROM Tableb b

    LEFT JOIN Tablea a ON a.konsumfeld = b.konsumfeld

    would eliminate rows from tableb...

    July 30, 2012 at 2:44 am

    #1519029

  • RE: Recursive Golf to-par calculation

    pixelwiz (7/27/2012)

    Hi Sean, you're right. I know. It's just been driving me nuts for 2 days and I can't even figure out how to explain it right. ...

    July 27, 2012 at 9:39 am

    #1518598

  • RE: Recursive Golf to-par calculation

    Sean's nailed it. You've got data that you can see and which you have already queried in an attempt to get the results - we can't see it, we can...

    July 27, 2012 at 9:25 am

    #1518586

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (7/27/2012)

    Jeff Moden (7/27/2012)

    SQL Kiwi (7/27/2012)

    Jeff Moden (7/27/2012)

    I had an ephipany that just hit me like a ton of bricks....

    I see! Well that explains it

    ...

    Man! I...

    July 27, 2012 at 9:19 am

    #1518583

Viewing 15 posts - 5,986 through 6,000 (of 10,144 total)