Domain access for the direct access, and SQL accounts used only for linked servers, gives a pretty good security model that's easy to administer. You can audit what you...

To misquote Obelix: These DBAs are crazy! 😀

Run a trace to capture every command it issues to the database. From that, you'll be able to work out what tables, procs, etc., it is accessing. Then...

Replace "Union" with "Union All", and you should have a decent query there. Not sure what you mean about replacing Union with Case statements.

Go with one view per store, even if two stores are identical in their columns. That's not a good general database practice, but it sounds like the only practical...

This is how I'd build something for that in T-SQL:

-- Gets prior three months

SELECT

DATEADD(MONTH, -1, GETDATE()),

DATEADD(MONTH, -2, GETDATE()),

DATEADD(MONTH,...

Honestly, as complex as your solution and environment sound, I doubt anyone can give specific suggestions on this.

I generally solve authentication double-hop issues by using SQL Server logins instead of...

GilaMonster (1/5/2011)

Errr... Depends completely on what you're trying to do. If you need...

Test Driven Development suggests running it and collecting the error messages, then fixing those.

Otherwise, figure out what the tool will be doing, and where it will be doing it, and...

You can also add columns with an Alter Table command for temp tables.

Turn that query into a string in a variable. Replace "MyTable" with the value from the cursor. Execute it as dynamic SQL.

declare @TableName varchar(255), @CMD varchar(1000);

declare Tabless cursor...

Views are tricky to index. Lots of rules on that.

The better bet is to write out the query you really need in this, instead of using views.

I'm assuming that different stores have different columns. If that's the case, you won't be able to have one view with all stores. Unless you include ALL columns...

I can't see the image. Can you post code for the table?

Create a temp table. Insert the table name (from the variable) into it, if no rows exist that fit the criteria. You can test for that with a...