In short yep you can use all of the above in SSRS - although not sure what you mean by excel? They are different apps do you mean will it...

Third hit on google

Fragmentation[/url]

Slight amendment to the SQL:

DECLARE

@SearchString VARCHAR (8000)

SET

@SearchString = 'WAREHOUSE MOSHALASHI NEW IPAJA'

SELECT

AGT.Name

,AGT.Mobile1

,P.Description

,P.Price

,L.Name

FROM

dbo.rhc_Properties AS P

LEFT JOIN dbo.rhc_Agents AS AGT

ON P.AgentID = AGT.AgentID

LEFT JOIN...

No problem 🙂

As mentioned before I would seriously look into the full text search option.

I would also not run this on large tables either as if a row has 30...

There may be a million different better and more efficient ways of doing this however until one is suggested give this a shot (and a through test :-D)

DECLARE

@SearchString VARCHAR...

Looking at what's needed so far this seems to be the way to go - again its not...

No probs

You just need to script some insert statements to populate the tables and post those on the thread 🙂

Hi

Hard to help without some more information - could you post some DDL's (table create statements) sample data and expected results please.

Andy

I agree it does seem likes a bit of a hack!

Yes you could do that the only reason I suggested a dataset is I feel its a little more visable...

Ahh I think I see your problem.

I think that you will have to add another Total row in your matrix table and in the expression editor use the average expression:

AVG(Fields!YourField)

This...

Hi

There may be a better way but you could create 2 datasets FinancialStart and FinancialEnd and write a SQL statement i.e.

FinancialStart

SELECT CAST(DATEADD(YEAR,-1,'01-04-'+CONVERT(VARCHAR(4),YEAR(GETDATE()))) AS DATE) --01-04-2011

FinancialEnd

SELECT CAST('30-04-'+CONVERT(VARCHAR(4),YEAR(GETDATE())) AS DATE) --30-04-2012

Then...

SSRS Average Function

If the values are contained in one string separated by commas rather than in separate rows you could try something like this using Jeff's String Splitter

CREATE TABLE #temp

(TextValue VARCHAR (500))

INSERT...

SQL_Surfer (4/4/2012)

---

PATINDEX is not going to work. And temp table solution is also not going to work. Since, those values are (list of strings) are in table and can contain...

If your getting this error it sounds like your parameter datasets are dependant - the only way I am aware to remove this is to edit the SQL for the...