This is the logical equivalent of a V/HLOOKUP in Excel. Something like this should work:

DECLARE @SalePrice SMALLMONEY = 250.00;

SELECT MAX(Bonus)

FROM #CompPlan

WHERE HighVal<@SalePrice;

-- sorry, I guess I left one thing...

all dbs not accessed before (or do you mean since) a given date...

Exercise your GoogleFu.

Found this pretty quickly:

http://dinesql.blogspot.com/2010/05/when-was-my-sql-server-database-last.html

I tweaked it a little, but I may have misunderstood the filter you...

Let me see if rephrasing this will help. I'm wondering how to model sales territories when the "borders" move over time.

Same basic sales database (think Contoso DW... it's just less...

I have to admit that I know little about MySQL, but you should be able to use something like this:

WHERE event_time>DATEADD(m,-2,GETDATE())

(subtracts two months from the current date).

one way would be to create a view and then put the aliases there.

CREATE VIEW vw_SomeView

AS

SELECT field1 AS NewName

,field2...

Deleting posts (unless completely absurd) seems odd to me. To me, it's like tearing pages out of a knowledge repository. Nothing quite like remembering an old post that...

Got details??

A rough analogy to your description is like saying that "my car used to run fine, now it doesn't." The obvious response is "What changed between when it...

Wow. That's mind-boggling!!!! I see that MS has adopted the SQL Server license model for all of its software. I wonder if they sell a decoder ring...

the only way I could think of doing it was to have a "translation" table.

Something like (CustomerID, Year, AssignedTerritoryID).

That's the only way I could figure out to be able to...

I was waiting for Jeff Moden to answer, but since he hasn't yet, you might want to read his article:

http://www.sqlservercentral.com/articles/T-SQL/94570/

or

http://blogs.msdn.com/b/mvpawardprogram/archive/2012/06/25/hierarchies-convert-adjacency-list-to-nested-sets.aspx

Or maybe one by Dwain Camps

https://www.simple-talk.com/sql/performance/the-performance-of-traversing-a-sql-hierarchy-/

That's what I suspected. Then I can just filter the Territory dimension with the appropriate year and be off to the races.

Thanks!

Doing things like you describe is not uncommon with date dimension/calendar tables in a data warehouse. Then you can do pretty much any kind of date-related query really easily.

Yeah, until the defense turns up the pressure... then he'll hurry and throw some interceptions like he always does.

Just throwing this out there, but what if you do something like

UNPIVOT to convert the dates in the column names to rows,

join to the Calendar table to get week numbers...

Once you have the DelimitedSplit8K function in your database, you can do something like this:

SELECT test.ID

, test.value

, split.ItemNumber

, Item = split.Item

FROM

(SELECT 1 AS ID,'1' AS Value

UNION ALL

SELECT 2,...