in the end I narrowed it down to just 25 reports that needed fixing (urgently) so I have done it the long way round. These fell into two categories....

@BWFC

Yup, It sounds dangerous to me too, hence why I was asking the question 😀

I am inheriting these reports from someone else, and we are effectively using the ReportServer database...

Another option would be to turn the query into dynamic SQL and append

'WHERE searchValue in (''' + @inParameterString +''')'

The @inParameterString is them passed in as "A", "B" or "A','B"

Which will...

Sounds like a classic Third Normal Form (3NF) problem. You need to look at the entities and put each one into a separate table with a unique ID (primary...

Its late on a Fridyay.

As Drew pointed out, you are only selecting data from one table so there should be no need to reference it twice

SELECT

...

my 2 cents...

CTEs make the code easier to read because you can encapsulate complicated logic away from the main query and generally you can unit test the CTE as it...

Having spent some time scratching my head, and as a result of a number of folks looking at this post but with no replies, I am posting the solution.

=ROUND(SUM(

IIF(

SUM(Fields!OperativeCalcPay.Value,"rgJobNumb")=0,

0,

IIF(

(

Fields!TSK_SORCode.Value="NOACCESS" OR...

Thanks Chris,

Looking again at the code, I had a lightbulb moment and realised that the question I had posed was a correct assumption confirmed by your linked post.

When you use...

Hi.

Welcome to the forums and to SQL.

The short answer is no you can't. SQL returns sets of data which are essentialy unordered. The row number you are seeing...

I don't know if I have misread the OPs requirements or if you guys have all missed the point 😀

I think the development team want the data from production, but...

as lowel says, only use his if you only have positive values, you could do

ABS(Cost1) + ABS(Cost2) + ABS(Cost3) + ABS(Cost4) >0

This will protect against negative...

Hi Tina,

Welcome to the forums.

You don't make it clear from your question whether you NEED to replicate the data from the read-only server to the report server, or just...

I would just like to add, that if you are inserting data into a table that is owned and manged by the software vendor without going through their application you...

I don't think anyone has actually managed to get the relevant information out of the OP or provide a solution. [difficult to do one without the other]

It seems reasonable without...

Or this

SELECT 1264,REPLACE( isnull(col1, '')+' - '+isnull(col2, '')

+' - '+isnull(col3, '')+' - '+isnull(col4, '')+' - '

+isnull(col5, '')+' - '+isnull(col6, ''),' - - ',' - ')

FROM unify WHERE id=100