Forum Replies Created

Viewing 15 posts - 4,546 through 4,560 (of 8,731 total)

  • RE: But we've always done it that way…

    Sean Lange (8/3/2015)

    Michael L John (8/3/2015)

    I just left a position because I got tired of hearing "That's the way we always did it" AND 'We don't have time to do...

    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

    August 3, 2015 at 8:21 am

    #1816833

  • RE: Hide a column from select

    From Books Online:

    The ORDER BY clause is not valid in views, inline functions, derived tables, and subqueries, unless either the TOP or OFFSET and FETCH clauses are also specified. When...

    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

    August 3, 2015 at 7:47 am

    #1816812

  • RE: Hide a column from select

    adonetok (8/3/2015)

    I used code below, it works but I am not sure it is good.

    select distinct ORDERID from (select top 100 percent ORDERID,ORDERDate from ORDER where ORDERID = '123456' order...

    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

    August 3, 2015 at 7:45 am

    #1816809

  • RE: Delete duplicate rows from ANY table.

    ben.brugman (8/3/2015)

    Enforcing constriants often prevents actions. Most of the time it prevents 'illegal' actions. But sometimes it prevents actions, which are functional.

    In general I am in favor to enforce constraints...

    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

    August 3, 2015 at 7:42 am

    #1816807

  • RE: Delete duplicate rows from ANY table.

    sgmunson (8/3/2015)

    ben.brugman (8/3/2015)

    This weekend I have been away from the keyboard. And as often the best idea's occure when away from the keyboard. E.g. on my bike (pushbike) or under...

    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

    August 3, 2015 at 7:38 am

    #1816803

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/3/2015)

    Koen Verbeeck (8/3/2015)

    Back after 2 weeks of holiday.

    Did I miss anything important? 🙂

    Are the posted questions getting better now?

    I couldn't tell you, Koen. I'm back after 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

    August 3, 2015 at 6:47 am

    #1816783

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/2/2015)

    Alvin Ramard (8/1/2015)

    Jeff Moden (7/31/2015)

    Alvin Ramard (7/31/2015)

    I guess I've had enough of this forum for this week.

    http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx

    You did fine and you're absolutely spot on. You've said...

    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

    August 2, 2015 at 11:03 am

    #1816681

  • RE: Select query in a stored procedure running for long time

    Eirikur Eiriksson (8/2/2015)

    Piling on Luis's and Gail's posts, withholding or piecemeal'ing any relevant information is a waste of everybody's time! From the limited information supplied so far, one question arises,...

    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

    August 2, 2015 at 8:33 am

    #1816653

  • RE: Delete duplicate rows from ANY table.

    Just a couple of clarifications.

    To change the code into a stored procedure, you just change the variables declaration to become your SP header.

    The query does not use the column list...

    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 31, 2015 at 2:10 pm

    #1816552

  • RE: Select query in a stored procedure running for long time

    coolchaitu (7/31/2015)

    Thanks for the reply. I had attached the execution plan in my previous post.

    No, you didn't. You attached an image of the execution plan which isn't the same thing...

    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 31, 2015 at 1:10 pm

    #1816531

  • RE: Migrating to SQL 2012

    I feel like I should apologize for Alvin as his answer might seem rude. But he makes a very good point.

    There's a lot of documentation on the changes from what...

    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 31, 2015 at 1:04 pm

    #1816529

  • RE: Select query in a stored procedure running for long time

    That doesn't help a lot. You should post DDL for the tables, views and indexes involved and actual execution plan (right click on the execution plan and Save As...).

    The index...

    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 31, 2015 at 12:46 pm

    #1816522

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (7/31/2015)

    Alvin Ramard (7/31/2015)

    Luis Cazares (7/31/2015)

    WayneS (7/31/2015)

    Looks like Luis is answering Oracle questions now.

    That wasn't the only attempt on that day. Here's a completely lost Oracle user.

    But hey,...

    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 31, 2015 at 12:25 pm

    #1816519

  • RE: Find records comparing two lists

    Your sample data doesn't help much to test and validate. I had to make several corrections which mean that you didn't test your sample data.

    This might be an option, but...

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

    #1816513

  • RE: how to update values based on column into multiple columns in another table

    Naveen PK (7/31/2015)

    Luis Cazares (7/31/2015)

    I'm just wondering why would you need to update these columns as you shouldn't store values this way if you want a normalized table. And if...

    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 31, 2015 at 12:08 pm

    #1816510

Viewing 15 posts - 4,546 through 4,560 (of 8,731 total)