How do you retrieve the data in SQL Server that you want? And how often do you need to insert it?

What if you pull (from Access) instead of push (from SQL Server)? The easiest way, if it's a one-off, might be to create a stored procedure and run it...

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