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,...

Could you give an example of...

What are you using to do your reporting? SSRS?

If you post proper CREATE TABLE scripts and INSERT scripts to populate your table(s), you will probably get an answer...

What do (Name, Project, Date) represent? Some event? If you explain that part, we can help you sort out the design of your table. (As Jeff mentioned, are you...

Problem:

-> I'm checking if the record exist in Contact table or not. If it exist then I will insert into employee table else I will insert into contact table then...