http://www.sqlservercentral.com/scripts/attach+database/96623/

I found something that works pretty well.

Think I figured it out:

STEP 1: Create the link server

DECLARE @FileSource varchar(100) = 'TestFile.xlsx'

DECLARE @SQLStatement nvarchar(MAX)
SELECT @SQLStatement = 'EXEC sp_addlinkedserver
@server...

Yes i copy pasted it, just the "dash" and did get the dash character.  Apparently SQL must consider all the characters but I can't get the hidden characters on a...

If the ID was ascending (original example was desc)  how would I do this?  I tried modifying the examples but couldn't get it to work.  Also if there were more...

Yes, works perfectly.  Thank you!

I figured it out, if I move the

SELECT * FROM #Final
into...

wow thanks

Not Correct Result (right column)

8000001200$30,000.00 0.3333

8000002250$12,000.00 0.1667

8000003220$10,000.00 1

8000004280$18,000.00 0.4444

Correct Result (right column)

8000001200$30,000.00 $4,000.00

8000002250$12,000.00 $2,916.66

8000003220$10,000.00 $2,200.00

8000004280$18,000.00 $4,044

Example of Result Needed by Level for Invoice 8000001 is $4,000.00...

If I do a join I'm not getting the expected result because the calculation needs to cycle through every row. I'm trying to calculate the bonus on all invoices...

The 3:13 is worked, I cant copy/paste

I'm getting an error, incorrect syntax near 1 (the 3:07 solution)

It is a permissions issue. I have permissions to read only. Is there such a thing as a temporary function?

Guess I'm not thinking:

SELECT * FROM #Test

WHERE (StartDate < CAST(GETDATE() as Date) AND EndDate IS NOT NULL)

OR StartDate >= CAST(GETDATE() as Date)

I'm assuming the Unix server is always storing this in the time zone UTC, so if I want it in CST it is always -6 hours?

I'm not sure I asked this right, every record has a 10-day date range based on the date for that record.