Post reply

Error on sql

  • June 20, 2011 at 7:25 am

    #252211

    Hello, I get these error:

    Column qualifier or table "Tbl1003" undefined

  • June 20, 2011 at 1:09 pm

    #1341413

    To be as precise as the question is: most probably an issue with the query. 😉

    If you decide to post a more detailed question you might get a more detailed answer, too.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • June 20, 2011 at 10:38 pm

    #1341597

    Krasavita (6/20/2011)

    Hello, I get these error:

    Column qualifier or table "Tbl1003" undefined

    I think you have not specified the column name for expression in your query.

    For example:

    select name, physical_name, size/128 as 'Size_In_MB' from sys.database_files

    In the above query, I have an expression size/128. For this I have used column name 'Size_In_MB'.

    Check your query and see whether you have any such expression for which column name is not specified.

Viewing 3 posts - 1 through 2 (of 2 total)

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