Does then PTO policy apply to everyone in the company or only executive management?

I actually rather see a system where additional PTO is earned. For example, if a team meet their deliverable, then everyone on the team gets an extra three days of...

Andy, just to confirm you're talking about "PTO" which is Paid Time Off and not something like un-paid leave of absence?

SQL is a lot like HTML, I'm sure they don't want to get too far ahead of the ANSI standards and end up with a lot of proprietary extensions in...

Careful challenging the wisdom of the gods.

This should basically be it.

ALTER Function [dbo].[RemoveNumericCharacters](@Temp VarChar(1000))
Returns VarChar(1000)
AS
Begin

Declare @NumRange as varchar(1000);

SET @NumRange = '%[^0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9][^0-9]%';
While PatIndex(@NumRange, @Temp)...

You'll need to post T-SQL for RemoveNumericCharacters() function, that's where the coding will go.

You can leverage the PATINDEX and SUBSTRING functions for this.

DECLARE @s-2 VARCHAR(500)= 'The quick brown foxes ssn is 111111111 or 111-11-1111 for your info';
DECLARE...

What's interesting is how these misguided policies actually encourage bad SQL programming practices.

Hey, boss-man, when...

Typical programming books like "Database Programming with C#" may cover data modeling to come extent, but it's more of an afterthought and rather sparse.

Ralph Kimball has some excellent...

Perhaps the best way to proliferate a process is to make tools for the process ubiquitous. There is a rudimentary Database Diagram tool in SSMS, but it hasn't changed in...