I posted this question (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_27655535.html
) today regarding using a like in a join for SQL. The solution provided I was able to use - and get it to work in SQL 2005.
However, when I put it into SSRS 2005 I get errors and it isn't happy when ever I posted the code for the union.
The code (section) that works looks like:
left outer join [ServerName].HPD_HelpDesk HPD
on HPD.Summary like '%' + caption + '%'
Whenever I add this to my SSRS query it barfs.
The error looks like:
Could not generate a list of fields for the query.
Check the query syntax, or click Refresh Fields on the query toolbar.
Implicit conversion from data type sql_variant to int is not allowed. Use the CONVERT function to run this query.