Forum Replies Created

Viewing 15 posts - 6,901 through 6,915 (of 8,731 total)

  • RE: Time to Retire

    Nadrek (2/17/2014)

    Luis Cazares (2/17/2014)

    It's easy to take family members off of WinXP. Not so easy for companies that need lots of licenses and testing time to make sure nothing is...

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

    #1689563

  • RE: using join in PIVOT

    Will you always have your output in one line?

    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, 2014 at 8:22 am

    #1689544

  • RE: Time to Retire

    It's easy to take family members off of WinXP. Not so easy for companies that need lots of licenses and testing time to make sure nothing is going to break....

    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, 2014 at 8:21 am

    #1689542

  • RE: SQL Training

    You can read the stairways[/url] in this site, as well as the articles. You can try to solve problems from the forums even if you don't post the answer 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

    February 17, 2014 at 7:52 am

    #1689529

  • RE: View Server State Permission - Risks?

    1.- No, password information is never revealed.

    2.- Not exactly, just number of rows (AFAIK).

    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, 2014 at 5:37 pm

    #1689263

  • RE: Foreign Keys: Essential or Academic?

    It's more for databases meant for reading and not for writing. Basically reporting or some kind of OLAP.

    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, 2014 at 3:08 pm

    #1689249

  • RE: using join in PIVOT

    You're right. You need to create a tally or numbers 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

    February 14, 2014 at 2:45 pm

    #1689243

  • RE: Schema

    mike 57299 (2/14/2014)

    Does it really matter if they tried? If they understand the solution you present or they learn something, isn't it what the forum is really about?...

    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, 2014 at 2:34 pm

    #1689240

  • RE: Schema

    I'm sorry, your answer makes it completely different. I'm sorry but many people come here and ask questions without even trying anything (some people believe that is easier to write...

    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, 2014 at 2:23 pm

    #1689233

  • RE: Schema

    Have you even tried looking for "CREATE SCHEMA" on google?

    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, 2014 at 2:03 pm

    #1689225

  • RE: Foreign Keys: Essential or Academic?

    Michael Valentine Jones (2/13/2014)

    3. The database is "overnormalized".

    That can be true (even if it usually isn't).

    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, 2014 at 1:17 pm

    #1689203

  • RE: Avoiding Row work in SQL

    To get this right withuot a cursor, the best option is a method (which some call undocumented feature) called Quirky Update. You must read about this method on the following...

    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, 2014 at 1:13 pm

    #1689202

  • RE: Am I taking crazy pills? Dispute over inner vs. outer join.

    That inner join won't give you a better performance as your condition is non-SARGable. You should remain with a LEFT JOIN like this:

    SELECT Customer.CustomerId, ISNULL( Location.Description, 'Unknown Location') Description

    FROM Customer...

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

    #1689178

  • RE: Help on Calculation of days between Start & End Date (Including BOTH the Start & End Dates)

    What do you mean by O/P?

    DATEDIFF will always return whole numbers.

    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, 2014 at 10:18 am

    #1689139

  • RE: Help on Calculation of days between Start & End Date (Including BOTH the Start & End Dates)

    dhananjay.nagarkar (2/14/2014)

    Dear Journey Man,

    I have to calculate the value for a field "[ORC Position Duration (months)]" using the following 2 fields from DataBase source- 1)Target Start Date , and 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

    February 14, 2014 at 9:20 am

    #1689121

Viewing 15 posts - 6,901 through 6,915 (of 8,731 total)