Forum Replies Created

Viewing 15 posts - 2,746 through 2,760 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/7/2016)

    Luis Cazares (6/7/2016)

    WayneS (6/6/2016)

    PRO TIP:

    If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup...

    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

    June 7, 2016 at 9:02 am

    #1883627

  • RE: Interview Questions

    Jeff Moden (6/7/2016)

    Luis Cazares (6/7/2016)

    Try this:

    SELECT sys.fn_get_folder(path, 1)

    Absolutely the correct answer! 😛 Well, except for the Hungarian notation used. :hehe:

    That's the MS standard. 😀

    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

    June 7, 2016 at 8:50 am

    #1883615

  • RE: Are the posted questions getting worse?

    WayneS (6/6/2016)

    PRO TIP:

    If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.

    That's why I suggest...

    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

    June 7, 2016 at 8:43 am

    #1883605

  • RE: Sequential read from table

    Having to use dbms_output.put_line(); is one of the many reasons that I hate Oracle.

    T-SQL has a simpler way to work as stated before. If you need help on the "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

    June 7, 2016 at 8:41 am

    #1883604

  • RE: Are the posted questions getting worse?

    jasona.work (6/7/2016)

    Luis Cazares (6/7/2016)

    Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.

    Nah. I was sorely tempted to put together a Powershell script...

    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

    June 7, 2016 at 8:32 am

    #1883600

  • RE: Interview Questions

    Was I too late for April fools' day?

    This is what happens when you trust a forum to answer questions that you should answer on your own.

    I could have given 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

    June 7, 2016 at 8:24 am

    #1883595

  • RE: Are the posted questions getting worse?

    Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.

    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

    June 7, 2016 at 7:29 am

    #1883567

  • RE: Interview Questions

    Try this:

    SELECT sys.fn_get_folder(path, 1)

    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

    June 7, 2016 at 7:25 am

    #1883563

  • RE: Microsoft Certification Information Needed - Help

    You don't have to take the exams in a particular order, as long as they're from the MCSA certification. I would suggest that you start with the one you feel...

    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

    June 6, 2016 at 12:37 pm

    #1883458

  • RE: Execute Oracle packages (control-M) using SQL Agent and Powershell

    So you're moving away from Control-M.

    If I remember correctly, Control-M tasks are very similar to a cmdexec step on SQL Server Agent. You might need to check that the connections...

    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

    June 6, 2016 at 10:31 am

    #1883418

  • RE: Execute Oracle packages (control-M) using SQL Agent and Powershell

    Why call a job from an automation tool from another automation tool which is more restricted? Seems like you just want to create additional problems.

    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

    June 6, 2016 at 9:47 am

    #1883401

  • RE: Concatenation and Comma Assistance Required!!!

    You could use the STUFF function or even the SUBSTRING.

    Here's an example using STUFF with different combinations.

    SELECT Field1,Field2,Field3,

    STUFF( CONVERT(CHAR(20), ISNULL(CASE WHEN Field1 > 0 THEN ',1'...

    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

    June 6, 2016 at 9:09 am

    #1883388

  • RE: Today's Random Word!

    Ed Wagner (6/3/2016)

    Grumpy DBA (6/3/2016)

    djj (6/3/2016)

    crookj (6/3/2016)

    Manic Star (6/3/2016)

    Burning Man

    Running Man (Stephen King as Bachman)

    Running Bear

    Sleeping Bear (Dunes)

    M-22

    T-1000

    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

    June 3, 2016 at 2:03 pm

    #1883199

  • RE: Finding the greater value among the lesser ones in other table

    I don't get that error with a correction on your code.

    --Create sample data

    CREATE TABLE TableA( MyDate date, OtherDate date);

    CREATE TABLE TableB( xDate date);

    INSERT INTO TableA(OtherDate) VALUES(GETDATE()), (GETDATE()-1), (GETDATE() - 2);

    INSERT...

    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

    June 3, 2016 at 9:32 am

    #1883132

  • RE: Cast Varchar to Float Resulting In (Scientific) E Notation

    The display can be changed in the front-end by the web developers. They might be using float in the front end, but it doesn't mean that the values need to...

    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

    June 3, 2016 at 8:04 am

    #1883096

Viewing 15 posts - 2,746 through 2,760 (of 8,731 total)