Forum Replies Created

Viewing 15 posts - 5,251 through 5,265 (of 8,731 total)

  • RE: DATEDIFF values are different for exactly same MiliSeconds

    Because datediff doesn't care about smaller time parts, it just indicates the number of jumps.

    This is a common example:

    SELECT StartDate

    ,EndDate

    ,Years = ...

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

    #1776475

  • RE: Which certificate will help me earn a job in IT?

    hanialbarni (2/9/2015)

    I ask because I need expert help !! , Ok if I want to learn Oracle SQL or anything that will help me be DBA what should I 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

    February 9, 2015 at 9:35 am

    #1776417

  • RE: regarding sql developer

    Check this out as it might help you.

    http://bit.ly/1IDLPJL

    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 9, 2015 at 9:29 am

    #1776411

  • RE: Shall i study DBA ?

    Jeff Moden (2/9/2015)

    I have no certifications or degrees and I can't use things like SSIS, SSRS, SSAS, or any of the other 4 letter words associated with SQL Server.

    T-SQL...

    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 9, 2015 at 9:02 am

    #1776397

  • RE: Update column in a table ?

    hanialbarni (2/9/2015)

    It did not work, maybe becuase am using different MYSQL WorkBranch ?

    Maybe because this is a SQL Server forum and you weren't polite enough to mention that you're 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

    February 9, 2015 at 8:30 am

    #1776386

  • RE: How to join the tables to get only record with specific field value in a table

    It would be nice to have DDL, sample data and expected results to test but this should give you an idea.

    SELECT *

    FROM Applicants a

    LEFT

    JOIN Reviews r ON a.applicantId = r.applicantId...

    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 6, 2015 at 3:40 pm

    #1776190

  • RE: Will order of fields create any performance issues?

    I'd like to say that it should not make any noticeable difference, but a better answer would be to test and measure both options to confirm it.

    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 6, 2015 at 3:35 pm

    #1776188

  • RE: What's a good indexing strategy for this situation?

    Scott,

    I mainly agree with you, but the OP stated that there's always one Payroll_Year at a time. Based on that, I wouldn't include it in 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

    February 6, 2015 at 12:22 pm

    #1776141

  • RE: SQL Script

    I'm guessing that you're working with Oracle because is the one that has varchar2 (AFAIK).

    This is a SQL Server forum which means that you might not get the best suggestions...

    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 6, 2015 at 11:47 am

    #1776136

  • RE: Call function/procedure from anywhere

    You can use three part names to include database_name.schema_name.object_name

    Or you could use synonyms.

    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 6, 2015 at 11:12 am

    #1776124

  • RE: What's a good indexing strategy for this situation?

    Do you always query by employee? I'll guess you have more employees than payperiods. Assuming that, your columns should be EmployeeId, PayPeriod, CompanyId. If the queries use more the period...

    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 5, 2015 at 7:20 pm

    #1775937

  • RE: Are the posted questions getting worse?

    Sean Lange (2/5/2015)

    Brandie Tarvin (2/5/2015)

    So I just got a workplace reminder to wear red tomorrow because of National Red Day[/url].

    I didn't even know this was a thing, but it 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 5, 2015 at 3:53 pm

    #1775915

  • RE: Removing commas

    krypto69 (2/5/2015)

    Hi,

    I have a simple statement where I am trying to remove all commas that may be in the xn_workordeld column.

    SELECT

    xn_workordeld = case replace(xn_workordeld, ',', '') as "WORKORDER...

    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 5, 2015 at 3:43 pm

    #1775913

  • RE: Question related to indexes?

    New Born DBA (2/4/2015)

    FYI--When you run this SQL Statement, there are 207,716 records. 1 more thing I also have to mention is that column C1000020534 has only 1 value "Case"...

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

    #1775438

  • RE: What am I missing?

    Because you'll have problems with trailing spaces. Have you used the code that I posted to see the different cases and their results?

    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 4, 2015 at 10:50 am

    #1775421

Viewing 15 posts - 5,251 through 5,265 (of 8,731 total)