Forum Replies Created

Viewing 15 posts - 556 through 570 (of 8,731 total)

  • RE: Most efficient way of not selecting data

    ChrisM@Work - Friday, May 4, 2018 4:37 AM

    SQL Server will apply filters and joins in whatever order is calculated to be...

    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

    May 4, 2018 at 8:12 am

    #1989289

  • RE: The SQL Joke Thread

    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

    May 3, 2018 at 12:05 pm

    #1989138

  • RE: Most efficient way of not selecting data

    webskater - Wednesday, May 2, 2018 5:32 PM

    Thank you all for your answers. I'll try them on the real data tomorrow and...

    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

    May 3, 2018 at 8:11 am

    #1989082

  • RE: Most efficient way of not selecting data

    webskater - Wednesday, May 2, 2018 12:24 PM


    CREATE

    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

    May 2, 2018 at 12:39 pm

    #1988986

  • RE: Upper Case Lower Case

    Ed Wagner - Wednesday, May 2, 2018 11:28 AM

    Jason A. Long - Wednesday, May 2, 2018 10:37...

    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

    May 2, 2018 at 11:44 am

    #1988974

  • RE: Upper Case Lower Case

    sgmunson - Tuesday, May 1, 2018 10:43 AM

    Sowbhari - Tuesday, May 1, 2018 9:37 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

    May 1, 2018 at 12:38 pm

    #1988846

  • RE: UDF showing weird behavior when checking if variable holds null value.

    I haven't tested, but this should work.

    CREATE FUNCTION dbo.fn_ck_newBidIsHigher(@auction int, @bid numeric(8,2))
    RETURNS bit
    BEGIN
      RETURN (SELECT CAST(CASE WHEN EXISTS( SELECT 1 FROM Bid WHERE...

    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

    May 1, 2018 at 10:39 am

    #1988814

  • RE: Small numbers in the cube shown as zero in excel - rounding error?

    It's great that you found a solution and posted it on here. Thank you very much for doing it.

    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

    April 30, 2018 at 7:36 am

    #1988629

  • RE: How to convert months into weeks

    I can post a solution for this but it would work on SQL Server. You're working with Oracle, so you should check on an Oracle forum or http://stackoverflow.com/

    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

    April 26, 2018 at 10:09 am

    #1988383

  • RE: Pivot to get all rows

    I've always find simpler to use cross-tabs instead of the pivot operator. It's more flexible and it can become simpler and faster.

    SELECT BookType,
       SUM( CASE...

    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

    April 26, 2018 at 10:00 am

    #1988379

  • RE: Index REBUILD doesn't work with SORT_IN_TEMPDB = ON

    powelluss - Thursday, April 26, 2018 4:32 AM

    I'm trying to troubleshoot why an index rebuild doesn't work with WITH (SORT_IN_TEMPDB = ON, ONLINE...

    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

    April 26, 2018 at 9:54 am

    #1988377

  • RE: Need Help on writing SP

    KGNH - Wednesday, April 25, 2018 11:08 PM

    Hi I am novice in SQL development and want help on writing a procedure. My...

    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

    April 26, 2018 at 9:53 am

    #1988375

  • RE: Dashboard

    Steve Jones - SSC Editor - Thursday, April 26, 2018 9:26 AM

    Power BI

    One more vote for this.

    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

    April 26, 2018 at 9:45 am

    #1988373

  • RE: How to convert months into weeks

    soldout6000 - Wednesday, April 25, 2018 8:14 PM

    I have to split the first three months into weeks. All the weeks should end...

    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

    April 26, 2018 at 9:29 am

    #1988369

  • RE: Using CASE in a View

    sgmunson - Tuesday, April 24, 2018 10:36 AM

    MMartin1 - Wednesday, April 11, 2018 10:24 PM

    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

    April 24, 2018 at 10:56 am

    #1988079

Viewing 15 posts - 556 through 570 (of 8,731 total)