Search results for query: *

Solved it - sort of Created another measure WITH MEMBER [Measures].[RowCount] AS 'Descendants([My Dimension].[All]).Count' Then used this in the report First(Fields!RowCount.Value, "ReportingPeriodReportingPeriod") to return the actual number of rows in the result set... There has to be...

Hi, I am having a problem with the counting of rows in Reporting Services hierarchical result set when using a cube as a data source. I am trying to get my multi-valued report parameter to only display 'All' when I use the '(Select All)' option. This is the expression (which works in all my...

Hi, UNION does a select distinct, if you use UNION ALL instead then you will get both results sets back - with duplicates.

Try this SELECT Division, Team, COUNT(*) AS GP, SUM(ScoreFor) AS TotalGoalsFor, SUM(ScoreAgainst) AS TotalGoalsAgainst, SUM(CASE WHEN ScoreFor > ScoreAgainst THEN 1 ELSE 0 END) AS Wins, SUM(CASE WHEN...

Yes, my apologies, you are quite correct, I completely missed that bit - still like to see what happens when SP1 is called from SP2 without any insert...

This is merely restating what others have described above (so all of you please forgive me for this!) but I guess your next step would be to run SP2 with just Declare @Today Varchar (12) Declare @Entity Varchar (5) Declare @DBName Varchar (5) Set @Today = GetDate() Set @Entity = 'EM1' Set...

...and if you have SQL 2005 then you can use a CTE (untested code)... ;with recordCTE (id, record_date, record_value, row_num) as ( select id, record_date, record_value, row_number() over (partition by id order by record_date) from mytable ) select id, record_date, record_value from ( select...

What do your execution plans look like when you run SP1 by itself and then via a call from SP2 - are they different ? Are you using defaults for SP1's parameters, if so are they typical values and are these values the same as those passed in when you call it from SP2 ?

Perhaps there are 26460 rows in B that do not exist in A ?

My apologies, I posted the code before the analysis. [select * into TransTable from MasterTable where 0=1] will not generate identical tables, e.g. the TransTable will not have the same PK constraint as the MasterTable using this method therefore I thought of the possibility of the TransTable...

Just a thought. What happens when you issue this ? select PKField, count(PKField) from TransTable group by PKField having count(PKField) > 1

Thanks guys for pointing me in the right direction... hh

Hi all, I would like to be able to see how much time was spent on running each task within a package, is there any way to easily export this information from SSIS Designer into a text file after running the package so I can review this information at a later date ? thanks

As you can see I have changed my name from unclejimbob to haroldholt to reflect the fact that this will be my last post in this forum due to my new non-InterBase status. Good luck with InterBase.

Sure, you need to terminate the proc, IB usually uses the caret ('^') by default so something like this should work: CREATE TRIGGER GAMES FOR CUSTNUM BEFORE INSERT AS BEGIN NEW.CUSTNUM = GEN_ID(SetKey, 1); END ^ You can also set your own terminator if you like using SET TERM. "what's...

Why are you returning two different data types, a string and an int ? The iif evaluates better if it sees this... ((Fields!FieldNameDescription.Value = "ABC") AND (Fields!ReportFieldValue <> Nothing)), don't ask me why, I just tried a perfectly good set of ORs in some similar code and it would...

Many thanks, this has now been added to my ever-expanding SQL expressions toolbox :-) left(name, patindex('%[0-9]%',name) - 1), Right('0000000000' + substring(name, patindex('%[0-9]%',name), 11), 11)

What about taking the other tack and altering the confirm column so that it becomes a meaningful value in the result set that you can then report on ? e.g. (assuming Confirm datatype is a string) something like SELECT COALESCE(t2.Confirm,'Y') AS Confirm FROM Table1 t1 LEFT JOIN Table2 t2 ON...

Thanks for this - dos and don'ts are fine, without wishing to seem ungrateful I guess having worked with SSRS for the past 4 years or so I know pretty much all of these by now (my starting point being www.ssw.com.au) and I have a standard set of templates which I now use when I move from...

I had a similar issue, I resolved it by creating another table for the report footer using the same dataset I used for the report itself. In your case this would mean creating a second table with 2 groupings, first by division and then by sub division and creating the appropriate aggregates and...