August 11, 2020 at 8:11 pm
I particularily enjoy pasting dates into excel, sort of like a box of chocolates ...
August 11, 2020 at 8:36 pm
It takes less than 10 keystrokes to convert a column to text. (Ctrl + space, alt + 1, alt + C, t, t enter)
I'm getting the impression that you think a product for hundreds of millions of users has to work the way you want it to. If it doesn't, the product is bad.
412-977-3526 call/text
August 11, 2020 at 9:08 pm
I particularily enjoy pasting dates into excel, sort of like a box of chocolates ...
Spring Surprise or Lamb's Bladder Cup?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2020 at 3:07 am
I'm getting the impression that you think a product for hundreds of millions of users has to work the way you want it to. If it doesn't, the product is bad.
Heh... Correct! 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
August 12, 2020 at 8:11 am
It takes less than 10 keystrokes to convert a column to text. (Ctrl + space, alt + 1, alt + C, t, t enter)
I'm getting the impression that you think a product for hundreds of millions of users has to work the way you want it to. If it doesn't, the product is bad.
10~ key strokes to do that is a lot of key strokes in my mind. This is actually one of those times where it's actually probably quicker and easier to use the mouse.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 12, 2020 at 4:32 pm
So, getting my 8 and 10 year old grand kids to take showers during the Covid crisis has been tough. Today, after a lot of begging, the 8 year old finally goes and gets a shower.
I'm on my weekly Teams call with my boss, and a semi-naked wet little boy comes strolling up behind me. My boss lost it. He was laughing so hard he had to end the meeting.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 12, 2020 at 4:54 pm
Better than my Zoom. Just a cat jumping on the desk
August 12, 2020 at 5:27 pm
So, getting my 8 and 10 year old grand kids to take showers during the Covid crisis has been tough. Today, after a lot of begging, the 8 year old finally goes and gets a shower.
I'm on my weekly Teams call with my boss, and a semi-naked wet little boy comes strolling up behind me. My boss lost it. He was laughing so hard he had to end the meeting.
hahaha....sounds familiar. "You need to take a shower"....."um, how about tomorrow" *finger guns*
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
August 12, 2020 at 6:33 pm
Michael L John wrote:So, getting my 8 and 10 year old grand kids to take showers during the Covid crisis has been tough. Today, after a lot of begging, the 8 year old finally goes and gets a shower.
I'm on my weekly Teams call with my boss, and a semi-naked wet little boy comes strolling up behind me. My boss lost it. He was laughing so hard he had to end the meeting.
hahaha....sounds familiar. "You need to take a shower"....."um, how about tomorrow" *finger guns*
Well, today was "I just took a shower". I asked when. He said 'When I was at grandmas". That was 4 days ago.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 12, 2020 at 7:49 pm
Someone has to come clean, where is the Crystal Ball?
😎
August 12, 2020 at 7:49 pm
It takes less than 10 keystrokes to convert a column to text. (Ctrl + space, alt + 1, alt + C, t, t enter)
I'm getting the impression that you think a product for hundreds of millions of users has to work the way you want it to. If it doesn't, the product is bad.
Well for my comment, I actually would like it to do some work with this. I'm not really sure how the clipboard internals looks coming from SSMS for instance and I get that, its been a long time since I coded using the copy paste buffer for any windows api (literally 16 bit windows the last time I read a copy paste buffer with c). But man, the interpretation excel gives to any date looking thing from the copy / paste buffer is baffling, the windows programmers have obviously put much effort into interpreting this into SOMETHING because of what I see get pasted if I DON'T format the receiving cells as text.
Check it out sometime, I'd be curious if anybody knew what the excel programmers were actually trying to do with a date time value to end up with what actually gets pasted, I'm sure somebody smarter than me might have an idea. Do you?
Maybe scientific notation? Internal SQL bit patterns as a representation of date? *shrug* beats the heck out of me LOL
edit: I'd think MAYBE its because of what SSMS pokes into the buffer from an SSMS date column but then why does a text formatted cell then work fine? I remain clueless!
August 12, 2020 at 7:53 pm
jonathan.crawford wrote:Michael L John wrote:So, getting my 8 and 10 year old grand kids to take showers during the Covid crisis has been tough. Today, after a lot of begging, the 8 year old finally goes and gets a shower.
I'm on my weekly Teams call with my boss, and a semi-naked wet little boy comes strolling up behind me. My boss lost it. He was laughing so hard he had to end the meeting.
hahaha....sounds familiar. "You need to take a shower"....."um, how about tomorrow" *finger guns*
Well, today was "I just took a shower". I asked when. He said 'When I was at grandmas". That was 4 days ago.
Got the opposite problem, have to shower before dawn as otherwise, our single bathroom is occupied.
😎
August 12, 2020 at 9:52 pm
Excel uses it’s own serial date system to store a date. Take a cell with a date in it and change the format to General. Time is decimal part of a day. Seem to recall it starting at 1900.
Reminds me of JDE and their version of Julian Dates.
Just wait - another Y2K type of event will happen.
August 12, 2020 at 10:14 pm
IIRC, there is also a difference in the dates in Excel and SQL Server. Only problem is that I don't quite remember what the problem, had I haven't had much luck with my google fu to find it.
August 12, 2020 at 10:29 pm
Excel: enable bad solutions
Access: implement bad solutions that require other bad solutions in order to function
PowerBI: Automate all the bad solutions with a bad process, and call it "data science"
I love Access, I can create giant disasters in a fraction of the time it usually takes me!
Viewing 15 posts - 65,011 through 65,025 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply