Viewing 15 posts - 286 through 300 (of 402 total)
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 5, 2012 at 2:06 pm
Third hit on google
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 5, 2012 at 8:38 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 5, 2012 at 7:48 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 5, 2012 at 7:00 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 5, 2012 at 5:41 am
What I was going to say, though, is have you considered full-text indexing
Looking at what's needed so far this seems to be the way to go - again its not...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 5, 2012 at 4:38 am
No probs
You just need to script some insert statements to populate the tables and post those on the thread 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 5, 2012 at 3:56 am
Hi
Hard to help without some more information - could you post some DDL's (table create statements) sample data and expected results please.
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 5, 2012 at 3:06 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 11:05 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 9:12 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 8:45 am
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 8:26 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 7:18 am
SQL_Surfer (4/4/2012)
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 6:35 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 4, 2012 at 5:37 am
Viewing 15 posts - 286 through 300 (of 402 total)