If you go to PragmaticWorks.com, they post their videos on various SQL topics. Brian's stuff on SSIS is really good.

http://stackoverflow.com/questions/1179082/ssrs-tracking-report-usage was interesting and probably will help you.

It mentions that once you determine the reports that nobody uses that you can move them to unclutter your RS instance.

What is the source of your EDI data? Whoever supplies the data should have the format for you. I think there are folks that write EDI parsers too....

Did you specify a collation on one or more columns in one of your tables? It sounds like you're trying to get the collations to match, and they don't.

This exercise is a lot easier to understand if you have some data to work with. It's easier to see repeating fields if you have a table structure. ...

sounds like you need to union one result to another so that they end up in the same dataset.

Jason Selburg wrote something that does that:

http://db-pub.com/news-10013929/data-driven-subscriptions-in-sql-rs-standard.html

Ideally, you would have someone fix the dirty data for you, and your problems would go away. But if that's not an option, you could create a calculated field...

Welcome!,

Did a little digging around both on here and the internet and found a couple of really good examples showing how to do exactly what you are asking about.

Kathi Kellenberger's...

First things first - remove the NOLOCK hints. It's not a magic "accelerate my query" command. Do you get correct answers if you do that?

Looks like your example data is wrong. Without an explanation of the rules, this is as close as I could get:

SELECT x.*, y.productID

FROM

(SELECT xState

, MAX(Sales) AS MaxSales

FROM salesData

GROUP BY...

How can you get to 3NF if you don't go through 1NF and 2NF first? Interesting concept.

Here's a pretty easy primer on Normal Forms. If you apply them...

Help us help you. Could you post some dummy data? Just something for us to start with instead of starting from scratch?

If you make the parameter get its values from a dataset, it's pretty easy.

Right-click the parameter you want to show as a value list, go to Parameter Properties.

Select "Get values...

I think you mean a tablix, but anyway...

If you click on one of two right columns (one of the Hours ones), you can right-click and from the context menu dropdown,...