Forum Replies Created

Viewing 15 posts - 17,401 through 17,415 (of 59,102 total)

  • RE: rows to columns

    Charmer (6/27/2016)

    The ReportDate values can be anything. I want dynamic.

    Please see the following article for a simple method to make such reports dynamic.

    http://www.sqlservercentral.com/articles/Crosstab/65048/

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 28, 2016 at 7:14 am

    #1887277

  • RE: Update 1 of 3 tables based on parameter

    David92595 (6/28/2016)

    Hello,

    I am trying to dynamically update a table (as much as possible) based on a parameter. However, because I'm trying to avoid SQL injection I'm hard coding the table...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 28, 2016 at 7:02 am

    #1887270

  • RE: Return string between 2 characters from the end of the string

    Luis Cazares (6/27/2016)

    I'm sorry, but that doesn't help. I need the column definition, apparently you're using a char column, but that's just a guess. Read the articles linked in my...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 8:31 pm

    #1887155

  • RE: Is there a function to format the date like this ?

    mw112009 (6/27/2016)

    YB:

    This is not for display purposes.

    It is for a TAB delimited file that goes to another company.

    I am not sure why they can not handle dates in the mm/dd/yyyy...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 8:16 pm

    #1887153

  • RE: Drop the table and add the column

    Sangeeth878787 (6/27/2016)

    Hi,

    I need to add new column to the table, for this requirement is move the data to temp table and drop the table and create the same table with...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 8:44 am

    #1887068

  • RE: Reduce Log Database

    angelreynosog (6/27/2016)

    Dear good day ,

    I have a database of Dynamics NAV , this overgrown in the week do a FULL, every day at 3 A.M. , a differential every day...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 8:31 am

    #1887065

  • RE: Best way to filter columns

    frontrunner148 (6/27/2016)

    Jeff Moden (6/25/2016)

    My first inclination would be to use the UNIQUEIDENTIFIER datatype for the GUID instead of VARCHAR but that may be contrary to formatting of the data received....

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 8:25 am

    #1887060

  • RE: Date Range overlaps

    Nomvula (6/27/2016)

    thank you so much J Livingston SQL,

    it worked perfectly!!!

    Since you're the one that needs to support it, the question now is... can you? Do you actually understand how...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 8:22 am

    #1887057

  • RE: Need Help-DateFunctions

    koti.raavi (6/27/2016)

    Please find the query

    CREATE TABLE #NEXTMONTHS (

    Months DATE

    ,[Month No] INT

    ,[year] INT

    ,FYYear CHAR(10)

    )

    DECLARE @StartDate AS DATE

    DECLARE @EndDate AS DATE

    DECLARE @CurrentDate AS DATE

    DECLARE @ID INT = 0

    SET @StartDate = GETDATE()

    SET @EndDate...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 8:02 am

    #1887049

  • RE: Sql Duplicate Values

    Warned but armed.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 7:29 am

    #1887041

  • RE: Querying XML

    Eirikur Eiriksson (6/26/2016)

    It seems like just being able to produce a result set is currently the acceptable standard, regardless of the (in)efficiency of the query.

    With or without XML, that's...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 6:42 am

    #1887027

  • RE: Rename file - prefix with file date

    jeffe_verde (6/26/2016)

    The files have data for the Asia-Pacific, EU, and the Americas financial markets (thus the AP, EU, and AM in the file names), and each file is created after...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 6:33 am

    #1887022

  • RE: Sql Duplicate Values

    Eirikur Eiriksson (6/27/2016)

    Must say that I agree with Jeff here, this seems to be very fragile and error prone, ie. what if two customers have the same name?

    😎

    The deduplication part...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 6:28 am

    #1887021

  • RE: DevOps and Security

    Steve Jones - SSC Editor (6/25/2016)

    I understand concerns, but remember, Jeff, no code is ever unchecked. Part of the process is ensuring that code runs through a set of checks,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 6:20 am

    #1887018

  • RE: Rebuilding Indexes

    You're welcome but Gail (Gila Monster) is spot on. Rebuilding all indexes is a lot of overkill and causes a huge amount of logging unless you're in the BULK...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2016 at 5:58 am

    #1887013

Viewing 15 posts - 17,401 through 17,415 (of 59,102 total)