>Hi All -
>
>My query is built with an SQL string that is executed by separate command.

>declare @SQL nvarchar(max), @Columns VARCHAR(max)
>
>set @columns = stuff((
>select ', ' + quotename(FundType) 
>FROM ( 
>SELECT FundType 
>FROM LookupFundtypes P ) S
>WHERE FundType <> ''
>ORDER BY FundType 
>FOR XML PATH('')), 1,2,'') 
>
>print @Columns
>
>set @SQL = 
>';with cte as (
>SELECT * 
>FROM (
>SELECT sponsor, fundtype, amount
>from TIP_ApprovedFunding f
>inner join TIP_Projects p on p.TipID = f.TipID
>where p.ApprovedStatus = [Active] 
> )
> select * from cte  
> PIVOT
> (
>   Sum(amount)
>   FOR [FundType]
>   IN (' + @Columns + ')
> ) AS PivotTableAlias'
> 
>execute sp_ExecuteSQL @SQL

>Note that it attempts to embed a string 'Active' inside the main sql string. This is erroring out with a message of 'incorrect syntax near SELECT'. I am fairly sure the problem is delineating the word 'Active'. Can someone tell me how to do this, or do you see something else wrong with the query?
>
>Thanks UT is great!

It should be where p.ApprovedStatus = ''Active'' (double single quote).

BTW, since in your case you don't use parameters, you can do

execute (@SQL)