Forum Replies Created

Viewing 15 posts - 496 through 510 (of 8,731 total)

  • RE: Primary key incrementation

    Here are some pages where you can read about Sequences:
     https://docs.microsoft.com/en-us/sql/relational-databases/sequence-numbers/sequence-numbers?view=sql-server-2017
     https://www.red-gate.com/simple-talk/sql/learn-sql-server/sql-server-sequence-basics/
     http://www.tech-recipes.com/rx/60072/beginners-guide-sequence-objects-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

    June 7, 2018 at 1:29 pm

    #1993304

  • RE: DelimitedSplit8k and Performance

    If someone is interested on code that is actually readable and without errors.

    CREATE TABLE [dbo].[GL_Source]
    (
      [GLS_ID] [UNIQUEIDENTIFIER] ROWGUIDCOL NOT NULL CONSTRAINT [DF_GLS_ID] DEFAULT (NEWID()),

    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

    June 7, 2018 at 1:08 pm

    #1993302

  • RE: How do you do select and update together that actually works?

    xboxown - Thursday, June 7, 2018 11:49 AM

    Luis Cazares - Thursday, June 7, 2018 11:34 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

    June 7, 2018 at 12:25 pm

    #1993297

  • RE: Primary key incrementation

    xboxown - Thursday, June 7, 2018 11:21 AM

    OK. I will explain how this is working out. I have Microsoft Access front 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

    June 7, 2018 at 12:16 pm

    #1993291

  • RE: How do you do select and update together that actually works?

    By the way, you shouldn't be updating the whole table every time. Use a WHERE clause to limit the work that needs to be done.

    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

    June 7, 2018 at 11:34 am

    #1993278

  • RE: How do you do select and update together that actually works?

    You could simply update in a set-based way without going row by row.

    UPDATE i SET
      [InvoiceMethod]=c.PreferredInvoiceMethod
    FROM tblCompany     AS c
    JOIN tblWorkOrder    ...

    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

    June 7, 2018 at 11:32 am

    #1993276

  • RE: DelimitedSplit8k and Performance

    Have you tried with the DelimitedSplit8K_Lead?
    http://www.sqlservercentral.com/articles/SQL+Server+2012/106903/

    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

    June 7, 2018 at 9:44 am

    #1993255

  • RE: Are the posted questions getting worse?

    jasona.work - Thursday, June 7, 2018 9:20 AM

    Lynn Pettis - Thursday, June 7, 2018 8:59 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

    June 7, 2018 at 9:37 am

    #1993253

  • RE: Can anyone explain why this isn't populating the two desired columns?

    I would check these expressions. You might be confused on what you're doing.
    LEFT(cnd.Name, CHARINDEX(':', LEN(cnd.Name) - 1))
    LEFT(cnd.Name, CHARINDEX(' ', REVERSE(LEN(cnd.Name))))

    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

    June 7, 2018 at 7:00 am

    #1993206

  • RE: Primary key incrementation

    Chris Harshman - Thursday, June 7, 2018 6:45 AM

    Wow, I didn't even realize that's what the OP was saying they were doing. ...

    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

    June 7, 2018 at 6:57 am

    #1993205

  • RE: Primary key incrementation

    xboxown - Wednesday, June 6, 2018 1:02 PM

    Hello,

    I know from Microsoft Access when you enter any value in any column it automatically...

    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

    June 6, 2018 at 1:53 pm

    #1993150

  • RE: Date Conversion

    tmmutsetse - Wednesday, June 6, 2018 7:44 AM

    Good Experts, 
    Please help me to convert and  find the difference in HH:MM:SS format between 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

    June 6, 2018 at 8:06 am

    #1993090

  • RE: Scalar Functions with Query Plans: Not all is obvious!

    Ray Herring - Tuesday, June 5, 2018 1:23 PM

    Mike Byrd - Tuesday, June 5, 2018 12:44 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

    June 6, 2018 at 6:38 am

    #1993077

  • RE: Inner Joins

    And I usually work on an opposite way

    SELECT
        o.name              AS ObjName,
        ix.name             AS IxName ,
        ic.index_column_id  AS IxColId
    FROM sys.objects        o

    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

    June 6, 2018 at 6:31 am

    #1993073

  • RE: Scalar Functions with Query Plans: Not all is obvious!

    Ray Herring - Tuesday, June 5, 2018 11:01 AM

    It is clear that the  query change was an improvement but I suggest that...

    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

    June 5, 2018 at 12:58 pm

    #1993008

Viewing 15 posts - 496 through 510 (of 8,731 total)