Forum Replies Created

Viewing 15 posts - 226 through 240 (of 928 total)

  • RE: Monthly total of active data

    drew.allen (10/5/2016)

    Why are some people with partial months included and others excluded? Is there a minimum number of days required to be counted? Or are you only counting people...

    October 6, 2016 at 2:07 am

    #1905098

  • RE: Want to learn SQL

    chatwithgeorgelucas (9/22/2016)

    Hey Jeff, Can you please provide me the link. Thanks in advance.

    In case you've misunderstood Jeff's humour -

    Using either Yahoo, Google or Bing search for "SQL Tutorial" -...

    September 22, 2016 at 1:55 am

    #1902358

  • RE: Are the posted questions getting worse?

    jasona.work (9/21/2016)

    So a book I'm currently reading (highly recommend, I've actually laughed out loud because of what I'm about to tell you) has possibly the BEST explanation for why computer...

    September 22, 2016 at 1:45 am

    #1902355

  • RE: Are the posted questions getting worse?

    New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26

    But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read better and it would...

    September 20, 2016 at 9:50 am

    #1901930

  • RE: T-SQL: EOMONTH

    gareth.davison (9/20/2016)

    Alvin Ramard (9/19/2016)

    BrainDonor (9/19/2016)

    I couldn't see any of the answers that matched what I believed I should be getting - then I played around a little.

    Where dates are concerned...

    September 20, 2016 at 6:31 am

    #1901837

  • RE: T-SQL: EOMONTH

    I've played a little more (this is a nice diversion from trying to understand reduction and distribution in QlikView) and it appears to depend upon the use of the hyphens.

    The...

    September 19, 2016 at 10:20 am

    #1901679

  • RE: T-SQL: EOMONTH

    Alvin Ramard (9/19/2016)

    BrainDonor (9/19/2016)

    I couldn't see any of the answers that matched what I believed I should be getting - then I played around a little.

    Where dates are concerned it...

    September 19, 2016 at 8:54 am

    #1901647

  • RE: VALUES limit

    Iwas Bornready (9/19/2016)

    BrainDonor (9/16/2016)

    RoNoS (9/16/2016)

    Same as 'Select top 1000' default value. Or 'Edit top 200'. Where does those numbers come from?

    They are defaults within Tools/Options/SQL Server Object Explorer/Commands (in SSMS...

    September 19, 2016 at 8:41 am

    #1901641

  • RE: T-SQL: EOMONTH

    I couldn't see any of the answers that matched what I believed I should be getting - then I played around a little.

    Where dates are concerned it is probably helpful...

    September 19, 2016 at 2:04 am

    #1901571

  • RE: VALUES limit

    RoNoS (9/16/2016)

    Same as 'Select top 1000' default value. Or 'Edit top 200'. Where does those numbers come from?

    They are defaults within Tools/Options/SQL Server Object Explorer/Commands (in SSMS 2014 - may...

    September 16, 2016 at 2:21 am

    #1901293

  • RE: Are the posted questions getting worse?

    I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch" type of determination), but I'm so glad I'm not...

    September 9, 2016 at 2:42 am

    #1899974

  • RE: Are the posted questions getting worse?

    GilaMonster (9/1/2016)

    I uploaded the slide-deck in progress. Comments?

    http://www.sqlsaturday.com/554/Sessions/Details.aspx?sid=53948

    I don't know who else (if anyone) is on the panel. Guess it'll be a surprise on the day.

    That's quite good for the...

    September 1, 2016 at 9:14 am

    #1898801

  • RE: 2016 for the JSON or a third-party control

    Thanks Phil, it's along the lines I was thinking too.

    I'm going to ask for the ZappSys product as it includes some other bits and pieces I believe we can...

    August 25, 2016 at 3:26 am

    #1897415

  • RE: SOME/ANY/ALL

    I think it should have read 'if an additional row with NULL is inserted'.

    Just the pedant in me but it does give a different result if you replace one of...

    August 18, 2016 at 2:00 am

    #1896083

  • RE: Are the posted questions getting worse?

    ChrisM@Work (8/17/2016)

    We have git hubs all over the UK. They're also known as Weatherspoons.

    You owe me a new keyboard...

    August 17, 2016 at 2:58 am

    #1895862

Viewing 15 posts - 226 through 240 (of 928 total)