Also, triggers are processed for the entire result set at once.  You've set up your trigger to only process one row of the result set and discard the other rows. ...

LIKE absolutely does use regular expressions.  It's...

The code [0-9] searches for EXACTLY ONE DIGIT.  Your examples have 2-4 digits in that position, which is not exactly one, so they don't match.

Drew

I finally found something online. ...

I'm too busy dancing to take videos, but I might be able to find something online.

Drew

Took a couple of days off to start potty training and get back online this morning to discover my employer has designated Juneteenth to be a company...

Took a couple of days off to start potty training and get back online this morning to discover my employer has designated Juneteenth to be a company holiday.

So, yay....

Lakh is derived from the Indo-European word for "salmon" and is related to the words "lox" and 'lacquer".  It should be obvious how "lox" is related to "salmon".  "Lacquer" was...

This should get you started.

DECLARE @doc XML =
'<Parameters xmlns="http://www.www.com/WebFramework/WorkflowParameters.xsd">
<Parameter Name="ClientID" StringValue="12903166" />
<Parameter Name="Workflow_ActiveSlide" StringValue="317" />
<Parameter Name="Document_First_UserID" StringValue="8577430" />
<Parameter Name="Program" StringValue="120555" />
<Parameter Name="Workflow_ActiveUser" StringValue="9137070" />
<Parameter Name="Document" StringValue="14317336" />
<Parameter...

If, and that's a big if, the database is properly defined, you should be able to look at the foreign keys to determine what fields to link in most cases.

Drew

Your field probably has a non-printable character in it such as a tab.  I'm comfortable enough with binary that I convert to binary to find problems like this.

Drew

And now, how to put the brakes on a migration project...

Break your wrist on a bicycle ride so you only have one hand to type with and no immediate...

You're either going to need to do your calculations in T-SQL and not group on CalcField1 or do your totals in SSRS.  If you want more details you're going to...

Yesterday my work announced that they were extending the work from home policy at least through Labor Day.  With me living in one state and working in another, that certainly...

You can't remove them from the PIVOT, but you can use COALESCE() or ISNULL() to replace the NULL results with some other value.

Drew