Forum Replies Created

Viewing 15 posts - 3,301 through 3,315 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    GSquared (5/6/2009)


    Maybe I have the volume on my speakers turned down to far, but I haven't noticed anyone's avatars making any noises at all... (cuz I'm a blonde, yeah yeah...



    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?

    Bob Hovious (5/6/2009)


    Why shouldn't he put quotes around 'NULL', Alvin?

    'NULL' is a perfectly good word. Isn't it? :unsure:

    BTW, I was also...



    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 set Null Value as selected in the Multi Select parameter.

    mahesh_sukale (5/6/2009)


    Select Employee_Id,Employee_Name from Employee

    union

    Select -2, 'Null'

    Do not use quatation marks around Null



    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 haven't analyze any data to validate my answer, but I feel that the answer to the original question: "Are the posted questions getting worse?" is:

    YES!



    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: copy data from one server to another

    KATHLEEN Y ZHANG (5/6/2009)


    Hi, we have some asp code right now that transfers contents of three tables from one server to another. Here is how it works right now:

    if condition1...



    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: query week in the last year?

    Lynn Pettis (5/6/2009)


    Alvin, congrats on figuring out what was needed. Of course, it won't make use of any indexes that may benefit the query if they exist. 😉

    Would using...



    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: query week in the last year?

    If I understand what you're asking for then I think what you need is to add the code below to your where clause:

    DATEDIFF(month, YourDateColumn, getdate()) <= 12



    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 add columns to a table without neither re-creating it nor using the alter table command

    Just out of curiosity ....

    How many columns are in the table now?

    How often do you add new columns?

    How many columns do you add each time?



    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: Best tools for creating a user interface?

    Grant Fritchey (5/6/2009)


    Alvin Ramard (5/6/2009)


    I agree with Grant and I would recommend Microsoft Visual Studio. I would pick VB over C#. You probably would find that a bit...



    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: When to think about Disaster Recovery?

    PaulB (5/6/2009)


    Alvin Ramard (5/6/2009)Keep in mind that a DR plan for development can be completely different from a production DR plan. A development DR plan could be as simple...



    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: When to think about Disaster Recovery?

    vidhyasudha (5/6/2009)


    I clearly understood that I first plan what needs to recovered in case of disaster then try to figure out DR method that suits my business process and implement...



    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: Best tools for creating a user interface?

    I agree with Grant and I would recommend Microsoft Visual Studio. I would pick VB over C#. You probably would find that a bit easier to learn, but...



    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: When to think about Disaster Recovery?

    vidhyasudha (5/6/2009)


    Does this mean I need to create replication before starting the development?

    Ta

    No, it does not mean you have to create replication. It means you need to have...



    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: disk full

    homebrew01 (5/5/2009)


    Alvin Ramard (5/5/2009)


    Shrink tempdb? Who said tempdb was on that drive?

    Since the OP didn't give us much info, we're left to speculate wildly to cover all possible scenarios.

    If...



    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: disk full

    Steve Jones - Editor (5/5/2009)


    I think someone assumed all data on the same drive, which is likely for many installations.

    I realize that, but you know what we say around the...



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