Forum Replies Created

Viewing 15 posts - 1,561 through 1,575 (of 8,731 total)

  • RE: Today's Random Word!

    Ray K - Monday, February 20, 2017 8:35 AM

    Ed Wagner - Thursday, February 16, 2017 12:42 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

    February 20, 2017 at 9:30 am

    #1929381

  • RE: Site Suggestion

    The link on the left menu will show unread. It would be better if it show all the latest.

    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

    February 17, 2017 at 7:37 am

    #1929108

  • RE: Convert first column in row without duplicate values, and second column in rows

    benkraiemchedlia - Friday, February 17, 2017 12:31 AM

    Jeff Moden - Thursday, February 16, 2017 10:39 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

    February 17, 2017 at 5:44 am

    #1929063

  • RE: Convert first column in row without duplicate values, and second column in rows

    How do you know which answers go on the same row? Remember that tables aren't ordered by default.

    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

    February 16, 2017 at 1:43 pm

    #1928966

  • RE: Efficient way of writing this stored procedure (Takes too much time to run)

    muralikrishna2489 - Thursday, February 16, 2017 1:25 PM

    Hi Luis,

    I have got it 🙂 ...
    I have used below query to get 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

    February 16, 2017 at 1:28 pm

    #1928961

  • RE: Efficient way of writing this stored procedure (Takes too much time to run)

    muralikrishna2489 - Thursday, February 16, 2017 12:29 PM

    Hi Luis , Sgmunson, Ken Mckelvey

    Thanks very much for explaining the current problem and...

    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

    February 16, 2017 at 12:46 pm

    #1928947

  • RE: Are the posted questions getting worse?

    Congratulations to Gail and Jeff for becoming the first SSC Gurus and probably didn't notice.
    The new points system is going to devaluate the points. I might no longer 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

    February 16, 2017 at 12:26 pm

    #1928935

  • RE: Efficient way of writing this stored procedure (Takes too much time to run)

    muralikrishna2489 - Thursday, February 16, 2017 12:19 PM

    Hi 

    GilaMonster - Thursday, February 16, 2017 12:37 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

    February 16, 2017 at 12:22 pm

    #1928934

  • RE: Is having a lookup table that is for multiple entities a common practice?

    As said before, the OTLT (or anything similar) is a bad design.
    However, it shouldn't be confused with a "Junk Dimension" when building a data warehouse. The junk dimensions 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

    February 16, 2017 at 12:20 pm

    #1928931

  • RE: Efficient way of writing this stored procedure (Takes too much time to run)

    Just a basic approach using cross tabs to avoid massaging the data for pivot.
    I also changed the old-syntax join to keep the code consistent and used table alias 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

    February 16, 2017 at 8:39 am

    #1928866

  • RE: Wildcard Searches

    webrunner - Tuesday, February 14, 2017 1:28 PM

    Thanks for this article!

    I have one question based on creating the sample data. I got...

    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

    February 14, 2017 at 1:34 pm

    #1928485

  • RE: How to Pivot Financial Data Rows Into Dynamic Columns

    Something like this?

    WITH Months AS(
      SELECT DISTINCT dtMonth
      FROM [TOTALS]
      WHERE dtMonth BETWEEN '2014/01/01' and '2014/06/01'
    )
    SELECT N'SELECT sEntityCode
     ...

    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

    February 14, 2017 at 12:39 pm

    #1928472

  • RE: Use of CONCAT function in datetime column.

    Lowell - Tuesday, February 14, 2017 10:56 AM

    There's more than one way to do that.
    in my case, the convert function would work...

    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

    February 14, 2017 at 12:16 pm

    #1928457

  • RE: Today's Random Word!

    Code Monkey, the SQL - Tuesday, February 14, 2017 10:18 AM

    Ed Wagner - Tuesday, February 14, 2017 8:30...

    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

    February 14, 2017 at 10:33 am

    #1928423

  • RE: Upgrade to 2016 questions

    andrew.smith-613492 - Tuesday, February 14, 2017 10:03 AM

    All,

    Unfortunately we are still running a SQL server 2000 server. I've got provisional approval 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

    February 14, 2017 at 10:31 am

    #1928422

Viewing 15 posts - 1,561 through 1,575 (of 8,731 total)