Thanks for the additional info mate! I've never got my head around pivioting, but you've provided a great working example for me to give it a go 🙂

- DamienB

aah I see, I think I should make up a new acronym: "RTFQ", I should have paid better attention to your result set 🙂

I still dont understand your reference to...

Hi mate,

Try the UNION ALL command between the select statements:

declare @var table

(id varchar(5), name varchar(20), marks1, marks2, marks3)

Select col1, col2, col3 from table1

UNION ALL

Select col1, col2, col3 from table2

UNION ALL

Select...

For anyone trying to solve a similar problem, this is the tested working code that I am using:

declare @subj char(5)

set @subj = '01mat'

update SU

setsu.strand_heading01 = su1.strand_heading01,

su.strand01 = su1.strand01,

su.strand_heading02 = su1.strand_heading02,

su.strand02...

Thank you for the reply 🙂

That's a clever way to do it, thanks for the help.

Seeing as you are hard up for an answer, I'll offer this; perhaps you could remove the other undesirable apps from machines in your organisation and not grant users installation...

Interesting that you're using SRS2005 and I'm on SRS2000 for anyone else experiencing this problem.

I was thinking that I might be experiencing rogue issues because I was using an older...

G'day all 🙂

A bit bad form getting back onto this so late, no disrespect intended to everyone that's chipped in to help! I'm sure I could get a bit of...

Hi Mate,

I've replicated your issue, but unfortunately not been able to produce an easy answer.. I wouldn't be surprised if this is the wrong way to do it, but could...

G'day mate,

I'm not sure where your grand total is. Maybe this is some flash feature that I haven't seen in SRS2k5? I am using 2k..

I have just loaded one of...

G'day mate,

Thank you very much for getting me started! I had to alter the code because I'm using SQL2000.

alter Proc spCreate_MultiDBView As

declare

It is pretty long winded so I'll include two databases so it will just be a copy and paste job across the rest of them.

CREATE TABLE [ceo_dbs] (

[db_id] [int] NULL...

Hi Gail 🙂

Thanks for the quick reply! Maybe I should have been more specific... I need help actually writing the code! >.<

- Damien

G'day mate,

I'm not sure of your specific problem, but one place to maybe get a more verbose error might be:

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles

I am trying to work my way...

Good morning guys,

I found this document which explains things very well;

http://msdn.microsoft.com/en-us/library/aa237461(SQL.80).aspx

This copes with multiple recipients, different formats, different priorities etc etc.

Hope this helps 🙂

- Damien