Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 8,731 total)

  • RE: Running Total

    robertopmorris - Friday, April 7, 2017 2:04 PM

    Jeff:

    Thanks for the response.

    There are about 16,000 to 20,000 rows in the data set in...

    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

    April 7, 2017 at 8:27 pm

    #1937299

  • RE: Need database expert

    Eric M Russell - Friday, April 7, 2017 12:19 PM

    I wonder what is the oldest post on SQLServerCentral?

    This is the oldest 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

    April 7, 2017 at 12:31 pm

    #1937272

  • RE: There is insufficient system memory in resource pool 'internal' to run this query.

    SQLRNNR - Friday, April 7, 2017 10:24 AM

    Perry Whittle - Thursday, April 6, 2017 7:17 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

    April 7, 2017 at 11:17 am

    #1937256

  • RE: Speeding up this function??

    f.keler 18216 - Thursday, April 6, 2017 7:20 AM

    Cool thanks! Don't understand the logic behind it but I'll give it a try 😉

    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

    April 6, 2017 at 7:37 am

    #1937038

  • RE: need some best practice tutorials for Sql server to oracle ETL using SSIS

    As personal experience, I would suggest that you avoid loading data into Oracle using SSIS. Even with specialized drivers as Attunity, the load will be a lot slower than using...

    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

    April 6, 2017 at 7:21 am

    #1937032

  • RE: Running Total

    Take a look at this article: http://www.sqlservercentral.com/articles/T-SQL/68467/
    If you're able to work with 2012 or something more recent, you would just need an OVER() clause.

    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

    April 6, 2017 at 7:09 am

    #1937021

  • RE: Speeding up this function??

    f.keler 18216 - Thursday, April 6, 2017 6:30 AM

    This function gets related streetname(s) and housenumber(s) and returns this as a string. I'm...

    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

    April 6, 2017 at 6:58 am

    #1937016

  • RE: Help me rearrange the SQL statement - It works but ?

  • RE: Removing Reverse Duplicates

    Would something like this help?

    SELECT DISTINCT
      CASE WHEN ClientRef <= LinkedClientRef THEN ClientRef ELSE LinkedClientRef END AS ClientRef,
      CASE WHEN ClientRef <= LinkedClientRef THEN...

    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

    April 5, 2017 at 10:59 am

    #1936864

  • RE: Help in finding actual days and hours difference!!!

    This article solves a similar problem: http://www.sqlservercentral.com/articles/T-SQL/103343/

    However, if you need values in separate columns, here's an option.

    declare @a table(
      begindate varchar(50),

    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

    April 5, 2017 at 9:53 am

    #1936841

  • RE: Stored Procedure help

    Jack Corbett - Wednesday, April 5, 2017 8:33 AM

    Ha ha.  I clicked on Latest Posts and this showed up 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

    April 5, 2017 at 9:11 am

    #1936826

  • RE: Are the posted questions getting worse?

    WayneS - Tuesday, April 4, 2017 11:37 AM

    FYI: This happened to me this weekend

    Congratulatios! I'm surprised you weren't an MVP already.

    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

    April 5, 2017 at 8:27 am

    #1936808

  • RE: Help required for creating the Stored procedure for below logic.

    pavanpala.vja - Wednesday, April 5, 2017 5:52 AM

    HI TEam.

    Failed to create the store procedure with 2 input parameters for the below logic....

    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

    April 5, 2017 at 6:33 am

    #1936765

  • RE: Just the time, please

    George Vobr - Tuesday, April 4, 2017 9:18 AM

    Thanks for this question Steve. I repeated the conversion time to datetime2...:ermm:
    For 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

    April 4, 2017 at 9:36 am

    #1936573

  • RE: Help me rearrange the SQL statement - It works but ?

    mw112009 - Tuesday, April 4, 2017 8:27 AM

    BTW -  I did format using the tool http://www.dpriver.com/pp/sqlformat.htm   Do you know of a...

    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

    April 4, 2017 at 8:47 am

    #1936563

Viewing 15 posts - 1,396 through 1,410 (of 8,731 total)