Forum Replies Created

Viewing 15 posts - 16 through 30 (of 112 total)

  • RE: need NULL defined when adding to the table

    That column is already in the table definition i provided. That table/column already allows NULLs. My guess is that the persom wants a default value set to the column rather...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: need NULL defined when adding to the table

    The person is inexcessable for the next two weeks and this needs to be completed before that time. You have as much information as I do about it, so from...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: SQLCMD and inserting data

    Nevermind, I got it working. I was missing a GO batch command after the statement.

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Weird interview question

    Thank you so much Sean! Us Sean's got to stick together 😉

    ~Sean

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Weird interview question

    And below are the rest of the questions. BTW, I took myself out of being considered for candidacy for the role so I am not be considered for the position...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Confused about count function

    Thank you David!

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Working in the IT industry

    Evil Kraig F (7/12/2012)


    TeraByteMe (7/12/2012)


    Your a **** and you work in IT not surprising and DBA at that. Point made.

    You posted in a public place looking for an professional opinion....

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Working in the IT industry

    Evil Kraig F (7/12/2012)


    TeraByteMe (7/12/2012)


    I have I think a unique experience with how many contracts/jobs I have had in the field the last 12 years. I have worked these positions:

    I...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Troubleshooting SSIS package

    It can hang indefinitely. The job/package is being run during Europian hours. Two hours - or so - into it hangs. They kill it and then run it manually. Which...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Troubleshooting SSIS package

    I didn't create the package and it is quite complex. Calls some 20 other packages from the main. Definitely think that permissions maybe at work here. The job runs under...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: How to work with CMD prompt and prompt selections

    🙂 I am thankful you appreciate it. It is all about the journey and learning out realistic limitation in it! Thank you for helping me along that journey!!

    Jeff Moden (5/31/2012)


    I...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: How to work with CMD prompt and prompt selections

    The only way we could get this to work was to add a flag to the program that bypasses the prompt. Logical because you can't tell a program to do...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: How to work with CMD prompt and prompt selections

    I tried every way icould think of to get it to work with get-process but no luck. I will let you know once i confirm.

    Jeff Moden (5/27/2012)


    Thanks for the feedback....

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: How to work with CMD prompt and prompt selections

    That trick works with the exe that I just created will see if it works with the one I actually have to run it against. Thanks!

    Jeff Moden (5/26/2012)


    It sometimes depends...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: How to work with CMD prompt and prompt selections

    This will execute the application but as a result it opens in a cmd window and how to make the default selection of Y (Yes) from the window? Note, the...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

Viewing 15 posts - 16 through 30 (of 112 total)