Forum Replies Created

Viewing 15 posts - 1,876 through 1,890 (of 3,348 total)

  • RE: Identity Values

    Roddy.CAMERON (1/23/2013)

    I'm just wondering what's the inconsistent behaviour you're referring to?

    Delete the table, then run the same code again -but this time without the first insert statement.

    My guess is that...

    January 23, 2013 at 3:12 pm

    #1580285

  • RE: Number of Rows

    Dave62 (1/22/2013)

    venkat9.sql (1/22/2013)

    Thanks for the reply. I didn't execute the code. I just used the display estimated execution plan.

    I checked the messages tab and didnt get the 1 row affected...

    January 22, 2013 at 10:24 am

    #1579740

  • RE: Number of Rows

    venkat9.sql (1/22/2013)

    Thanks for the reply. I didn't execute the code. I just used the display estimated execution plan.

    I checked the messages tab and didnt get the 1 row affected message.

    I...

    January 22, 2013 at 9:32 am

    #1579704

  • RE: EOMONTH - 1

    L' Eomot Inversé (1/21/2013)

    Hugo Kornelis (1/21/2013)

    ... But in SQL Server 2012, there are definitely a lot of new function that are totally useless - except if you want to enable...

    January 21, 2013 at 8:18 am

    #1579273

  • RE: EOMONTH - 1

    Sean Pearce (1/21/2013)

    Since when did SQL Server start copying Excel?

    It didn't (at least not the buggy version of the code that was distributed in Excel 97 and Excel 98 for...

    January 21, 2013 at 2:53 am

    #1579160

  • RE: Number of Rows

    paul s-306273 (1/18/2013)

    In my naivete I'm thinking 'so what?'.

    Is there a relevance to this?

    That's what I though as well when answering the question.

    The question itself doesn't appear to make sense...

    January 18, 2013 at 2:17 am

    #1578598

  • RE: Matching Missing Field

    Cliff Jones (1/17/2013)

    Hugo Kornelis (1/17/2013)

    chgn01 (1/17/2013)

    Aliases are not for columns where there is only one column possible.

    You are completely right - if you never make typo's, never have anyone else...

    January 17, 2013 at 10:12 am

    #1578409

  • RE: Matching Missing Field

    chgn01 (1/17/2013)

    Aliases are not for columns where there is only one column possible.

    You are completely right - if you never make typo's, never have anyone else changing your tables, and...

    January 17, 2013 at 9:42 am

    #1578387

  • RE: Matching Missing Field

    Dineshbabu (1/17/2013)

    Hugo Kornelis (1/17/2013)

    For instance, you can not do without CROSS APPLY in the following fragment:

    FROM Table1 AS a

    CROSS APPLY (SELECT b.Col1, SUM(b.Col2) FROM Table2 AS b WHERE b.Col3 >=...

    January 17, 2013 at 6:18 am

    #1578281

  • RE: Matching Missing Field

    ronmoses (1/17/2013)

    Okay, so... since TblA1 isn't indicated as a source table in that subquery, I'm wondering how far you can take this. For example, if there was a TblA3...

    January 17, 2013 at 6:16 am

    #1578280

  • RE: Matching Missing Field

    Dineshbabu (1/17/2013)

    Thanks for such a detailed explaination Hugo.

    I think the below code

    FROM Table1 AS a CROSS APPLY (SELECT Col1, Col2 FROM Table2 AS b WHERE b.Col3 = a.Col3) AS...

    January 17, 2013 at 5:29 am

    #1578257

  • RE: Matching Missing Field

    Dineshbabu (1/17/2013)

    What is the Diff B/W Cross Join and Cross Apply? I think i'm going out of scope, else provide me reference to understand it in detail.

    For a JOIN (any...

    January 17, 2013 at 4:25 am

    #1578228

  • RE: Rounding question

    jfgoude (1/17/2013)

    rounding float problem ... the only way to know is to try so : 64% of trickering on this QOTD

    I disagree, for several reasons.

    First - if I see this...

    January 17, 2013 at 4:12 am

    #1578221

  • RE: Matching Missing Field

    Dineshbabu (1/17/2013)

    Hugo Kornelis (1/17/2013)

    Dineshbabu (1/17/2013)

    Great question and great concept.

    I added COL1 to TblA2 and expected "Ambiguous column name 'col1'.". But this time Sql server selected column from TblA2 and...

    January 17, 2013 at 3:44 am

    #1578203

  • RE: Matching Missing Field

    Dineshbabu (1/17/2013)

    Great question and great concept.

    I added COL1 to TblA2 and expected "Ambiguous column name 'col1'.". But this time Sql server selected column from TblA2 and gave me the...

    January 17, 2013 at 2:20 am

    #1578160

Viewing 15 posts - 1,876 through 1,890 (of 3,348 total)