Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    Steve, do we have an award for this one?

    http://www.sqlservercentral.com/Forums/Topic1007106-392-1.aspx



    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: More efficient way

    sturner (10/19/2010)


    you're kidding me right? ...

    You took the words right out of my mouth!



    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 (10/19/2010)


    I would just like to let everyone know that I live very green.

    My sheets are green, my clothes are green, my food is green, my cats are green......



    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: Solution ready for exporting data into excel file into MULTIPLE sheets for more than 65535 rows

    PaVeRa22 (7/14/2010)


    Hi Guys,

    I have solution for exporting data into excel file with multiple sheets for rows more than 65535, i wanted to publish it, I sent email to articles@SSC email...



    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: script component transformation - output0buffer is not dclared

    Have you gone to the Input-Output tab for the transform and defined output columns?



    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 Dixie Flatline (10/18/2010)


    Eh? What did you just say, Alvin?

    Speak louder. My hearing is not what it used to be. 😛



    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: comparing date datatypes in SQL Server

    Sandy2704 (10/18/2010)


    select distinct pid

    from table1 det with (nolock)

    inner join table2 rate with (nolock) on rate.id = det.SID

    where providerid = 2673 and rate.Fyr = '09-10' and...



    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 Dixie Flatline (10/18/2010)


    CirquedeSQLeil (10/18/2010)


    Brandie Tarvin (10/18/2010)


    The Dixie Flatline (10/18/2010)


    I once heard two brothers argue (inconclusively) about whether or not black and white were colors. Opinions anyone?

    How...



    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: comparing date datatypes in SQL Server

    Sandy2704 (10/18/2010)


    I tried working in the following way

    ( @startDate<=TerminationDate and @endDate <= TerminationDate )

    (I m passing @startDate and @endDate as parameters)

    TerminationDate is DateTime datatype

    @startDate and @endDate are DateTime datatype

    Can...



    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: comparing date datatypes in SQL Server

    Sandy2704 (10/18/2010)


    I need to compare whether a particular date(say date1) is greater than date2...How do i do it in SQL

    What data types are used to store your dates?

    What have you...



    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 the headers associated with, and particular fileds.

    GSquared (10/18/2010)


    By "IT SHOULD HAVE A HEADER", do you mean a row at the top that just says, "IT" (or whatever)? Does it also get column headers?

    There are easy...



    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?

    CirquedeSQLeil (10/18/2010)


    Paul White NZ (10/18/2010)


    CirquedeSQLeil (10/18/2010)


    Why not blue or brown which seem to be more indicative of this marble?

    Good question. Green is the colour associated with plants that photosynthesise...maybe...



    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?

    Also,

    - green is used for Go on traffic lights.

    - green is commonly used a success or good for indicators such as PKIs



    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?

    Stefan Krzywicki (10/18/2010)


    Alvin Ramard (10/18/2010)


    Paul White NZ (10/18/2010)


    CirquedeSQLeil (10/18/2010)


    Why is Green the color to represent tree huggers and eco-friendly?

    Which colour makes more sense to you? Pink?

    I'd rather it be...



    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?

    Paul White NZ (10/18/2010)


    CirquedeSQLeil (10/18/2010)


    Why is Green the color to represent tree huggers and eco-friendly?

    Which colour makes more sense to you? Pink?

    I'd rather it be mauve. 😀



    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 - 1,396 through 1,410 (of 3,666 total)