Forum Replies Created

Viewing 15 posts - 976 through 990 (of 5,109 total)

  • Reply To: Rolling Months - Calculations

    koti.raavi wrote:

    Thom, Thanks for response, Can u have look output once, it is contains both 2018 and 2019 years data- derived based on current month. Thanks!

    In the sample data there...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 17, 2019 at 3:22 pm

    #3644618

  • Reply To: Rolling Months - Calculations

    This is a just an unpivot. Personally, I prefer using a VALUES clause to unpivot the data, rather than the UNPIVOT operator. This ends up giving you the below:

    Thom~
    

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    
Larnu.uk

    May 17, 2019 at 2:45 pm

    #3644604

  • Reply To: ISNULL vs COALESCE

    Sue_H wrote:

    Nope all worked, meant exactly what I wrote. There have been problems with other QoDs with broken links, incorrect explanations and just poor questions. In comparison to some of...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 17, 2019 at 2:16 pm

    #3644584

  • Reply To: ISNULL vs COALESCE

    Sue_H wrote:

    I think the thorough explanation, links (that worked) are great!

    Did one links not work for you Sue? I tried them and they all seemed to work, but if...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 17, 2019 at 8:05 am

    #3644463

  • Reply To: sql server 2017 INSERT and UPDATE lock database

    emanuele 8962 wrote:

    Hi, how "offline" process?

    As in, when the system isn't being used by users. Another phrase would be "out of hours". So, you might do the process between 01:00 and...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 15, 2019 at 1:30 pm

    #3642357

  • Reply To: sql server 2017 INSERT and UPDATE lock database

    You'll find it unlikely that many of us are going to download that zip file, but for those that aren't, I did download it to a Pi to extract instead....

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 15, 2019 at 1:13 pm

    #3642344

  • Reply To: SSIS Unexpectedly Fails

    rcarmack wrote:

    So, the question is - why didn't the SSIS packages fail long before?

    This might seem like a silly thing to say, but they didn't fail before because...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 14, 2019 at 7:05 pm

    #3642074

  • Reply To: Are the posted questions getting worse?

    The PDF problem isn't something I've experienced yet at the office, but if this is actually true this will have huge ramifications for us at the office; we produce all...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 14, 2019 at 6:55 pm

    #3642062

  • Reply To: T-SQL to compress (shorten) IPv6 address

    What your your reasons for choosing to use a WHILE loop here, and a multi-line scalar function? Inline Table-value functions are extremely powerful, and quick (as in inline scalar functions...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 14, 2019 at 10:03 am

    #3641809

  • Reply To: SQL Date calculation

    Those expected results don't appear to be representative of the example data. Where is sales persons 2 - 9? Sales Person 1 has 5 days off in April in your...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 14, 2019 at 9:54 am

    #3641803

  • Reply To: Are the posted questions getting worse?

    Jeff Moden wrote:

    I can't find any documentation on it because the official 2019 deprecated features hasn't been made public yet but does anyone know if sys.sysindexes is still available in 2019?

    it's...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 14, 2019 at 9:09 am

    #3641796

  • Reply To: SQL Date calculation

    seismicbeat wrote:

    There are number of selections (Duration) available while entering time off territory. PM Off, AM Off, All Day, 2 Days, 3 Days, 4 Days, 5 Days, Long Absence.

    Are those...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 14, 2019 at 8:14 am

    #3641790

  • Reply To: SQL Date calculation

    Hmm, "30 days" for a month is a bad assumption in my view, Scott. Considering that 7 months have 31 days, and 1 has 28(/29), assuming 1 month is 30...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 13, 2019 at 9:50 pm

    #3641687

  • Reply To: SQL Date calculation

    I have to ask, why is Duration a varchar(50), and why is the value '5 days'? Does that mean you might have values like "2 weeks" or even 1 month"?...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 13, 2019 at 8:11 pm

    #3641676

  • Reply To: Can't paste images anymore

    Steve Jones - SSC Editor wrote:

    Looking at SO, they use imgur to upload the image for you. I'll see if we can do something similar.

    Sounds good. If not, then I'm sure we'll survive anyway...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

    May 13, 2019 at 4:15 pm

    #3641585

    • Viewing 15 posts - 976 through 990 (of 5,109 total)