Viewing 15 posts - 571 through 585 (of 8,760 total)
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
Bad news, Chaps. The Queen now has to pay for her "stories." https://www.bbc.com/news/entertainment-arts-48583487 EDIT: This was meant humorously, BTW.
Haven't had a telly for more than 20 years, do neither...
June 12, 2019 at 3:52 pm
This should do the trick, no need to convert to a varchar
😎
SELECT convert(date,convert(varchar(12),getdate(),131),103) AS AH_DATE
June 10, 2019 at 12:57 pm
Reviewing legacy code few years back, I came across a view which was couple of hundred Kb in size (object definition's data size). Thinking that that one was something worth...
June 5, 2019 at 1:29 pm
Viewing 15 posts - 571 through 585 (of 8,760 total)