as your dividing by ytd2011 thats the one you need to check is 0, not ytd2012, missed that at first look

=IIF((Fields!TG___2012_YTD.Value) = 0,0,

((Fields!TG___2012_YTD.Value) - (Fields!TG___2011_YTD.Value)/Fields!TG___2011_YTD.Value) *100)

the problem on the above is the second 0 as your still passing in 0 to divide by, change it to 1 so that...

you can go into the login at the server level in the security/logins folder to see what server level securables the login has, then at the DB level in security/users...

another way to do it

CREATE TABLE [dbo].[tab1](

[NUM] [int] NULL,

[bdDQLinkID] [nvarchar](255) NULL,

[bdDQID] [nvarchar](255) NULL,

[bdID] [int] NOT NULL,

[bdSalutation] [nvarchar](255) NULL,

[bdFirstName] [nvarchar](255) NULL,

[bdMiddleName] [nvarchar](255) NULL,

[bdSurname] [nvarchar](255) NULL,

[bdFullName] [nvarchar](255) NULL,

[bdTitle] [nvarchar](255) NULL,

[bdPhoneNumber] [nvarchar](255) NULL,

[bdEmail]...

This will give you a number in the first column based on how many times DQLinkID appears in the result set

SELECT

ROW_NUMBER() OVER (PARTITION BY bd.DQLinkID ORDER BY bd.DQLinkID) AS...

can put it anywhere in the query you want

SELECT

ROW_NUMBER() OVER (PARTITION BY bd.DQLinkID ORDER BY bd.DQLinkID) AS NumMatches,

bd.DQLinkID, ...............................

ROW_NUMBER () OVER(...........) AS RowNum where you put in the over clause either a partitioning field and an ordering field or just an ordering field.

in your case you will...

ok try shrinking in small chunks as this can sometimes be faster than shrinking in one big go

also I take it you are fully aware that you will need to...

you just need to do a row_number based on the bd.DQLinkID then and it will say if its 1,2,3,4,5,6 rows for that particular DQLinkID which will give you a starting...

the issue is down to the DQID's and registrations being different for the same DQLinkID and your group by is working as it should as it cannot group 416 into...

take a look at the Create Some Data section of the article, or dump out the data into 2 excel files so we can import it

can you post DDL and sample data along with your expected results as per the 2nd link in my signature block?

and what about free space?

sorry but it might just be me reading the problem, but what is the actual problem?

has the service account used to run SSRS expired and needs a password change?

have any...

Rod at work (3/27/2012)

---

I believe I may have been rude with the initial post of this thread. If in fact you found my initial post to be rude, then...