Forum Replies Created

Viewing 15 posts - 181 through 195 (of 3,666 total)

  • RE: Creating Trigger

    PJ_SQL (11/30/2015)


    Here's what my data looks like:

    Col A, B and C in table A:

    A BC

    4460636543NULL

    4431076543NULL

    3034 1152NULL

    4434516543NULL

    4405016543NULL

    9973...



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


    Eirikur Eiriksson (11/30/2015)


    Announcing the front runner for the Crystal Ball Award nomination 2015

    😎

    NOTE: Please support your favourite CBA by NOT answering the missing questions:-D

    Yeah that question is so...



    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/30/2015)


    Sean Lange (11/30/2015)


    Yes when doing a LEFT OUTER join the OUTER keyword is optional...but this discussion is...



    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: subquery's optimisation

    pedro.j.manuel (11/30/2015)


    Hi,

    Thanks a lot of your assware. But you are ask me for that information?

    Assware?



    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: multiple Date conversions

    hegdesuchi (11/25/2015)


    Hi,

    I have a scenario where i have to covnert date into particular format. There are multiple date formats that needs to be converted.

    For Example:Actual Data is

    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]

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/25/2015)


    The spam problem is tough. Believe me, no matter what we do, people will find ways around it. Much of the spam isn't a user...



    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: Trigger result from inserted / Deleted

    Minnu (11/25/2015)


    Hi Team,

    using below trigger,

    ALTER TRIGGER [dbo].[t_info] ON [dbo].unify_info

    FOR update

    AS

    begin

    declare @val1 varchar(100) declare @val2 varchar(100) declare @temp varchar(100)

    set @temp='HHT_Report'

    set @val1='SELECT ' +@temp+ ' FROM INSERTED'

    set @val2='SELECT ' +@temp+ '...



    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?

    Steve Jones - SSC Editor (11/25/2015)


    The spam problem is tough. Believe me, no matter what we do, people will find ways around it. Much of the spam isn't a user...



    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?

    Spam will keep on being out of control as long as spammers can post multiple spam post without being blocked.

    Same person has been doing this same thing today as he...



    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: writing queries that easily readable

    Why don't you show us an example of a query that has been labelled as hard to read?



    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?

    Alvin Ramard (11/24/2015)


    Can anyone tell me why spammer, oops, I meant user, live068 has not been killed yet?

    Looks like it's spam ll you want day today.

    Oops, looks like he...



    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?

    Can anyone tell me why spammer, oops, I meant user, live068 has not been killed yet?

    Looks like it's spam ll you want day today.



    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: Today's Random Word!

    Spam



    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: ssrs export to print on both sides of same paper

    I'm not sure how much SSRS can do for this, but printing on both side of a sheet will only work if the printer is capable of doing so.



    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: Help with Query

    Try replacing & with +



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