Invalid Column Name

• orangez

  SSC-Addicted

  Points: 427

  More actions

  November 2, 2007 at 5:55 pm

  #183596

  -

• Lowell

  SSC Guru

  Points: 323518

  More actions

  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!

• orangez

  SSC-Addicted

  Points: 427

  More actions

  November 3, 2007 at 4:24 pm

  #748021

  -

• Kenneth.Fisher

  SSC-Insane

  Points: 20406

  More actions

  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]