Viewing 15 posts - 1,486 through 1,500 (of 5,109 total)
It's an OUTER JOIN: Outer Joins.
Why you would use that syntax now though...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 2, 2018 at 3:02 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2018 at 5:04 am
It might post be me, but I'm really struggling to see what you're asking here. It just looks like a bunch of links with some unformatted SQL sandwiched in. Can...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2018 at 3:06 am
Why do you want to decrypt them? Normally password should be stored in a hashed and salted method, so they can't be decrypted.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2018 at 12:34 pm
You can increase the priority of a query in terms of deadlock victimisation (a query with a high priority will cause one with a lower to be the deadlock victim)....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2018 at 11:10 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2018 at 9:52 am
On the note of getting your result set, I would do something like this:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2018 at 9:39 am
I recommend against having numbered month columns. YOu should have a single column to denote the month number, and another to denote it's value. Like:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2018 at 9:28 am
Triple post (sorry). it's also inconsistant. See my notes below: Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.<AgentDataWork>
<AgentID>001</AgentID>--Agent ID outside of Event
<Event>
<code>Not Ready</code>
<date>1/1/2018 9:00 am</date>
<reason>break</reason>
Larnu.uk
October 31, 2018 at 9:14 am
just having a look at that xml further, it isn't valid. You have no root node (AgentDataWork isn't your root, as it's repeated). What is this going to be consumed...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2018 at 9:06 am
Thanks for posting your attempt. While I have a look, whya re you storing dates as a varchar? datetimes should be stored as a datetime(2).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2018 at 8:52 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2018 at 8:20 am
What is their reasoning for using DROP and CREATE? Considering that they aren't in charge of deployment, they must have a good reason for overuling someone that is.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2018 at 8:01 am
Whataattempts have you made so far to get his result? Can you post them and tell us what was wrong with them?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2018 at 7:56 am
Jeff Moden - Monday, October 29, 2018 6:51 AMWhat about the spaces between area code, exchange, and line that were originally posted?
Good...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 29, 2018 at 6:58 am
Viewing 15 posts - 1,486 through 1,500 (of 5,109 total)