You want all alerttype=[4,6] records or the first or last one? That's not a very good requirement statement.

Be careful of having exact numbers in the ROWS clause if your data isn't clean. You can partition by some datepart(hour), but be aware this might not run quickly. If...

Look at ConCat(), but what Scott did was escape out the single quotes with extras. That's a common technique for adding them to strings.

Error. No one put in the URL.

It's here: https://www.red-gate.com/hub/product-learning/sql-compare/build-and-fill-a-sql-server-database-using-sql-compare-cli-and-a-batch-script?topic=database-builds

Good catch on CDC. I've altered the question to remove this.

Well, today I was drinking my coffee, trying to come to grips with another day of trying to actually get some work done at home. The housework has slipped....

We closed our office last week, everyone at home. Not a big change for some of us, but it is a change. Many things are less active and it looks...

Reported the last post bug again. There was supposed to be some fix, but not sure if  it deployed while I was gone.

Hope you feel better, Jason, and it's not serious.

All of you are. If she saw a few of these posts, she'd sneak onto my desktop and start banning your accounts.

I'm glad my wife isn't on this thread...

Took me 3 days and 4 trips to a supermarket to buy Toilet Paper... I honestly thought I was going to have to "borrow" (aka Steal) some from work....

Mike, I appreciate you wanting to soldier on, but it's not just about you. Certainly we wouldnt' want you to get sick, but what if you get sick and expose...

Good catch, Scott. Changing that.

String_split returns a table. The list is converted into a table, so normal query rules for a table apply. In this case, there is no PK,...

My employer has been discussing for what seems like years about putting databases under VCS.  One system that I support was developed by an outside contracting firm.  Their database...