Post reply

Invalid Column Name

  • November 2, 2007 at 5:55 pm

    #183596

    -

  • November 2, 2007 at 7:15 pm

    #747953

    syntax wise, there was an extra single quote near SessionComplete, and the @startDate/E@Enddate were not declared inte snippet you posted. no problem there.

    the statement you pasted only references one table, ApplicationLog.

    could you be refering to coulumns from a table you left out of the join, but expect to be there?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 3, 2007 at 4:24 pm

    #748021

    -

  • November 5, 2007 at 3:58 pm

    #748450

    Did removing the ' fix the problem? I tried creating an sp using your code and it worked just fine once I removed the extra '.

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

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

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