Forum Replies Created

Viewing 15 posts - 601 through 615 (of 683 total)

  • RE: Derived tables - is there a more elegant way.

    Scorpion - Have you been drinking?

    Allen - Nicely written question   You've done this exactly how...

    March 16, 2006 at 10:45 am

    #627100

  • RE: Hierachy Sort (with a twist)

    You mean "Joe Celko's Trees and Hierarchies in SQL for Smarties"?

    Shame on you Joe!

    March 16, 2006 at 2:44 am

    #626960

  • RE: Subquey or #temp

    Just use a case statement

    Something like...

    select isnull(p1.dep_number, p2.dep_number) as dep_number, TurnW1, TurnW2,

           case when...

    March 16, 2006 at 2:41 am

    #626959

  • RE: Update error

    Check the triggers of that table...

    March 15, 2006 at 9:58 am

    #626838

  • RE: select

    You can do this too...

    SELECT ISNULL(address2, address1) AS Result FROM tablename

    Or...

    SELECT COALESCE(address2, address1) AS Result FROM tablename

    March 15, 2006 at 9:53 am

    #626836

  • RE: SELECT MIN Rank

    Hi All,

    Matt - you're not just looking for this, are you?

    select ProjectID, min(User_Rank) as User_Rank from Myview Group by ProjectID

    March 15, 2006 at 9:50 am

    #626832

  • RE: problem in a query

    You'll need to do something like this...

    select a.*, commentcount

    from tbl_UserBlog a

      inner join (select UserBlogID, count(*) as commentcount From tbl_Comments group by UserBlogID) b

        on a.UserBlogID...

    March 15, 2006 at 8:09 am

    #626776

  • RE: HOW TO TRANSPOSE COLUMNS TO ROWS USING T-SQL

    You'll be needing a UNION:

    DECLARE @t TABLE (dssid1 VARCHAR(3), dssid2 VARCHAR(3), dssid3 VARCHAR(3), name1 VARCHAR(20), name2 VARCHAR(20), name3 VARCHAR(20))

    INSERT INTO @t

          SELECT '001', '003',...

    March 15, 2006 at 8:03 am

    #626775

  • RE: Hierachy Sort (with a twist)

    Thanks Junkie

    I don't think you'll need to do anything dynamically - if 8 levels is your max, just extend it as below, and...

    March 15, 2006 at 7:58 am

    #626769

  • RE: Subquey or #temp

    Hi Jean-Pierre,

    I'd probably do something like this (so a bit of a combination of the two techniques )...

    Good luck!

    --This SQL...

    March 15, 2006 at 5:21 am

    #626719

  • RE: Join

    Hi Tracey, Jeff

    Just for fun, here's a different way (although similar, I admit) 

    I think it's not possible without a loop if the depth...

    March 15, 2006 at 4:48 am

    #626715

  • RE: Hierachy Sort (with a twist)

    Ignoring the fact that you probably ought to think some more about your data structure , this query below does the trick (I think)...

    March 15, 2006 at 4:04 am

    #626710

  • RE: Hierachy Sort (with a twist)

    Maybe I'm missing something, but why is 7264;20433;17886 (Level 2, TableSort 2) above 7264;20433;40264 (Level 2, TableSort 1)?

    March 14, 2006 at 11:34 am

    #626614

  • RE: XML Child - Parent Relationship

    I was more meaning that you had the 1, 2 and 3 in the wrong order (or so it seemed), rather than the output, but no matter.

    March 14, 2006 at 9:50 am

    #626586

  • RE: Complex function

    No problem James - solving problems like this is fun!

    I don't know anything about Sybase though - sorry

    March 14, 2006 at 7:57 am

    #626512

Viewing 15 posts - 601 through 615 (of 683 total)