Very true... I was probably having flashbacks to "databases" created by people that didn't have a clue what they were doing... so a LOT of cleanup was required... in that...

One way would be to create a stored procedure to do the import/massage of data and then schedule that in a Job. Then if the Job executes on an...

This part looks iffy:

CDate(Fields!Month_Name.Value + " 01, "+Fields!Financial_Year.Value)

Why not use DateSerial(Year,Month,Day)?

Sounds like you could do this with a parameterized query (so a stored procedure) with a join between the two tables in question.

one way...

SELECT [Reason1] AS Reason, [Comments1] AS Comments

FROM [mytable]

UNION ALL

SELECT [Reason2], [Comments2]

FROM [mytable]

WHERE [Reason2] IS NOT NULL

UNION ALL

SELECT [Reason3], [Comments3]

FROM [mytable]

WHERE [Reason3] IS NOT NULL

then you won't have repeating...

One way to do it might be to store the T1 total in a variable, and then just divide by that variable in your T2 tablix.

normally, you would do this WITH ROLLUP in T-SQL.

http://technet.microsoft.com/en-us/library/ms189305(v=sql.90).aspx

What's the purpose of the IF statement? Everything worked fine until I put that in there. Can you base the report on a stored procedure so that the...

Maybe I missed something... Could you explain how you determine what days they're active? The summary isn't hard - I guess I don't understand how you determine active though.

you might have to add a day... the math is slightly off, but this works otherwise:

SELECT name, SUM(DaysActive) AS TotalActiveDays

FROM

(

SELECT name, datediff(d,DateAdded, InactivationDate) AS DaysActive

FROM personstatus) x

GROUP BY name;

One way is to use a numbers or Tally table. Here is a handy function:

http://www.sqlservercentral.com/scripts/tally/100338/

Then you can use that to calculate intervals and add to some date:

DECLARE @StartDate DATE...

Yes, you can... Must be getting myopic... can't see the obvious answer right in front of me. The hassle with sorting with parameters is that it appears that you...

or this... http://sqlblog.com/blogs/stacia_misner/archive/2011/03/16/34197.aspx

When ever a new event is fetched, i need send the data to the mail ids on the same.

You can't add a trigger to a SELECT statement. How is...

let your fingers do the walking...

http://www.sqlservercentral.com/blogs/juggling_with_sql/2011/12/26/dynamic-sorting-in-ssrs/

Tried it - works a charm. The author even covers ASC/DESC sorts.

This is how I did it:

1. Create your four parameters. I did...