Forum Replies Created

Viewing 15 posts - 196 through 210 (of 3,666 total)

  • RE: Script task experts welcome

    caojunhe24 (11/23/2015)


    hmm.. the point is I don't see any hyperlink in your post can you send it again? thanks

    Click on the word "this".



    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: Agent job schedules - next run date - how it gets updated?

    Based on personal observations, I believe the schedule also gets update at the completion of every job run.



    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 (11/19/2015)


    Let's ask a question in a SQL Server 2012 forum when it is really about Access. Oh, and I even prefaced my answer with "..., and 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: Are the posted questions getting worse?

    Eirikur Eiriksson (11/19/2015)


    Alvin Ramard (11/19/2015)


    Eirikur Eiriksson (11/19/2015)


    Luis Cazares (11/19/2015)


    I feel excluded.

    How come?

    ๐Ÿ˜Ž

    Luis, I'll include you with me. ๐Ÿ™‚

    That looks way too close to a union all statement for comfort:-P

    ๐Ÿ˜Ž

    Union...



    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 (11/19/2015)


    Luis Cazares (11/19/2015)


    I feel excluded.

    How come?

    ๐Ÿ˜Ž

    Luis, I'll include you with me. ๐Ÿ™‚



    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: LIKE unicode character in SQL Select

    vantuan02t1 (11/19/2015)


    I have a table: Table_1 as below:

    IDDescription

    1College 1 kakรก

    2University 1

    3College 2

    4University 2

    I use sql select: Select * from Table_1 where Description like N'%College%'

    => Result:

    IDDescription

    1College 1 kakรก

    3College 2

    But 'College' always...



    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?

    robert.sterbal 56890 (11/16/2015)


    One of the things that makes people turn away from a forum is when bed behavior isn't addressed.

    I'd agree that a +1 shouldn't be the first thing in...



    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: 4 Queries Required Very Urgent

    Brandie Tarvin (11/13/2015)


    ScottPletcher (11/12/2015)


    He wants to do nothing himself. I tried to walk him thru the logic of how to code #4 in his original q, here:

    http://forums.sqlteam.com/t/need-help-case-statement-should-work/4070

    but he refused,...



    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: Error converting data type varchar to smalldatetime.

    anjaliagarwal5 (11/12/2015)


    I did that. Now I am getting an error saying:

    The conversion of a datetime datatype to a smalldatetime resulted in a out of range value.

    The testDate column in 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]

  • RE: 4 Queries Required Very Urgent

    Lynn Pettis (11/12/2015)


    nexus2vijay (11/12/2015)


    Hi,

    It's a test actually.

    Nope infact i don't have setup to test the same. I have just given the logical approach.

    Appreciate if you could help me with that...



    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 using Case Statement

    Phil Parkin (11/12/2015)


    nexus2vijay (11/12/2015)


    Hi,

    From the attached 4 Tables Schema Diagram

    Will the below query Reduce me the ListPrice by 20% if i didn't receive the order for the last 2 years...



    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: sysobjects id field value limit reached (INT)

    It accumulated 100 million tables and NOBODY noticed? :w00t:



    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: Byte Me: Get-Help

    SQLRNNR (11/5/2015)


    I don't know about powershell punctuation, but tsql punctuation seems to be taking over mine. I keep ending all of my statements in a semi-colon.

    That's ok Jason, as long...



    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: Key Value Pair Table

    I'm not 100% sure of exactly what your situation is, but it looks like you should keep on using that key values pair table. Just make sure you have 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: case statement convertion

    What data type is flg_attendance?



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