Forum Replies Created

Viewing 15 posts - 481 through 495 (of 3,666 total)

  • RE: Union Join

    I'm not sure, but just guessing here. Telling us what error you got might help a little.



    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?

    Need more magic crystals.



    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: crystal report cannot select into temp table

    First, let me complain about your original post.

    One of my pet peeves with this forum is when posters don't state everything in the post. I should not have to...



    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: crystal report cannot select into temp table

    Lynn Pettis (7/30/2015)


    mfriessnig (7/30/2015)


    I know select * into ##tmp1 should work but I get a database connection error.

    After reading Alvin's last post and looking at your original post, from 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: crystal report cannot select into temp table

    SELECT * from what? The whole universe?



    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: crystal report cannot select into temp table

    mfriessnig (7/30/2015)


    Lynn Pettis (7/30/2015)


    Not a lot to work with here. Details would help.

    sql server 2014 using odbc

    Still not much to work with.

    Why don't you start from the beginning...



    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: Beginner - Star schema - Date dimension lookup from Customer dimension

    You could have just the DOB as a date in your client dimension and the join with the date dimension when required. If you join to the date dimension 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: Query Store in 2016

    SQLRNNR (7/30/2015)


    Igor Micev (7/30/2015)


    Question is not formed well.

    The Query Store feature is not enabled for which databases?

    - It's not enabled for all user databases by default. And 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: Linked Server

    GonnaCatchIT (7/30/2015)


    Hi Team,

    We have a SQL Server say 'DBSQL\LC', this server has 4 DB's say

    DB1

    DB2

    DB3

    DB4

    DB1 to DB3 are handled by me, DB4 is handled by another team.

    Now I need to...



    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?

    Grant Fritchey (7/30/2015)


    SQLRNNR (7/30/2015)


    Grant Fritchey (7/30/2015)


    Brandie Tarvin (7/30/2015)


    As I dig into this issue (Execution Plans HO!), I come across a thread in which one respondent posts a link to Gail's...



    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?

    GilaMonster (7/29/2015)


    Alvin Ramard (7/29/2015)


    GilaMonster (7/29/2015)


    I just love university logic.

    They send my student card by courier. They send request for guest count for grad via SMS and email.

    They send the document...



    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?

    GilaMonster (7/29/2015)


    I just love university logic.

    They send my student card by courier. They send request for guest count for grad via SMS and email.

    They send the document telling me my...



    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?

    Are we there yet? 😀



    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 to a table by range

    Phil Parkin (7/29/2015)


    Welsh Corgi (7/29/2015)


    I have a situation where I have to Join a table that has Credit Score from a value of 0 to to a Lookup table...



    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: Using Wildcard with a date column

    anthony.r.colvin (7/28/2015)


    I was trying to use a wild card for a date column such as July of 2015 and the query would show me all orders made within the month...



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