Viewing 15 posts - 571 through 585 (of 8,755 total)
Why the extra step of replacing the concatenated CR and LF? Doesn't replacing the individual CHARs suffice? That's how I've done it, and I'd like to know if there...
October 15, 2019 at 1:47 pm
Folks:
I would like to replace CHAR(13) (Carriage Return) with space and I use this SQL to replace it, but the problem is when the column has NULL values it...
October 15, 2019 at 12:51 pm
IIRC, 18456:1:X error should result in an entry in the SQL Error Log, have you checked if anything is there?
😎
Quick question, is this a named instance?
October 11, 2019 at 12:58 pm
BrainDonor wrote:SQL Saturday in Edinburgh - 1st Feb, anybody from here thinking about going?
I would do, except I'm playing in a show all that week. Bad timing...
We all do...
October 7, 2019 at 1:49 pm
It's kind of like having a hypothesis of "Why did the chicken cross the road" and then coming to the conclusion that all chickens cross the road.
You just spilled...
September 9, 2019 at 3:23 pm
This gives a running total, ordered by the foo_id. You can now take this running total and put it in a view that shows (running_item_tot % 6). I'll let...
August 31, 2019 at 6:22 pm
Thanks, Jason. Nice to hear from someone that's "actually been there and done that". And, yeah... I picked up on the fact that they used partners as Amazon does....
July 20, 2019 at 3:51 pm
p.s. Venting is good... being old, I can tell you, it keeps you from farting so much. 😀
I guess my wife would say I need to...
July 12, 2019 at 2:12 pm
Jeff Moden wrote:It's the law of home ownership, Steve... all 10 minutes jobs take at least 6 hours to complete. 😀
And 5 trips to the hardware store.
...
July 4, 2019 at 3:24 pm
What a day, one could not make it up! My best friend taken to a hospital (second time in two days) after collapsing going flat on the ground, no family...
June 27, 2019 at 4:48 pm
Would love to try out the T-55 relic
😎
Slightly lighter and more powerful than the Cat D-9 and up to twice the power, wouldn't call it a sports car performance but...
June 23, 2019 at 3:13 pm
Grant Fritchey wrote:I was on Poland recently, but no one let me drive a tank...
Now, that would be scary :-/
a tank or A TANK
😎
Would be concerned if it...
June 21, 2019 at 3:01 pm
I have used Poor Man's T-SQL Formatter, in different editors, works nicely. Now I mostly use SQL Prompt, from Toolbelt in SSMS. The SQL Prompt...
June 13, 2019 at 2:37 pm
MS have added database diagrams back into SSMS - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
Other than Windowing functions, this is one of the best moves MS has ever done. It certainly...
June 12, 2019 at 3:56 pm
Viewing 15 posts - 571 through 585 (of 8,755 total)