Forum Replies Created

Viewing 15 posts - 2,836 through 2,850 (of 8,731 total)

  • RE: Simple query question

    A different option. I included sample data generation, in case someone else want s to try something. It should have been provided by you in this way to prevent time...

    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 19, 2016 at 11:41 am

    #1880320

  • RE: error message when trying to save code as a view, but runs fine in SSMS

    Some tools available are Redgate's SQL Prompt, ApexSQL Refactor and Poor Man's T-SQL Formatter.

    I use the 2 latest because they're free, but I know that SQL Prompt has more capabilities....

    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 19, 2016 at 8:31 am

    #1880260

  • RE: Inline query to perform specific operation

    This will allow to handle multiple occurrences. It uses a pattern splitter that is explained in here: http://www.sqlservercentral.com/articles/String+Manipulation/94365/

    And string concatenation explained in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    SELECT *,

    LTRIM((SELECT 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

    May 19, 2016 at 8:04 am

    #1880252

  • RE: Can anyone explain this in plain English? What it is doing functionally?

    matthewjamesnel (5/19/2016)

    a

    a

    /a,?/

    determiner

    1.

    used when referring to someone or something for the first time in a text or conversation.

    "a man came out of the room"

    2.

    used to indicate membership of a class of...

    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 19, 2016 at 7:48 am

    #1880248

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (5/19/2016)

    Brandie Tarvin (5/19/2016)

    GilaMonster (5/19/2016)

    Lynn Pettis (5/18/2016)

    Found this on my Facebook newsfeed: https://www.packtpub.com/packt/offers/data-week-2016.

    Oooh. Am very tempted to grab both the R and the Data bundles.

    The free book yesterday (Machine...

    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 19, 2016 at 7:46 am

    #1880246

  • RE: How to avoid multiple if else in sql server

    Similar to what Lowell already posted, but leaving values as variables.

    DECLARE @A AS INT = 1;

    DECLARE @b-2 AS INT = 1;

    DECLARE @Parameter1 AS INT;

    DECLARE @Parameter2 AS INT;

    DECLARE @Parameter3 AS INT;

    DECLARE...

    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, 2016 at 12:09 pm

    #1879954

  • RE: The SQL Saturday Thread

    Ray K (5/18/2016)

    Luis Cazares (5/17/2016)

    This is sad, because this Saturday is my wife's birthday and SQL Saturday #521 in Atlanta. She wouldn't enjoy if I leave her the whole day...

    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, 2016 at 10:16 am

    #1879923

  • RE: error message when trying to save code as a view, but runs fine in SSMS

    Try to format your code. You'll thank yourself later.

    ALTER VIEW dbo.ViewName

    AS

    SELECT t001.ScenarioID

    ,t001.accountnum

    ,t001.ACCOUNTNAME

    ,t001.dimension

    ,t001.GroupID

    ...

    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, 2016 at 12:38 pm

    #1879663

  • RE: Today's Random Word!

    Ed Wagner (5/17/2016)

    djj (5/17/2016)

    Ed Wagner (5/17/2016)

    Revenant (5/17/2016)

    ZZartin (5/17/2016)

    HappyGeek (5/17/2016)

    yb751 (5/17/2016)

    Ed Wagner (5/17/2016)

    Luis Cazares (5/17/2016)

    ThomasRushton (5/17/2016)

    crookj (5/17/2016)

    Ray K (5/17/2016)

    DonlSimpson (5/17/2016)

    Filling

    Pie

    Banana (cream)

    Split

    Van Damme

    Bloodsport

    Action

    Movie

    Silver

    Dollar

    Pancake

    Waffle

    Syrup

    Maple

    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, 2016 at 12:28 pm

    #1879655

  • RE: The SQL Saturday Thread

    This is sad, because this Saturday is my wife's birthday and SQL Saturday #521 in Atlanta. She wouldn't enjoy if I leave her the whole day by herself.

    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, 2016 at 11:11 am

    #1879617

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (5/17/2016)

    Brandie Tarvin (5/17/2016)

    I am really really beginning to hate Data Tools. Anyone with SSIS 2012 experience willing or able to comment on this problem?

    What are...

    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, 2016 at 10:53 am

    #1879607

  • RE: Today's Random Word!

    ThomasRushton (5/17/2016)

    crookj (5/17/2016)

    Ray K (5/17/2016)

    DonlSimpson (5/17/2016)

    Filling

    Pie

    Banana (cream)

    Split

    Van Damme

    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, 2016 at 10:03 am

    #1879584

  • RE: Calculating Sharpe's Ratio, Standard Deviation, and Sorentino's Ratio

    SQLKnowItAll (5/17/2016)

    Luis Cazares (5/17/2016)

    Are we all aware that SQL Server includes the STDEV and VAR functions?

    Other than the nulls being ignored, it should be easier to use.

    1. I...

    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, 2016 at 9:50 am

    #1879580

  • RE: SSIS automation through command line

    Thank you, I'm checking if we can actually configure Kerberos adequately to fix this issue.

    For using config files, we would be using package deployment or file system instead of 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 17, 2016 at 8:03 am

    #1879540

  • RE: Calculating Sharpe's Ratio, Standard Deviation, and Sorentino's Ratio

    Are we all aware that SQL Server includes the STDEV and VAR functions?

    Other than the nulls being ignored, it should be easier to use.

    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, 2016 at 7:38 am

    #1879530

Viewing 15 posts - 2,836 through 2,850 (of 8,731 total)