-- Get schema version (this returns numbers like 4.1, 4.2, 4.3, etc.)

SELECT @Version = 'USE ' +@DB_Name+ '
                   SELECT version_number
                   FROM '+ ''+@DB_Name+ '' +'.CQ_DBO.schema_version'
                                    

--Setup SELECT statement to get the version number

IF @Version LIKE '4.%'AND @Version NOT LIKE '4.3%'
BEGIN

     SELECT @PeerReview4x = some stuff                 
     EXEC sp_executesql @PeerReview4x

END

quote:

---

Originally posted by yellowman

I just added an IF statement to a piece of code that I have and something isn't quite right. It doesn't return any results

-- Get schema version (this returns numbers like 4.1, 4.2, 4.3, etc.)

SELECT @Version = 'USE ' +@DB_Name+ '
                   SELECT version_number
                   FROM '+ ''+@DB_Name+ '' +'.CQ_DBO.schema_version'
   
Exec (@Version)                                

--Setup SELECT statement to get the version number

IF @Version LIKE '4.%'AND @Version NOT LIKE '4.3%'
BEGIN

     SELECT @PeerReview4x = some stuff                 
     EXEC sp_executesql @PeerReview4x

END

Now if I pull This out of the IF clause and run it...

SELECT @PeerReview4x = some stuff
EXEC sp_executesql @PeerReview4x

It returns a ton of results. Is that first statement in my IF statement correct or am I missing something? Thanks.

---

IF EXEC(@Version) LIKE '4.%' AND EXEC(@Version) NOT LIKE '4.3%' 

DECLARE @sql NVARCHAR(4000) = 'USE ' +@DB_Name+ '
                   SELECT @VER = version_number
                   FROM '+ ''+@DB_Name+ '' +'.CQ_DBO.schema_version';
DECLARE @version NVARCHAR(32) = N''; 
DECLARE @paramlist NVARCHAR(32) = N'@VER NVARCHAR(32) OUT';
EXEC sp_executesql @stmt = @sql, @params = @paramlist,   @VER = @version OUT;     

-- Get schema version
SELECT @Version = 'USE ' +@DB_Name+ '
                   SELECT version_number
                   FROM '+ ''+@DB_Name+ '' +'.CQ_DBO.schema_version'
                   
SET @ParamDefinition = N'@versionOut nvarchar(200) OUTPUT'                  
EXEC sp_executesql @Version, @ParamDefinition, @versionOut=@Ver OUTPUT
                                  
--Setup SELECT statement to get the version number
IF @Ver LIKE '4.%' AND @Ver NOT LIKE '4.3%'
BEGIN
SELECT @PeerReview4x = some query...

EXEC sp_executesql @PeerReview4x
END