Forum Replies Created

Viewing 15 posts - 646 through 660 (of 3,666 total)

  • RE: Dealing with unknown values

    winston Smith (6/22/2015)


    Scenario:

    I have a person entity and Nationality Entity. The nationality may or may not be populated (can be null). If null, i want to assign the key 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: Are the posted questions getting worse?

    GilaMonster (6/22/2015)


    It's starting to look like the replication which keeled over last week did so because the passwords on the distributor were changed. If I've lost my entire Saturday because...



    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?

    Lynn Pettis (6/19/2015)


    Sorry, but I started screaming.

    Lynn, get off the train tracks! 😀



    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?

    The Force seems to be weakening.



    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: Compare String

    meerack11 (6/19/2015)


    select * from Gl_code_data where Gl_code='602-43335_Planning - Expedited Air'

    I have Gl_code='602-434345_Planning - Expedited Air' this record in table but result show me nothing

    This one should 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?

    I think I'd classify it as a derailment instead.



    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?

    Sean Lange (6/19/2015)


    Anybody have the mind reading apparatus? I have misplaced mine and could use it over here. http://www.sqlservercentral.com/Forums/Topic1696091-2799-1.aspx

    I think this is one of those threads where one should consider...



    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: Compare String

    meerack11 (6/19/2015)


    Hello everyone

    I need to compare to string in sql

    requirement is

    Select Reson_id from reason_data where reason='ryete / werewr ddsad '

    is there any way...



    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: Moving upwards through a folder tree

    Phil Parkin (6/19/2015)


    Alvin Ramard (6/19/2015)


    Phil Parkin (6/19/2015)


    Alvin Ramard (6/19/2015)


    ...

    If xp_DirTree won't do what you want, then you could use a VB or C# script to populate that same object...



    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: Moving upwards through a folder tree

    Phil Parkin (6/19/2015)


    Alvin Ramard (6/19/2015)


    ...

    If xp_DirTree won't do what you want, then you could use a VB or C# script to populate that same object variable.

    In other words: "Rather...



    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: Moving upwards through a folder tree

    Phil Parkin (6/19/2015)


    richardmgreen1 (6/19/2015)


    Hi all

    I've got an SSIS package that loads a block of CSV files from a specified folder and moves them to another folder after processing them. ...



    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?

    Eirikur Eiriksson (6/18/2015)


    Alvin Ramard (6/18/2015)


    Well, at least he was polite. I just got thanked for posting a LMGTFY link.

    I need to go find a good wall to go...



    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?

    Well, at least he was polite. I just got thanked for posting a LMGTFY link.

    I need to go find a good wall to go bang my head against....



    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: Backups

    Sounds like you're saying that you're backing up to a location that is not on the SQL server and is on another box on the network.

    If that is the case,...



    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: Update or something else

    ChrisM@Work (6/18/2015)


    vceklic (6/18/2015)


    Hi everyone,

    Can someone help me solve this:

    I have 2 tables that look something like this:

    Table Price:

    id - int

    price - varchar

    validFrom - datetime

    validTo - datetime

    itemId - int

    ....

    Table sales:

    id -...



    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 - 646 through 660 (of 3,666 total)