Forum Replies Created

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

  • RE: T-SQL Operators

    So I'm not the only one that thinks that MDX is not T-SQL. An instructor on a course I attended said, "think of MDX as T-SQL for cubes" (i.e....

  • RE: SSAS Cubes

    Thanks, Steve.

    To have come across this you really are as busy as you say in you editorials!

  • RE: SSAS Cubes

    Not strictly true - it does process, it just doesn't have anything to calculate the aggregations with. If CALCULATE has been replaced with something else, removing CALCULATE doesn't have...

  • RE: Accessing and changing data 2008

    ... given that in the BOL article "The following statements are equivalent" suggests that in the author of the article's mind, sales is NOT a floating point data type. ...

  • RE: Accessing and changing data 2008

    Tell me otherwise, bitbucket, but I think that you have read something into the BOL article that isn't there. Nothing says that sales is any kind of non-integer datatype...

  • RE: Accessing and changing data 2008

    Tao Klerks (9/23/2008)


    Sorry to whine, but this question is a little disappointing - It's educational on at least two counts (grouping sets - new feature, and possible gotcha on floating...

  • RE: Accessing and changing data 2008

    I thought "The following statements are equivalent" meant they were the same.

    Silly me!

  • RE: Sort Order - Include Null al last

    ...Or a badly written question with the wrong answer supplied:(

  • RE: ANY

    Danasegarane.A (6/19/2008)


    I am not able to understand this one

    I run this query

    if 'BLONP' < Any (select customerid from customers)

    select '1'

    else

    select '0'

    But it returns 1 only ?

    What's your customer table...

  • RE: CLR Assemblies

    Christian Buettner (6/19/2008)


    Good Question - Straight forward, no pitfalls, a good start into the day 🙂

    Chris - I admire the way you recovered yesterday's second "missing" point!;)

  • RE: Cursors

    GSquared (6/18/2008)


    Jim, Venky and Mike, run the sample from BOL. The second cursor, the one with the column_details data in it, returns a recordset. You can count the...

  • RE: Cursors

    Glad I'm not the only one - I can get number of rows in the cursor with all except sp_describe_cursor_columns...

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