If Exists

• Minnu

  SSCertifiable

  Points: 6451

  More actions

  December 7, 2012 at 12:22 am

  #267289

  Hi Team,

  i've a table "LOC_TEST" with below columns "Text, Rights, Expiry"

  TEXTRIGHTSEXPIRY

  ------ -------- -------

  SalesNULLNULL

  Prod Yes 12-Dec

  Sales Yes 07-Dec

  Output :

  ---------

  Sales :

  Sales : Yes : 07-Dec

  ---

  am using below query... but it is not getting the result.

  please help..........

  IF EXISTS (SELECT 1 FROM LOC_TEST WHERE TEXT ='Sales')

  BEGIN

  IF EXISTS (SELECT 1 FROM LOC_TEST WHERE RIGHTS IS NULL and EXPIRY IS NULL)

  BEGIN

  SELECT @Bgk =(SELECT RTRIM(+ISNULL('Sales','')+' : ' +ISNULL(+CAST(RIGHTS AS VARCHAR(100))+' ',''))

  FROM LOC_TEST WHERE TEXT ='Sales') +CHAR(10)

  END

  ELSE

  IF EXISTS (SELECT 1 from LOC_TEST where EXPIRY IS NULL)

  BEGIN

  SELECT @Bgk=(SELECT RTRIM(+ISNULL('Sales','')+' : ' +ISNULL(+CAST(RIGHTS AS VARCHAR(100))+' ','')) FROM LOC_TEST WHERE TEXT ='Sales') +CHAR(10)

  END

  ELSE

  BEGIN

  SELECT @Bgk=(SELECT 'Sales : ' + RTRIM(RIGHTS) + ' (Expires ' +RTRIM(convert(varchar,EXPIRY,107)) + ')' FROM LOC_TEST WHERE TEXT ='Sales') +CHAR(10)

  END

  END

  print @Bgk

  ************ am Unable to Print the result.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738609

  More actions

  December 7, 2012 at 1:18 am

  #1566487

  What is returned? When you say it is unable to print the result, do you mean there is no value in @Bgk?