Are these in one filegroup or multiple filegroups?

I like Scott's approach but honestly, I'd avoid the LIKE. If this changes, it would likely be quicker to just update all rows inserted.

• This reply was modified 6 years, 10 months ago by Steve Jones - SSC Editor. Reason: wrong user mentioned

It's a strange setup for now. The forum software doesn't seem to align itself with users very well, so there should be some ticket in place to clean up times....

I believe what you're looking for is a 12 month counter, starting with the current month + 1 and moving backwards for 12 months. If I understand this, for any...

Definitely Freudian. I've done it a few times. Apparently, as much as I like Service Broker, I don't like Service Broker.

No, this is a simple form, not an interactive designer (yet).

We prefer to select answers so only one is correct, but we do support multiple correct answers. Be sure your...

Will do ,and apologies on the delay. Our migration expert has been on holiday and busy with non SSC stuff. The migration scripts seemed to run correctly this time, so...

OVER clause: https://docs.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-2017

If you mean something like this, you can't do this:

declare @i int = 2;
select sum(a) over (partition by b
      ...

I see this, but without any data as well. The platform peridocally saves things itself, but nothing went through with the post. Not sure what's wrong here. Can you type...

Does this happen even if the browser is not maximized?

So it's official. I've been accepted to Grace Hopper 2019 in Orlando to talk about "Imposter Syndrome: Are You Ready To Mentor". WHEEE... Now I have to overcome my...

You can grant rights to the public server role here for access to the database, but be careful here. You might be better using SQL Server auditing instead.

You can also...

This doesn't make sense in how you've written it. Please be more descriptive and format the code so it can be understood. It looks like you intend the commit/rollback to...

These have been found and migrated.

Been a mystery for me as well. It's the big reason why Redgate built SQL Source Control. Not sure if they'll ever change.