Forum Replies Created

Viewing 15 posts - 4,606 through 4,620 (of 8,731 total)

  • RE: Using PIVOT question - Very newbie

    johnnycash (7/23/2015)

    Thanks Luis! Very clean and precise, I like it. If I may take advantage of your disposition to help, I have instances when an OrderID will 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

    July 23, 2015 at 5:21 pm

    #1814611

  • RE: Variables are not displayed

    There´s a button in the Variables pane which allows you to move the variable. It´s the one with an arrow.

    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 23, 2015 at 5:11 pm

    #1814610

  • RE: Duplicate Index...or am I missing something?

    My guts tell me that the non-clustered indexes are redundant and certainly seem to come from the DTA which will suggest covering indexes for the query without considering modifications 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

    July 23, 2015 at 2:47 pm

    #1814579

  • RE: CONCATENATE a filed if the rows have the same Id

    I agree with Sean, this is kind of weird. However, here's a way to accomplish it.

    IF OBJECT_ID('SampleData', 'U') IS NOT NULL

    DROP TABLE SampleData;

    CREATE TABLE SampleData(

    ID int,

    Name varchar(100),

    Identifier varchar(100)

    );

    INSERT INTO...

    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 23, 2015 at 2:38 pm

    #1814575

  • RE: Variables are not displayed

    Be sure that you're under the correct scope.

    Are you missing the variables or the variables panel?

    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 23, 2015 at 2:11 pm

    #1814561

  • RE: selecting max between two dates for a given year

    lsalih (7/23/2015)

    Luis - Can you please tell me how you go about the max between start and end date?

    I unpivoted the dates, so I wouldn't care which column has 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 23, 2015 at 1:47 pm

    #1814546

  • RE: selecting max between two dates for a given year

    This seems to be what you're asking for. However, it seems awkward that you consider the enddate as an enrollment date.

    SELECT EMP.ID,

    EMP.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

    July 23, 2015 at 1:37 pm

    #1814536

  • RE: Why does SQL Server consider a value to be a column name??

    Alvin Ramard (7/22/2015)

    WayneS (7/22/2015)

    That's his signature... it's put on all of the posts automatically.

    It's not the first time an OP has shared his opinion about the signature. 🙂

    I just edited...

    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 23, 2015 at 12:33 pm

    #1814517

  • RE: How to Trim Values if more than 2 numbers after '.'?

    Technically, you don't take it and insert it back, you just update it. It might be the same thing worded differently, but it gives you the syntax needed.

    UPDATE AnnualClassifiedPAFs

    SET ROUND...

    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 23, 2015 at 11:10 am

    #1814467

  • RE: SUM OF TWO COLUMNS FROM TWO DIFFERENT TABLES IN THE SAME QUERY

    For instance, you have to remove the RAM.Capacity and Disk.DiskSize from your GROUP BY. You might also need to aggregate the values before joining the tables. This can 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

    July 23, 2015 at 9:30 am

    #1814435

  • RE: Are the posted questions getting worse?

    Sioban Krzywicki (7/23/2015)

    Wondering what you all would say if you were presented with a NoSQL system being developed for all your data and were told "It isn't meant 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

    July 23, 2015 at 9:18 am

    #1814429

  • RE: Where do you set an SSIS EvaluateAsExpression property of the variable to TRUE?

    In the properties section when you are positioned on the variable.

    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 23, 2015 at 9:14 am

    #1814426

  • RE: Today's Random Word!

    Ed Wagner (7/23/2015)

    eccentricDBA (7/23/2015)

    J Livingston SQL (7/22/2015)

    SQLRNNR (7/22/2015)

    Moreau

    Scaramouche

    Quixote

    Don

    Juan

    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 23, 2015 at 8:29 am

    #1814392

  • RE: Query Execution plan too long

    thenewbee (7/22/2015)

    NO because they wont allow to install 3rd party tools

    If no 3rd party tools are allowed, you're stuck with the 3 versions of execution plans (plain text, xml, graphic)....

    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 23, 2015 at 7:40 am

    #1814369

  • RE: Finding distinct columns issue

    sunil88_pal88 (7/22/2015)

    Many thanks Luis

    You're welcome.

    Do you understand how it works? Please post any questions that you have about this.

    Here are some references:

    Unpivot using CROSS APPLY: http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

    Cross tabs: http://www.sqlservercentral.com/articles/T-SQL/63681/

    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 23, 2015 at 7:35 am

    #1814364

Viewing 15 posts - 4,606 through 4,620 (of 8,731 total)