Why would you want such a thing ?

Imagine if it 'auto-generated' a name such as 'col1'...

Richard McSharry (1/19/2010)

THE PROBLEM

This is an NHS problem related to patient treatments costs for GP's. I need to calculate, for each month of the year, for each General Practice, the...

Yes , have a database thats total size less than available ram on the machine.

Can you clarify your question further ?

For the record its best to keep all conversations in the public forum, other people may ( and probably will ) spot issues i miss.

You are using a ##...

So .. something like this ?

Create table Machine

(

MachineId integer,

AttributeId integer)

go

Create table MachineAttributes

(

MachineId integer,

AttributeId integer)

go

insert into Machine values(1,1)

insert into Machine values(1,2)

insert into Machine values(1,3)

insert into Machine values(1,4)

insert into Machine values(1,5)

insert into...

Untested but should be fine.

with cteRequiredValues

as

(

select 1 as value

union all

select 33

)

Select MachineID

from MachineAttributeValue

join cteRequiredValues

on cteRequiredValues.Value = AttributeValueID

group by MachineID

having count(*) =2

My bad.

On the face of it i cant see any reason.

What app was the queryplan from ?

Can you send a standard one from SSMS ?

Oh and full DDL for the...

What do you get from ..

select balance from TRM_TRUST where MATTER_UNO= 189270

select balance from HBM_MATTER where MATTER_UNO= 189270

Take a look at my blog entry here

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/direct-emailing-of-ssrs-reports-via-sqlclr.aspx

It may get you partially there

Very easiliy

Add a row group, grouped by 'colA'.

Then add a total row.

Use the drop down to select the data value as you normally would.

Job done

If thats not clear see this...

Something like this ?

;with cteRows

as

(

select 1 as r

union all

select 2

)

Select ,

case when r =1 then convert(char(10),Fielda) else '' end,

...

Heres one method of processing contiguous data issues

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/sql-and-contiguous-data-ranges.aspx

Seems to work fine, rename this .txt file to .rdl for an example

The fill pick colour in series properties should be get to automatic.

Try using the expression function there.

any reason for not using an identity ?