What's totally odd is that MS does that with their examples of CTEs - all of them begin with a semi-colon, which was really weird to me. Gotta love...

Sounds like a good time to use Integration Services. If you created a package, you could then use SQL Agent to run the package you created on some interval...

If you disallow nulls, the checkbox will not be displayed. But you want to allow nulls but still hide it, right?

If you imported this from Access, you probably have some...

so if you create the standard hierarchy and get a level, filter for the difference in Levels = 2 for the non-CEO types, and for the CEO, set the levels...

I don't think you can do that in a report. I would think you would need something like a .NET GUI to do that, because SSRS generates a read-only...

TG-

I learned to do it by using a big whiteboard. If you need to test your designs by loading some data and then trying to query, you could use SQL...

Eliza,

<cheat sheet>Region | Yr1 - Sales | Yr2 - Sales | Yr3 - Sales | Yr1 - Numbers | Yr2 Numbers | Yr3 - Numbers

What if you had a tablix...

http://msdn.microsoft.com/en-us/library/ms179854.aspx explains how partition schemes and functions work. Read that first. Then maybe create a dummy table in a dummy DB to play with until you understand everything....

You mean by creating two tablixes and filtering one for value 'A' and the other for value 'B'?

Just add a filter to your tablix and you should be off...

Marco,

I'm confused. What is your ultimate goal? You say you want to delete data from your database, but there are no delete statements anywhere. Your stored procedure inserts...

You are passing too many parameters to your stored procedure. It can only accept two:

create procedure [dbo].[AdventureWorks2008R2]

@severity int, -- param 1

@message nvarchar(max) -- param2

as

...

What do the @severity and...

Might be a case of "when all you [know] is a hammer, everything looks like a nail."

If you're going to output the results to Excel, you have to do it a single dataset at a time, so I don't know that you have any other option...

Global task is to present single screen to user, then he selects @Year and Press Run, system should direct flow based on @Year, if < 2010 then run Report02 else...