Viewing 15 posts - 226 through 240 (of 4,087 total)
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. ...
June 30, 2020 at 3:17 pm
srisadhu wrote:But isn't ^ wild character for like and regular expression.
No, it is not a wildcard and like does not use regular expressions.
LIKE absolutely does use regular expressions. It's...
June 26, 2020 at 5:09 pm
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
June 26, 2020 at 2:05 pm
Steve Jones - SSC Editor wrote:Wait, dancing? Are we getting a video posted somewhere?
I'm too busy dancing to take videos, but I might be able to find something online.
Drew
I finally found something online. ...
June 17, 2020 at 7:48 pm
Wait, dancing? Are we getting a video posted somewhere?
I'm too busy dancing to take videos, but I might be able to find something online.
Drew
June 17, 2020 at 7:10 pm
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...
June 16, 2020 at 9:19 pm
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....
June 16, 2020 at 3:36 pm
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...
June 16, 2020 at 3:15 pm
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...
June 16, 2020 at 3:00 pm
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
June 15, 2020 at 9:01 pm
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
June 15, 2020 at 8:36 pm
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...
June 15, 2020 at 2:08 pm
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...
June 10, 2020 at 9:02 pm
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...
May 29, 2020 at 10:00 pm
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
May 27, 2020 at 9:54 pm
Viewing 15 posts - 226 through 240 (of 4,087 total)