Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 8,731 total)

  • RE: Atomic Transaction.? - Not Quite......

    Why would you only have one note for each person? That seems illogical.
    However, here's an alternative that should handle concurrency in a better way.

    BEGIN...

    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 18, 2017 at 8:22 am

    #1943107

  • RE: Dynamic Statement with Cursor loop, help

    peter larsen-490879 - Wednesday, May 17, 2017 2:18 PM

    Hi again,

    this is the ouput i am trying to achive. 

    You gave the output, but...

    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 18, 2017 at 7:16 am

    #1943087

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Thursday, May 18, 2017 4:25 AM

    jonathan.crawford - Wednesday, May 17, 2017 9:09 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

    May 18, 2017 at 5:56 am

    #1943080

  • RE: [Best Practice] VARCHAR >> INT and Truncation

    ScottPletcher - Wednesday, May 17, 2017 10:57 AM

    Luis Cazares - Wednesday, May 17, 2017 7:27 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 17, 2017 at 12:31 pm

    #1942992

  • RE: how to select several columns with one being distinct

    perry.59 - Wednesday, May 17, 2017 10:08 AM

    As you can see in the screenshot below (I hope it is legible) I have...

    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 17, 2017 at 10:14 am

    #1942965

  • RE: How to pivot the row?

    Apparently, I left the code window open from when Jeff deleted the thread and I couldn't post anymore. It changes how you create the the ranges, so I'll post 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

    May 17, 2017 at 9:13 am

    #1942948

  • RE: How to pivot the row?

    You should pivot your values in SSRS. That will be more efficient.
    Here's how you do it: https://docs.microsoft.com/en-us/sql/reporting-services/report-design/create-a-matrix-report-builder-and-ssrs

    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 17, 2017 at 9:03 am

    #1942943

  • RE: Dynamic Statement with Cursor loop, help

    Why are you using CompanyName in your column list and dataname to relate between the tables?

    Here's an example on how to remove the loop and query in an...

    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 17, 2017 at 8:55 am

    #1942938

  • RE: SMALLDATETIME question

    Without even changing the parameter type.

    CREATE TABLE #SampleDates(
      SomeDate smalldatetime
    )
    CREATE CLUSTERED INDEX CISampleDates ON #SampleDates(SomeDate)

    INSERT INTO #SampleDates
    SELECT DATEADD( hh, (ABS(...

    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 17, 2017 at 7:50 am

    #1942913

  • RE: [Best Practice] VARCHAR >> INT and Truncation

    autoexcrement - Tuesday, May 16, 2017 4:17 PM

    But isn't the MONEY type a float? If so, you will have to be careful...

    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 17, 2017 at 7:27 am

    #1942904

  • RE: Heap vs Clustered Wildcard Search

    Depending on the length and available storage, this could be an option.
    https://sqlperformance.com/2017/02/sql-indexes/seek-leading-wildcard-sql-server

    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 16, 2017 at 1:55 pm

    #1942784

  • RE: [Best Practice] VARCHAR >> INT and Truncation

    Tennim - Tuesday, May 16, 2017 1:44 PM

    Cheers Luis,

    Completly agree that the data definition is the root of my problems.

    I've tested...

    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 16, 2017 at 1:51 pm

    #1942783

  • RE: [Best Practice] VARCHAR >> INT and Truncation

    Tennim - Tuesday, May 16, 2017 1:24 PM

    So, i'm currently using the below to change a VARCHAR field over to a INT...

    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 16, 2017 at 1:29 pm

    #1942777

  • RE: Your Favorite Feature that Needs Work

    Somehow, the explanations defending the sum of an empty set as null don't make as much sense as the arithmetic explanation from Tom.
    SUM is essentially a mathematical function, 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

    May 16, 2017 at 12:15 pm

    #1942760

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Tuesday, May 16, 2017 10:40 AM

    Luis Cazares - Tuesday, May 16, 2017 10:35 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 16, 2017 at 10:55 am

    #1942735

Viewing 15 posts - 1,261 through 1,275 (of 8,731 total)