I'm not sure that counts as a TVC in an INSERT. The TVC is in the SELECT statement.

I also don't know how to word this without just giving away an...

I am as well. I'm open to new platforms, but not just because someone had experience and likes it. Or thinks it would be better. We need some sort of...

...

If we're doing something like developing something new against an existing database, then the process is faster. A new database schema isn't needed, so instead of creating a new...

Not sure what you mean?

Apologies. Was out of touch last week, but I've adjusted the question to note an INSERT statement and award points back.

Double check your configuration settings for the network. You could have something else open and available. Ideally, we do not expose SQL Servers on the Internet in any...

Test

Wow, quite the story and glad your son is doing well.

I completely agree. This wasn't as much about life,...

I'm trying to learn to do better at writing things down in a planner. But then I get too busy to write it all down and things lapse or...

"I walked outside to take the call during a break and was told I wasn"t responding quick enough to the call. The emergency? A test of how quickly I'd...

Just add it in:

SELECT t2.VID, t2.OrdDate, t2.Prg1,
       CASE WHEN t2.RowNum = 1 THEN VIDCount ELSE NULL END AS VIDCount
FROM (
 ...

They will. And there's...

Over the years of learning the hard way in database work, I grew to get a little better at good satisficing (perhaps manually importing some data short-term until it...

Excellent article, ...

I absolutely love it when the challenge at hand requires a graceful and carefully engineered solution, but I also find it gratify to simply craft something that...

We don't, though you could certainly disconnect a network and see if anything fails or if you can track anything.