Forum Replies Created

Viewing 15 posts - 376 through 390 (of 8,731 total)

  • RE: How to get min and max date?

    saravanatn - Wednesday, August 1, 2018 8:07 AM

    Awesome solution Luis . I think this is another level.

    Thank you, but it's only...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 1, 2018 at 8:17 am

    #1999880

  • RE: CTE query help

    chillirollercoaster - Wednesday, August 1, 2018 7:50 AM

    Hi am trying to obtain the average by days and I suspect I need to...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 1, 2018 at 7:58 am

    #1999873

  • RE: How to get min and max date?

    This would work if you always have contiguous dates. Otherwise, you might need an additional ROW_NUMBER function.

    WITH CTE AS(
      SELECT *, DATEDIFF(dd, ROW_NUMBER() OVER (PARTITION...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 1, 2018 at 7:01 am

    #1999868

  • RE: Finding a String Anywhere in Another String

    hakan_l_borg - Wednesday, August 1, 2018 2:53 AM

    Hi, thanks for the post! Have you considered trying parallellism such as partition the table...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 1, 2018 at 6:51 am

    #1999863

  • RE: Are the posted questions getting worse?

    Sean Lange - Tuesday, July 31, 2018 9:17 AM

    Jeff Moden - Tuesday, July 31, 2018 8:53 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 31, 2018 at 9:34 am

    #1999708

  • RE: Finding a String Anywhere in Another String

    Thank you for taking the time to write the article. I found out about this option last year when Aaron Bertrand wrote about it. If someone wants to read more...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 31, 2018 at 9:20 am

    #1999704

  • RE: Pivoting Very Large Data

    I'm curious. Who would read a row like that? What is this good for?
    There's a good reason for people in Microsoft not trying to deliver a wider row. It's...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 30, 2018 at 2:29 pm

    #1999574

  • RE: Converting a COALESCE statement to varchar

    meichmann - Monday, July 30, 2018 12:32 PM

    So here's my question.  Can I use COALESCE and convert it to a string?  I...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 30, 2018 at 1:32 pm

    #1999566

  • RE: Are the posted questions getting worse?

    jasona.work - Monday, July 30, 2018 8:16 AM

    Hmm...
    Maybe I'm not as critical at work as I like to pretend...

    No one is.
    One previous...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 30, 2018 at 9:18 am

    #1999500

  • RE: SQL/DBA freelance work

    You could post a profile at some freelance sites. You should also, at least, post a link to your LinkedIn profile, personal site/blog, or some other place to show your...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 27, 2018 at 9:17 am

    #1999259

  • RE: Most recent non-null record; Tracking data provenance in calculations

    Probably something like this?

    WITH CTE AS(
      SELECT
       CASE
        WHEN EntityType = 'A' THEN DataPoint1
        WHEN EntityType = 'B'...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 26, 2018 at 2:04 pm

    #1999167

  • RE: How to calculate Median for each group

    super48 - Thursday, July 26, 2018 11:04 AM

    How can i calculate median in SSRS for each group.
    i have created custom vb code...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 26, 2018 at 12:00 pm

    #1999146

  • RE: How can I make my SQL statement smaller so my server doesn't time out?

    This solution is untested and might not even solve the problem. It's using what should be generic SQL (except for the variables).
    The lenght of the code is not the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 26, 2018 at 11:16 am

    #1999141

  • RE: Are the posted questions getting worse?

    Jeff Moden - Thursday, July 26, 2018 7:33 AM

    Again, no need to pile on but I wanted you to see this one,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 26, 2018 at 7:45 am

    #1999097

  • RE: How to restore SQL server database from damaged MDF file?

    --Deleted post

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 26, 2018 at 7:26 am

    #1999085

Viewing 15 posts - 376 through 390 (of 8,731 total)