Post reply

why does the table alias

  • May 9, 2013 at 3:28 pm

    #293189

    make this crash?

    select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t

    it works fine without the t?

    thanks a lot

  • May 9, 2013 at 3:29 pm

    #1613991

    drew.georgopulos (5/9/2013)

    make this crash?

    select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t

    it works fine without the t?

    thanks a lot

    Care to give a more in depth explainatioin? I'm lost as to the questioin.

  • May 9, 2013 at 3:32 pm

    #1613993

    drew.georgopulos (5/9/2013)

    make this crash?

    select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t

    it works fine without the t?

    thanks a lot

    What's the exact error? Can you copy/paste it from SSMS please?

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • May 9, 2013 at 3:36 pm

    #1613998

    drew.georgopulos (5/9/2013)

    make this crash?

    select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t

    it works fine without the t?

    thanks a lot

    Because you have the table alias in the wrong place:

    select t.cbclaim from [dev].[stage].[dbo].[claimsview] t with(noexpand)

  • May 9, 2013 at 3:38 pm

    #1614000

    Lynn Pettis (5/9/2013)

    drew.georgopulos (5/9/2013)

    make this crash?

    select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t

    it works fine without the t?

    thanks a lot

    Because you have the table alias in the wrong place:

    select t.cbclaim from [dev].[stage].[dbo].[claimsview] t with(noexpand)

    Heh, whoops, I missed that when I looked at it. My eyes glazed right over that.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • May 9, 2013 at 3:44 pm

    #1614002

    Evil Kraig F (5/9/2013)

    Lynn Pettis (5/9/2013)

    drew.georgopulos (5/9/2013)

    make this crash?

    select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t

    it works fine without the t?

    thanks a lot

    Because you have the table alias in the wrong place:

    select t.cbclaim from [dev].[stage].[dbo].[claimsview] t with(noexpand)

    Heh, whoops, I missed that when I looked at it. My eyes glazed right over that.

    I checked the syntax in BOL. I don't use table hints very often at all.

  • May 9, 2013 at 6:50 pm

    #1614036

    omg i feel like such a dunce...

    I apologize for bringing such a kluncker to the list and thank you profusely for catching it for me.

  • May 9, 2013 at 6:57 pm

    #1614038

    drew.georgopulos (5/9/2013)

    omg i feel like such a dunce...

    I apologize for bringing such a kluncker to the list and thank you profusely for catching it for me.

    Don't sweat it. Most of us have people who can check us in the cube next door when we're headbanging on a 'pre-coffee' problem. I've certainly asked a few of those myself. 🙂

    Happy to have tried to help.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • May 10, 2013 at 5:51 am

    #1614149

    Funny you should say that...I used to be part of a cube culture, but due to familial circumstances, my employer allowed me to continue working out of state as a remote employee, so i really miss that collaboration and excitement in mutual discovery...its part of what makes this list so invaluable to me.

    I also want you to know that i know this is not the first time you and Lynn have stepped up to help me, not to mention Jeff, Steve and Gail, who are big repeat helpers, as well as others who have offered help, and to express my appreciation for that...its an oasis that reminds me of the comradery of the Compuserve days, almost like the cube next door 🙂

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply