Are the posted questions getting worse?

  • I particularily enjoy pasting dates into excel, sort of like a box of chocolates ...

     

  • 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

  • x wrote:

    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

  • Robert Sterbal wrote:

    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


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Robert Sterbal wrote:

    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

  • 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/

  • Better than my Zoom. Just a cat jumping on the desk

  • 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*

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • 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.

    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/

  • Someone has to come clean, where is the Crystal Ball?

    😎

  • Robert Sterbal wrote:

    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!

     

    • This reply was modified 5 years ago by x.
  • Michael L John wrote:

    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.

    😎

  • 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.

  • 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.

     

  • jonathan.crawford wrote:

    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