declare @ploginname varchar(max)
declare @sqlcmd nvarchar(max)
declare @vid numeric(10) 
declare @vpass varchar(max)


BEGIN 

SET @PLOGINNAME = 'USER1'; 
 
 SELECT @VID = PREVPASSNOTUSED
 FROM QC_MASTER_FINAL.DBO.QM_POLICY_PARAMETER 
 
 
 set @vpass  = 'SASASASAS8'
 
SET @SQLCMD =  ';WITH CTE AS
(
SELECT  PW_NO = 1, PASSWORD FROM QM_USER1 WHERE LOGINNAME  =  ' + '''' + @PLOGINNAME + ''''+'   UNION ALL
SELECT  PW_NO = 2, PASSWORD = PASSWORD1  FROM QM_USER1  WHERE LOGINNAME = ' + '''' + @PLOGINNAME + '''' + '  UNION ALL
SELECT  PW_NO = 3, PASSWORD = PASSWORD2  FROM QM_USER1  WHERE LOGINNAME = ' + '''' +  @PLOGINNAME + '''' + '  UNION ALL
SELECT  PW_NO = 4, PASSWORD = PASSWORD3  FROM QM_USER1  WHERE LOGINNAME = ' + ''''  +  @PLOGINNAME + '''' + ' UNION ALL 
SELECT  PW_NO = 5, PASSWORD = PASSWORD4  FROM QM_USER1  WHERE LOGINNAME = ' + '''' +   @PLOGINNAME + '''' + '  UNION ALL
SELECT  PW_NO = 6, PASSWORD = PASSWORD5  FROM QM_USER1  WHERE LOGINNAME =  '  + '''' + @PLOGINNAME  + '''' + ' UNION ALL
SELECT  PW_NO = 7, PASSWORD = PASSWORD6  FROM QM_USER1  WHERE LOGINNAME = ' + ''''  +  @PLOGINNAME +  '''' + ' UNION ALL
SELECT  PW_NO = 8, PASSWORD = PASSWORD7  FROM QM_USER1  WHERE LOGINNAME =  ' + '''' + @PLOGINNAME  + '''' + ' UNION ALL
SELECT  PW_NO = 9, PASSWORD = PASSWORD8  FROM QM_USER1  WHERE LOGINNAME = ' + '''' +  @PLOGINNAME + '''' + '  
)
SELECT top  ' +  CAST(@VID as varchar(max)) + ' PASSWORD  FROM CTE order by PW_NO ' ;  
     
   EXEC (@SQLCMD)
     
     IF  @VPASS  NOT   IN  (@SQLCMD) 
		BEGIN 

		PRINT 'ok'
     
     END 
  
   
END