Perhaps something in the restore statement, but glad it's working and thanks for the followup.

If this is a one off, then instead of the studentid in the SELECT, then put the scalar value instead.

As Drew noted, however, make your question easier for people to...

Not sure, but with data, often it's something small I've missed.

Rather than this join, what I'd pick is a row or two that I  am struggling with and limit my...

Lol, I book flights constantly, so a different perspective. Often I want a 4 day or 7 day trip, so moving one date should move the other. That's a handy...

I don't think IQP is the end-all, and in many cases, poorly written procedures that are "catch-all" still can perform really poorly. The IQP stuff tries to reduce the edge...

If you plug into SSMS, then you're not learning. You're gaining points, but the idea is to test yourself and see if you can answer.

Our office started using Slack a couple of years ago.  There was little instruction, no best practices.  People added me to channels and I had no idea why.  I...

lol, I like that. I have tended to be...

So far I'm eeking things out. Somehow despite a nice comeback from Mr. Allen, Mr Mahomes exceeded expectations again.

I'm worried about bye weeks now.

I guess you might need to check the table exists. Sorry, I saw this on mobile and missed the "table" note in your comment.

Hadn't thought about checking for a table...

That's what alter table drop column if exists does.

SQL in a Nutshell from O'Reilly from Kevin Kline is also good

Nothing stands  out, but that's a lot of code, and not formatted (code button in the edit box).

However, is this running? Do you  have open transactions? Depending on data sizes,...

I'll say that I don't mind vendor talks, as long as they're presented as such. I also think lots of vendor employees have deep technical knowledge and share that without...

Love to see this.