Forum Replies Created

Viewing 15 posts - 541 through 555 (of 3,666 total)

  • RE: Find Common Link Between Two Tables in Database without Key Constraints

    JimK 28184 (7/16/2015)


    Does anyone know of a tool, script, procedure, or otherwise that will solve this problem?

    CREATE TABLE [Table 1] (

    Id varchar,

    TableTwoId varchar,

    OtherData varchar )

    CREATE TABLE [Table 2] (

    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?

    Phil Parkin (7/16/2015)


    .... up to and including the "F" word

    Foxbase?

    Foxpro?



    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 records older than 90 days in SQL Server

    Phil Parkin (7/16/2015)


    And if that means deleting millions of rows in any of the tables, you should consider implementing a batch delete process to avoid excessive locking and TLog growth.

    Agree...



    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 records older than 90 days in SQL Server

    kbadarinath (7/16/2015)


    Let me clarify something here. I don't think I will take an answer and implement that solution without testing it.

    I wanted to know if there is anything out...



    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 records older than 90 days in SQL Server

    Even if there was a maintenance plan item that could do it for me, I would still my write own stored procedure to do it. This way I would...



    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: Join two tables with specific data

    kennyhuang0108 (7/15/2015)


    Thank you. here is my Query

    select Orgn.cd, fund.cd,fund.nm, fund.bf_Acty_Cd

    from

    (

    select cd,nm, bf_Acty_Cd

    from bf_fund ...



    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: Join two tables with specific data

    Looks like you have a problem with your join statement.

    There's no was we can help you without more information about the structure of your tables, the data the contain, 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?

    SQLRNNR (7/15/2015)


    GilaMonster (7/15/2015)


    Yes, asking people to write an efficient query when you don't entirely know what you need is a really good way to get a useless answer....

    Sounds like client...



    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: Datediff query

    Look at IIF. It should allow you to do what you want.



    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: Search Issues?

    Read this thread and now I can't get this song out of my mind. At least it's not a bad song.

    ... I still haven't found what I'm looking for ...



    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: About star schema, cube and MDX

    Carl B. (7/14/2015)


    Hi everyone,

    I am new in the BI world and I would have these questions:

    - Is it possible to have a MDX query that restrict (WHERE CLAUSE) based on...



    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?

    WayneS (7/14/2015)


    Jeff Moden (7/14/2015)


    Lynn Pettis (7/13/2015)


    OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without...



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


    Alvin Ramard (7/11/2015)


    Hopefully you'll submit it for SQL Saturday in Memphis, hopefully later this year. 🙂

    When is Memphis?

    We're hoping to have one late...



    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: Conditional Measure in DAX

    Did you look into creating a Calculated Member?



    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: SSIS - excel file manipulation

    vecerda (7/13/2015)


    I have actually ended up doing it exactly that way. I kept trying to use Alvin's method and could not get it to work so I brought them into...



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