Yep, the collate comes before the alias.

I think you're putting the collate clause in the wrong place, pretty sure it needs to be on one of the T0.ItemCode fields (assuming ItemCode is a character field)

Does this...

I don't think the WAIT_AT_LOW_PRIORITY option is valid in ALTER TABLE ADD

Looks like it can only be used in online index operations.

polkadot (8/12/2014)

---

I had to first de-aggregate the source values in the second dataset before I could pull them in. The expression that worked, once I did that, was

=Fields!U_SentLeads.Value,...

Have you tried it with the same where clause in each section?

If that's not right, remove the where clause from the second/third section as appropriate.

Cheers

Hi,

If I'm reading your requirements correctly, you just need to add the same where clause to each section of the union:

select

property_name,

count(distinct lead_id) AS leads_sent,

1 as OrderField

from leadtracker

where ...

group...

Add another row at the bottom of the report, and give it an expression along the lines of:

=First(Fields!FieldName.Value, "DataSet2")

Where DataSet2 is the dataset containing the second query.

Can't remember the exact...

GO should be fine in script files when executed via sqlcmd.

I'll be damned if I can see where the problem is though if it isn't that.

Do you get the same...

Thanks Gail, that could be why it's 16KB, can't see a table that small needing 2 IAM pages?

Cheers Koen, thought that was the case.

Can you run it without the WITH NO_INFOMSGS & see what the output says?

Also add print ( @sql ) directly before/after exec ( @sql ) so you can see the...

2. - IAM page

http://www.sqlservercentral.com/Forums/Topic980942-391-1.aspx

I was wondering that myself John, whether or not a clustered index is considered in the 'index' part of sp_spaceused.

It's also worth noting a nonclustered index will need to include...

It's a client tool. You provide connection information to it for an existing machine with SQL Engine installed on it.

Visaul Studio also keeps a LocalDB version which is only accessible...

Are you declaring @pCNum in the dataset code?

In SSRS you don't declare the parameter in code. That's how BIDS determines it's a report parameter.