Forum Replies Created

Viewing 15 posts - 241 through 255 (of 3,666 total)

  • RE: Incorrect prefix error (select count statement)

    SQLPain (10/7/2015)


    I tried putting the following directly in the select statement but it didn't worked either and gave me the error, when I run the statement independently it works fine...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: MERGE to single Flat FILE with different formats

    Priya_learner (10/7/2015)


    Thanks for the reply

    I am able to split the 4 type of records using header Footer primary and detail file connections

    but the thing is how to put them back...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Spam Spam Bacon and Spam

    Guess I'd better get another bottle of BBQ sauce. 😀

    I wish there was a way to get back at those spammers. They won't stop until it costs them something.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: ADD CARRIAGE RETURN IN A VARCHAR

    dan.maddux (10/2/2015)


    is there a way of doing this with multiple rows that vary in length? i have 6000+ rows that have variable text and need a hard break after...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: How to use RTRIM in Case statement

    shankley (10/1/2015)


    I have a DistributorInvoiceNumber that can end with in 'R', 'A', 'CRR' or 'CR'.

    I am trying to write a case statement like so:

    CASE WHEN RIGHT([ih].[DistributorInvoiceNumber],1) = 'A'

    ...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: need info on Preparing Checklist for Knowledge Transfer for SQL Server from the old/previous DBA.

    Don't forget to ask where ALL the passwords are kept.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    New question: Why doesn't SSDT plug into SSMS ?

    Since when are we supposed to know why Microsoft does things the way they do? DUH!!! :w00t:

    Sorry. Had to vent!...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSDT

    mar.ko (9/30/2015)


    Alvin, I don't understand that....

    it has a powerful data table compare and auto scripting feature.

    It apparently can take two tables and provide a script to make sure they are...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSDT

    Why? Because that's not what it was designed for.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Could not find server !

    Checked your Linked Servers to see if a link to that server has been created.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: table variable in SSIS

    I believe a table variable in SSIS would end up being a recordset stored in an object variable. This is not the simplest thing to work with.

    I'd give Phil's...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (9/30/2015)


    Alvin Ramard (9/30/2015)


    HARD: Another 4 letter word. 😉

    Hush, you! 😛

    Oh wait! Not all four letter words are bad!

    Cold Beer: Two four letter words together and not...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    HARD: Another 4 letter word. 😉



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Time posted does not indicate time zone

    I'm in the same time zone and times are showing correctly.

    Look at your profile and check what time zone you have selected under forum settings.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: First date of the Month (to date on Range basis)

    Luis Cazares (9/28/2015)


    Alvin Ramard (9/28/2015)


    Kristen-173977 (9/28/2015)


    Alvin Ramard (9/28/2015)


    Why:

    WHERE YourDateColumn >= @StartDate

    AND YourDateColumn < @DayAfterEndDate

    and not:

    WHERE ...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 241 through 255 (of 3,666 total)