Forum Replies Created

Viewing 15 posts - 49,126 through 49,140 (of 59,065 total)

  • RE: Things You Didn't Know About Temp Tables and Table Variables

    By the way... Folks, say hi to Adam Mechanic... he's the guy that first introduced me to the idea of what I currently call a Tally table.

    Thanks again for that,...

    July 18, 2008 at 8:46 pm

    #845307

  • RE: Things You Didn't Know About Temp Tables and Table Variables

    Adam Machanic (7/18/2008)

    Jeff Moden (7/18/2008)

    Viswanath S. Dhara (7/18/2008)

    I am trying to update a table using a correlated subquery.

    Why? Correlated subqueries are a form of RBAR and can...

    July 18, 2008 at 7:44 pm

    #845305

  • RE: Need to remove duplicate records and get distinct values

    d_sysuk (7/16/2008)

    Okay so the posters had part I published several times, with various answers... using min/max, a subquery, a temp-table.

    The perfm. analysis can be made easily by Sam/others just run...

    July 18, 2008 at 5:38 pm

    #845300

  • RE: Things You Didn't Know About Temp Tables and Table Variables

    Thanks Christian...heh... yeah, I was just wondering if the OP understood that. Very strange sample code to begin with...

    July 18, 2008 at 5:27 pm

    #845299

  • RE: ISQL/W

    Vivien Xing (7/18/2008)

    isql/w is something like this:

    http://www.imranweb.com/freesoft/

    "For more information on Enhanced ISQL/w, read this document. "

    isql/w != isqlw

    Aghhh... My apologies... you are correct. Could even see the slash for...

    July 18, 2008 at 5:23 pm

    #845298

  • RE: Soft Skills

    Steve Jones - Editor (7/18/2008)

    I think Grant and Jeff must be related to Dwight Shroot. Sorry you guys lost your privileges to bring nunchakus and stars into the office.

    Heh... who...

    July 18, 2008 at 4:45 pm

    #845294

  • RE: Soft Skills

    Grant Fritchey (7/18/2008)

    Jeff, how do I get a bat?

    Easy... use soft skills to get the managers to buy you one! 😛

    I find it difficult to use soft skills when someone...

    July 18, 2008 at 9:19 am

    #845130

  • RE: Soft Skills

    Shaun McGuile (7/18/2008)

    Sock with a roll of quaters - cos people are scared of change 😀

    Now THAT's FUNNY! 😀

    July 18, 2008 at 8:47 am

    #845110

  • RE: Things You Didn't Know About Temp Tables and Table Variables

    Viswanath S. Dhara (7/18/2008)

    I am trying to update a table using a correlated subquery.

    Why? Correlated subqueries are a form of RBAR and can actually be worse than...

    July 18, 2008 at 8:21 am

    #845086

  • RE: Soft Skills

    Shaun McGuile (7/18/2008)

    GSquared: Scientology?!?

    What does that mean? Cruise and Travolta come over and talk at you? 😀

    No the only truth is the "Theory of Constraints" - TOC.

    And yes I'm like...

    July 18, 2008 at 8:13 am

    #845073

  • RE: Need to remove duplicate records and get distinct values

    karthikeyan (7/17/2008)

    I have executed all these three methods more than 10 times, But i got the same result at all time.

    1) update #t1

    set #t1.Name = T.Name

    from T , #t1

    where #t1.ID...

    July 18, 2008 at 8:03 am

    #845059

  • RE: Need to remove duplicate records and get distinct values

    karthikeyan (7/17/2008)

    Thanks Chris !

    I am not offending you, i am asking this question politely.

    Jeff's Sample code:

    --===== Right way to do a "Joined" update

    UPDATE TableA

    SET SomeTableAColumn...

    July 18, 2008 at 7:59 am

    #845054

  • RE: How to Pivot a table

    sqluser (7/18/2008)

    Hi black,

    Try this. It should work as per your result set.

    CREATE TABLE tblPivot (fldDate DateTime, fldValue int)

    INSERT INTO tblPivot (fldDate,fldValue)

    SELECT '4/1/2008',4

    UNION ALL

    SELECT '4/3/2008',6

    UNION ALL

    SELECT '4/7/2008',9

    UNION ALL

    SELECT '4/2/2008',1

    UNION ALL

    SELECT '5/8/2008',4

    UNION...

    July 18, 2008 at 6:24 am

    #844965

  • RE: How to Pivot a table

    My pleasure... thank you for the feedback. 🙂

    July 17, 2008 at 11:50 pm

    #844786

  • RE: ISQL/W

    Vivien Xing (7/17/2008)

    isql/w is a very simple/basic GUI. It is more like a text editor as I remember. It is not rich like query analyzer. The link...

    July 17, 2008 at 11:45 pm

    #844784

Viewing 15 posts - 49,126 through 49,140 (of 59,065 total)