Post reply

How Combine two separate IF statements into One IF

  • July 25, 2012 at 8:07 am

    #261615

    IF EXISTS (SELECT 1 from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'r' and COLUMN_NAME = y )

    IF charindex('k',@hdr_where)=0

    INTO

    IF EXISTS ((SELECT 1 from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'r' and COLUMN_NAME = y ) and charindex('k',@hdr_where)=0)

  • July 25, 2012 at 8:27 am

    #1517389

    Nearly there:

    IF (EXISTS (SELECT 1 from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'r' and COLUMN_NAME = y ) and

    (select charindex('k',@hdr_where))=0)

  • July 25, 2012 at 8:55 am

    #1517411

    thanks for the reply !!!

  • July 26, 2012 at 9:30 am

    #1518023

    No problem!

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

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