if statement

• Ittech03

  SSC Rookie

  Points: 42

  More actions

  May 19, 2010 at 1:09 pm

  #232673

  Afternoon,

  Trying to use an if statement to return a date plus 3 months If I take out the th if statement then returns fine but I wast to use the check box.

  declare @checkbox char(1)

  declare @DisplayDate varchar(80)

  declare @sd datetime

  set @checkbox = (select att1 from pdt_first_time_homebuyers_Club_View where client_id = @client_id and pd_id = @pd_id)

  set @DisplayDate = (select atdate1 from pdt_first_time_homebuyers_Club_View where client_id = @client_id and pd_id = @pd_id)

  if @checkbox = 1

  begin

  select @sd

  set @displayDate = dateadd(mm,3, @sd) --(CONVERT(varchar(50),dateadd(mm,3,@sd),101))

  end

  select coalesce (@displaydate,'')

• Steve Cullen

  SSCertifiable

  Points: 5598

  More actions

  May 19, 2010 at 1:30 pm

  #1169695

  I suspect you're failing your if test. Check the value of your variables:

  set @checkbox = (select att1 from pdt_first_time_homebuyers_Club_View where client_id = @client_id and pd_id = @pd_id)

  select @checkbox [@checkbox], @Client_id [@Client_id], @pd_id [@pd_id]

  Converting oxygen into carbon dioxide, since 1955.

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  May 19, 2010 at 3:16 pm

  #1169781

  Where do you assign any value to @sd?

  _____________
  Code for TallyGenerator

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  May 19, 2010 at 3:25 pm

  #1169784

  And it should be all in one SELECT statement:

  select CASE WHEN att1 = 1 THEN CONVERT(varchar(50), dateadd (mm, 3, @sd ), 101)

  ELSE atdate1

  END displayDate

  FROM pdt_first_time_homebuyers_Club_View

  where client_id = @client_id and pd_id = @pd_id

  _____________
  Code for TallyGenerator