Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Expressions based on data in the SELECT statement

    Hi Jeff,

    Yes thanks that project is now completed. The last question I posted was merely a case of having stared at the problem too long and not being able...

    --------------------------------
    I found this article helpful in passing on the info the more experienced posters need to help me with my problem:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • RE: Expressions based on data in the SELECT statement

    Hi Jeff,

    SessionType is on the Sessions table e.g. 'Test 1', 'Test 2' or 'Control'. I've tried to keep the test data simple-ish so have just included two SessionTypes ('Test'...

    --------------------------------
    I found this article helpful in passing on the info the more experienced posters need to help me with my problem:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • RE: Expressions based on data in the SELECT statement

    Thanks again Seth for your time.

    I see why what I've done is not a derived tables but have completely failed to figure out how to do what I...

    --------------------------------
    I found this article helpful in passing on the info the more experienced posters need to help me with my problem:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • RE: Expressions based on data in the SELECT statement

    I did what Seth suggested and investigated using derived tables (which I think are also called in-line views?) I've never used these before so this was interesting.

    So anyway, I...

    --------------------------------
    I found this article helpful in passing on the info the more experienced posters need to help me with my problem:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • RE: Expressions based on data in the SELECT statement

    Ah - just seen Seth's latest reply. Am now thinking about that. Thanks again Seth 🙂

    --------------------------------
    I found this article helpful in passing on the info the more experienced posters need to help me with my problem:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • RE: Expressions based on data in the SELECT statement

    I am getting somewhere with this slowly but it sure is painful.

    I set up my simple experiment with the tables:

    SessionId Name ...

    --------------------------------
    I found this article helpful in passing on the info the more experienced posters need to help me with my problem:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • RE: Expressions based on data in the SELECT statement

    Hi guys,

    Thanks very much for the replies. Very much appreciated. It's very good to know I'm no barking up the wrong tree. Now I've just got to...

    --------------------------------
    I found this article helpful in passing on the info the more experienced posters need to help me with my problem:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

Viewing 7 posts - 1 through 7 (of 7 total)