Declare

• longingfriend

  SSC Veteran

  Points: 222

  More actions

  January 26, 2004 at 1:19 pm

  #81881

  declare @EndDate dateTime;

  select max(Date) as D1 from Table1;

  set @EndDate = D1

  When I am executing this I am getting error

  "Invalid column name 'D1'."

  Whats wrong ?

   

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  January 26, 2004 at 1:48 pm

  #491671

  SELECT @EndDate = MAX([Date])

  FROM Table1;

  
  
  --Jonathan