June 27, 2017 at 6:49 am
Sergiy - Monday, June 26, 2017 11:22 PMJeff Moden - Monday, June 26, 2017 6:41 PMSergiy - Saturday, June 24, 2017 9:07 PMJeff, ok, not mellow.But really - are 2 cups of coffe enough for you to stop hating this world???Wow...Heh... hell no. 2 cups of coffee just keeps me from killing things on the spot. 😉
Somebody must consider cutting off supply of coffee to your workplace.
Temporarily of course.
Must help a lot with reducing emissions. All sorts.
No, you don't cut off the coffee supply...
You replace all the coffee with decaf...
Much more entertaining to watch.
June 27, 2017 at 6:54 am
jasona.work - Tuesday, June 27, 2017 6:49 AMSergiy - Monday, June 26, 2017 11:22 PMJeff Moden - Monday, June 26, 2017 6:41 PMSergiy - Saturday, June 24, 2017 9:07 PMJeff, ok, not mellow.But really - are 2 cups of coffe enough for you to stop hating this world???Wow...Heh... hell no. 2 cups of coffee just keeps me from killing things on the spot. 😉
Somebody must consider cutting off supply of coffee to your workplace.
Temporarily of course.
Must help a lot with reducing emissions. All sorts.No, you don't cut off the coffee supply...
You replace all the coffee with decaf...
Much more entertaining to watch.
Yeah, as people get more and more irritable. By the time the headaches start, you'll have to start counting the people remaining instead of the people who went home. By the time the headaches really set it, you'll have to start counting the dead.
June 27, 2017 at 7:04 am
Ed Wagner - Tuesday, June 27, 2017 6:54 AMjasona.work - Tuesday, June 27, 2017 6:49 AMSergiy - Monday, June 26, 2017 11:22 PMJeff Moden - Monday, June 26, 2017 6:41 PMSergiy - Saturday, June 24, 2017 9:07 PMJeff, ok, not mellow.But really - are 2 cups of coffe enough for you to stop hating this world???Wow...Heh... hell no. 2 cups of coffee just keeps me from killing things on the spot. 😉
Somebody must consider cutting off supply of coffee to your workplace.
Temporarily of course.
Must help a lot with reducing emissions. All sorts.No, you don't cut off the coffee supply...
You replace all the coffee with decaf...
Much more entertaining to watch.Yeah, as people get more and more irritable. By the time the headaches start, you'll have to start counting the people remaining instead of the people who went home. By the time the headaches really set it, you'll have to start counting the dead.
We have instant coffee in the kitchen and the leaded and unleaded tins look practically identical apart from the lids which are simply different colours. How they've never been 'accidentally' mixed up I don't know :Whistling:
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
June 27, 2017 at 7:08 am
Jeff Moden - Monday, June 26, 2017 6:47 PMNot sure who photoshopped that picture of me in the morning... they got it all wrong... I never smile before noon.
That is actually a screenshot from the movie "Killer Klowns From Outer Space". An absolutely hysterical cult classic.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 27, 2017 at 9:01 am
Jeff Moden - Monday, June 26, 2017 6:44 PMEric M Russell - Saturday, June 24, 2017 8:24 PMSo, did anyone else have a strangely intense dream recently about being, outside looking up at the night sky, and then a constellation of stars coalesce into a UFO that lands nearby?Crud. Sorry. Didn't mean for you to see me.
Great. Jeff's moved on from pork chop launchers to "nuke it from orbit". Nobody write any cursors!
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 27, 2017 at 9:03 am
Sean Lange - Tuesday, June 27, 2017 7:08 AMJeff Moden - Monday, June 26, 2017 6:47 PMNot sure who photoshopped that picture of me in the morning... they got it all wrong... I never smile before noon.
That is actually a screenshot from the movie "Killer Klowns From Outer Space". An absolutely hysterical cult classic.
That is actually a screenshot from an absolutely riveting documentary about Killer Klowns From Outer Space.
FTFY
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 27, 2017 at 9:07 am
jasona.work - Tuesday, June 27, 2017 6:49 AMNo, you don't cut off the coffee supply...
You replace all the coffee with decaf...
Much more entertaining to watch.
OMW NO!!!
Drinking decaf is like going to a CatHouse for a cuddle.
June 27, 2017 at 10:18 am
jonathan.crawford - Tuesday, June 27, 2017 9:03 AMSean Lange - Tuesday, June 27, 2017 7:08 AMJeff Moden - Monday, June 26, 2017 6:47 PMNot sure who photoshopped that picture of me in the morning... they got it all wrong... I never smile before noon.
That is actually a screenshot from the movie "Killer Klowns From Outer Space". An absolutely hysterical cult classic.
That is actually a screenshot from an absolutely riveting documentary about Killer Klowns From Outer Space.
FTFY
ROFL!!!
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 27, 2017 at 5:57 pm
jonathan.crawford - Tuesday, June 27, 2017 9:01 AMJeff Moden - Monday, June 26, 2017 6:44 PMEric M Russell - Saturday, June 24, 2017 8:24 PMSo, did anyone else have a strangely intense dream recently about being, outside looking up at the night sky, and then a constellation of stars coalesce into a UFO that lands nearby?Crud. Sorry. Didn't mean for you to see me.
Great. Jeff's moved on from pork chop launchers to "nuke it from orbit". Nobody write any cursors!
It's the ultimate "cloud" service. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2017 at 5:59 pm
jasona.work - Tuesday, June 27, 2017 6:49 AMSergiy - Monday, June 26, 2017 11:22 PMJeff Moden - Monday, June 26, 2017 6:41 PMSergiy - Saturday, June 24, 2017 9:07 PMJeff, ok, not mellow.But really - are 2 cups of coffe enough for you to stop hating this world???Wow...Heh... hell no. 2 cups of coffee just keeps me from killing things on the spot. 😉
Somebody must consider cutting off supply of coffee to your workplace.
Temporarily of course.
Must help a lot with reducing emissions. All sorts.No, you don't cut off the coffee supply...
You replace all the coffee with decaf...
Much more entertaining to watch.
Much more fun to simply switch the containers. Both groups end up on the wall. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2017 at 6:01 pm
Lynn Pettis - Friday, June 23, 2017 10:07 AMJeff Moden - Friday, June 23, 2017 9:27 AMThom A - Friday, June 23, 2017 9:06 AMJeff Moden - Friday, June 23, 2017 8:58 AMThere's a work-around for this although it won't help the very poor color-mix that occurs (they had this right for a long time... they should simply revisit that code to make it right again).
The work around is to copy your well-formatted code from SSMS into NotePad. The copy from NotePad into the SQL Code IF Code and the format will be nicely preserved. It also makes it a whole lot easier for others to copy your code from an SQL Code block.
Tried that, no effect. SSMS -> notepad -> SSC gives the exact same problem as SSMS -> SSC.
I don't know what to say except that it works perfectly for me.
Isn't that always the case, "It works on my machine." 😀
Especially after the fourth cup of coffee. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
June 28, 2017 at 4:49 am
jasona.work - Monday, June 26, 2017 12:25 PMWhat does it say that when I see a response written to a topic by certain people, I hop in to see what's going on and what the reply is?The "pentagon of must reads" is (in no particular order, so no one take offense, please:)
Jeff Moden
Steve Jones
Gail
Lynne P
Brandie T
Awwwww. Thank you. I have no idea how I made that list, but thank you. @=)
June 28, 2017 at 4:51 am
jonathan.crawford - Tuesday, June 27, 2017 9:01 AMJeff Moden - Monday, June 26, 2017 6:44 PMEric M Russell - Saturday, June 24, 2017 8:24 PMSo, did anyone else have a strangely intense dream recently about being, outside looking up at the night sky, and then a constellation of stars coalesce into a UFO that lands nearby?Crud. Sorry. Didn't mean for you to see me.
Great. Jeff's moved on from pork chop launchers to "nuke it from orbit". Nobody write any cursors!
HA! I defy your directive and write one anyway!
(Cursors do have their place, ya know).
June 28, 2017 at 4:53 am
Reasons to love working from home: Warm purry kitty that sits on my lap to de-stress me from the nonsense I see in my email.
Reasons to hate working from home: Kitty locked out of office, yowling till I let her in, then curling up on lap and biting me every time I reach for the keyboard.
I can't win. Either I go to work and be insane or stay home and be bitten...
EDIT: On the other hand, it's really funny to be working from home, on a conference call with the cat locked out of the office and have everyone on the call trying to figure out where the yowling cat is and how it got into the building.
June 28, 2017 at 6:55 am
Brandie Tarvin - Wednesday, June 28, 2017 4:51 AMjonathan.crawford - Tuesday, June 27, 2017 9:01 AMJeff Moden - Monday, June 26, 2017 6:44 PMEric M Russell - Saturday, June 24, 2017 8:24 PMSo, did anyone else have a strangely intense dream recently about being, outside looking up at the night sky, and then a constellation of stars coalesce into a UFO that lands nearby?Crud. Sorry. Didn't mean for you to see me.
Great. Jeff's moved on from pork chop launchers to "nuke it from orbit". Nobody write any cursors!
HA! I defy your directive and write one anyway!
(Cursors do have their place, ya know).
Heh... what's the last cursor you wrote and what did it do?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 59,041 through 59,055 (of 66,568 total)
You must be logged in to reply to this topic. Login to reply