Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 8,731 total)

  • RE: Max. Degree or Parallelism

    Sreekanth B - Monday, July 17, 2017 9:47 AM

    John Mitchell-245523 - Monday, July 17, 2017 9:30 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

    July 17, 2017 at 10:09 am

    #1951208

  • RE: How to ignore the duplicates and make same value for rest

    There might be other ways. However, I'm not sure what do you need as you're just giving a piecemeal of the information. I can't see a reason why the solution...

    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 14, 2017 at 11:28 am

    #1950985

  • RE: How to ignore the duplicates and make same value for rest

    Here's a possibility. Although, I didn't test for performance.

    WITH CTE AS(
      SELECT *,
       DENSE_RANK() OVER(PARTITION BY a ORDER BY b) dr,
      ...

    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 14, 2017 at 10:51 am

    #1950977

  • RE: Are the posted questions getting worse?

    jasona.work - Thursday, July 13, 2017 2:13 PM

    So reading the posts from Brandie about the job got me thinking (that was that...

    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 14, 2017 at 8:46 am

    #1950954

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Thursday, July 13, 2017 10:42 AM

    jasona.work - Thursday, July 13, 2017 10:07 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

    July 13, 2017 at 12:13 pm

    #1950811

  • RE: need script to pull out all numeric numbers more that 6 digits long within a string

    This is easy using the Pattern Splitter by Chris Morris that can be found on the following article: Splitting Strings Based on Patterns - SQLServerCentral

    Here's 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 13, 2017 at 10:10 am

    #1950785

  • RE: Add sql Column to Excel Document

    Janda Nel - Thursday, July 13, 2017 7:33 AM

    the excel .xls file is dropped in a shared folder every day and 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

    July 13, 2017 at 8:06 am

    #1950748

  • RE: Today's Random Word!

    Ed Wagner - Thursday, July 13, 2017 7:23 AM

    Hugo Kornelis - Thursday, July 13, 2017 6:54 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

    July 13, 2017 at 7:32 am

    #1950736

  • RE: Add sql Column to Excel Document

    Janda Nel - Thursday, July 13, 2017 7:25 AM

    Good afternoon
    i have a excel document.One of the columns is an account number.I want...

    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 13, 2017 at 7:31 am

    #1950734

  • RE: Converting an old VPF program to TSQL and need assistance

    bswhipp - Thursday, July 13, 2017 7:15 AM

    The prior DBA used FoxPro for a utility. I am rewriting it in SQL 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

    July 13, 2017 at 7:24 am

    #1950730

  • RE: Count Distinct Not Working in Case Select Oracle SQL

    phaenggi - Tuesday, July 11, 2017 4:28 PM

    Well, aren't you a bowl of sunshine! Was my first post on here, so forgive me...

    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 12, 2017 at 7:55 am

    #1950529

  • RE: Count Distinct Not Working in Case Select Oracle SQL

    phaenggi - Tuesday, July 11, 2017 12:51 PM

    Hello All,
    I have a Oracle SQL question in which the code fails to count RESV_NAME_ID's. ...

    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 11, 2017 at 1:22 pm

    #1950424

  • RE: Query help

    Guras - Tuesday, July 11, 2017 8:47 AM

    I have the following values in  table1

    Id,  startdate, endDate, PersonID, systemID
    1, '01/01/2012', '01/12/2015' 1, 1 
    2...

    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 11, 2017 at 8:51 am

    #1950386

  • RE: Dropping PKs

    morlindk - Tuesday, July 11, 2017 6:03 AM

    Tried it out. Did not work as "correct" answer says. Likely because my test table...

    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 11, 2017 at 6:08 am

    #1950351

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Tuesday, July 11, 2017 4:29 AM

    Some people in other departments are. In my department, we tend 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

    July 11, 2017 at 6:04 am

    #1950348

Viewing 15 posts - 1,111 through 1,125 (of 8,731 total)