I see you updated the LAST_VALUE(), but not the FIRST_VALUE().  The default isRANGE BETWEEN UNBOUNDED PRECEDING...

Thanks for the tip Drew, I've made the change to the code.

So just a couple tips for the next time you post.  Make sure you put any DDL statements in a code block so its easier to read.  Most people don't...

• This reply was modified 5 years, 6 months ago by  Y.B.. Reason: Small edit to code
• This reply was modified 5 years, 6 months ago by  Y.B..
• This reply was modified 5 years, 6 months ago by  Y.B.. Reason: Updated Code

Looks like you are trying to use a string function on a datetime field.

--instead of this
--SELECT SUBSTRING(GETDATE(),1,10)

--do this
SELECT CAST(GETDATE() AS DATE)

That doesn't mean there can't be another process locking your table.

• This reply was modified 5 years, 6 months ago by  Y.B.. Reason: Added additional comment

Just to clarify, does the source contain the full current data set...

--That's Great News!

--Thanks ;)

I only...

This was driving me nuts too.  I tried a few things in post to see if there was a way around it but I think I edited one too many...

There isn't a lot of info here and it seems like someone was already helping you on a previous thread.  However, if you are just looking for a method to...

I would just assign it to a variable first.

DECLARE @year SMALLINT
SELECT @year = MAX(SCHOOLYEAR)
FROM ASemester

SELECT *
FROM ASemester ASemester
    JOIN AMilestone AMilestone
   ...

I knew this one all too well.  When we migrated images stored as varbinary out of our database and deleted the data it was interesting that we hadn't reclaimed any...

This isn't a question on whether to upgrade. If you've...