Forum Replies Created

Viewing 15 posts - 646 through 660 (of 1,248 total)

  • RE: Are the posted questions getting worse?

    I've just registered for SQL Relay in Huddersfield. Hopefully my manager will let me attend in work time rather than having to take a day off.

  • RE: Home lab build question...

    Grant Fritchey (7/3/2015)


    :alien:

    <singing> One of these things is not like the others... </singing>

    I've got the Foo Fighters in my head now/

  • RE: data problem

    immaduddinahmed (7/13/2015)


    hi,

    my data is looks like this

    A-------B

    1-------22

    5--------6

    i want my data looks like this

    A-------B

    1-------22

    2-------0

    3-------0

    4-------0

    5-------6

    please help me out

    thanks for the help

    There's an awful lot missing from your question that makes it almost...

  • RE: Days Wise Data

    immaduddinahmed (7/13/2015)


    hi,

    my data looks like this

    days---------visit

    5--------------1

    10-------------10

    1--------------2

    i want this type of data

    days---------visit

    1--------------1

    5--------------1

    10--------------10

    plesae help me out

    thanks for the help

    The data in your results is different from the initial...

  • RE: "ID" or "Id"

    We've got a database that has all the primary keys as ID and all foreign keys as Table+ID and it's horrible to work with. There's two closely related tables...

  • RE: Are the posted questions getting worse?

    rodjkidd (7/8/2015)


    BWFC (7/8/2015)


    rodjkidd (7/8/2015)


    Well don't forget about SQL Relay in October

    http://www.sqlrelay.co.uk

    Rodders...

    I'm on the mailing list for that already so all things considered I'll be there.

    Irritatingly enough, Mrs BWFC has...

  • RE: Are the posted questions getting worse?

    rodjkidd (7/8/2015)


    Well don't forget about SQL Relay in October

    http://www.sqlrelay.co.uk

    Rodders...

    I'm on the mailing list for that already so all things considered I'll be there.

    Irritatingly enough, Mrs BWFC has decided that...

  • RE: Are the posted questions getting worse?

    BrainDonor (7/8/2015)


    Out of idle curiosity - is anybody else from the SSC clan attending the Manchester SQL Saturday http://www.sqlsaturday.com/418/eventhome.aspx?

    I was going to go, then forgot about it until the other...

  • RE: Views

    Koen Verbeeck (7/8/2015)


    Quite the obvious answer 😀

    Thanks for the question!

    It's only obvious if you know the system stored procedures. I didn't even know that existed so I had to...

  • RE: Advice for Trainers

    Thanks for the advice everybody.

    There's definitely a couple of things to take away from here. I've discovered since my original post that 'reasonably powerful', in regards to the laptop,...

  • RE: Simple SQL Query - Or So I thought.

    GilaMonster (7/2/2015)


    BWFC (7/2/2015)


    At face value, you could try selecting only the columns you actually want to see and using SELECT DISTINCT if the rows are unique.

    Would not...

  • RE: Are the posted questions getting worse?

    jasona.work (7/2/2015)


    BWFC (7/2/2015)


    My wife's away all weekend so it's going to be bad food, guitars out in the living room and Lord of the Rings to watch. I'll need...

  • RE: Simple SQL Query - Or So I thought.

    mattmacmillan (7/2/2015)


    Hi all,

    Bit of a noob, still lots to learn lol

    Trying to do a many to many query as follows:

    SELECT * FROM clients

    INNER JOIN clientscategories

    ON clientscategories.idclient...

  • RE: Are the posted questions getting worse?

    My wife's away all weekend so it's going to be bad food, guitars out in the living room and Lord of the Rings to watch. I'll need to find...

  • RE: Advice for Trainers

    Sorry, I re-read what I wrote and it's not quite clear. The course is written, I'm now looking for advice on the best set-up for delivering it. That...

Viewing 15 posts - 646 through 660 (of 1,248 total)