Forum Replies Created

Viewing 15 posts - 466 through 480 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    jasona.work (7/31/2015)


    By the way all...

    Happy SysAdmin day!

    :hehe::cool::w00t::-D

    Thanks, but when's the SQL Dev day? 😎

    😀



    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 guess I've had enough of this forum for this week.

    http://www.sqlservercentral.com/Forums/Topic1707595-2799-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: Migrating to SQL 2012

    newbieuser (7/31/2015)


    Hi friends,

    Our customer is moving to SQL 2012 and they have installed SQL Server 2012 instance a new db server. I have a list of new...



    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?

    SQLRNNR (7/31/2015)


    Alvin Ramard (7/31/2015)


    Ladies and gentlemen, take my advice - pull down your pants and slide on the ice.

    screeeeeeeeeeeeeeeeeeeeeeeeeeech

    What?

    You're not familiar with the saying?



    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?

    Ladies and gentlemen, take my advice - pull down your pants and slide on the ice.



    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: Keeping Database online while data is being refreshed from copy?

    You could look into the possibility of using snapshots or synonyms.

    Snapshots would essential hold a static copy of your data while you're ding your updates.

    Synonyms could be used to switch...



    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: Delete duplicate rows from ANY table.

    ben.brugman (7/31/2015)


    Is there is 'fairly' simple query to delete duplicate rows from ANY table ?

    A script which removes duplicates from a table, when a table_name is supplied.

    Ben

    To answer the original...



    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?

    Luis Cazares (7/31/2015)


    WayneS (7/31/2015)


    Looks like Luis is answering Oracle questions now.

    That wasn't the only attempt on that day. Here's a completely lost Oracle user.

    But hey, as long as I 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: Delete duplicate rows from ANY table.

    Sean Lange (7/31/2015)


    Alvin Ramard (7/31/2015)


    Lynn Pettis (7/31/2015)


    The only thing that comes to my mind would require using Dynamic SQL. The difficult part would be knowing how to determine what...



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

    Phil Parkin (7/31/2015)


    sgmunson (7/31/2015)


    Naina_11 (7/27/2015)


    it's done. I added a Level column with 0 and 1 and ordered accordingly.

    Thanks

    Another alternative:

    DECLARE @testing AS TABLE (

    DepDate datetime,

    val int

    );

    INSERT INTO @testing VALUES ('2014-01-10 00:00:00.000',...



    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: Delete duplicate rows from ANY table.

    Lynn Pettis (7/31/2015)


    The only thing that comes to my mind would require using Dynamic SQL. The difficult part would be knowing how to determine what is duplicated data? ...



    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: ODBC Connection with SQL Migration

    Do you have access to the connection string?



    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: Union Join

    kennyhuang0108 (7/30/2015)


    here is an error msg :ORA-00933: SQL command not properly ended

    thanks

    WAIT!!!!!

    Error message: ORA-00933???

    Is this an Oracle query? FYI, this is not an Oracle forum.



    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: Union Join

    kennyhuang0108 (7/30/2015)


    Thanks Alvin.

    The erros msg I got is :ORA-00923: FROM keyword not found where expected

    Maybe adding the word FROM after

    select distinct b.lev5 AS "LEVEL 1",b.lev5NAME, C.lev7 "FUND", C.lev7NAME,round...



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


    Alvin Ramard (7/30/2015)


    Need more magic crystals.

    I am writing code for an automagical solution to all coding problems.

    Try starting all procedures with:

    DROP DATABASE ...



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