Coffeehouse Thread

31 posts

Is there a nice easy way to lodge bug reports?

Back to Forum: Coffeehouse
  • User profile image
    jonathanh

    Prodev wrote:
    Are they all part of "The Crew" by default if they are MS Employees?


    Heck no! Smiley

  • User profile image
    Charles

    The Crew is the collection of people inside Microsoft who get interviewed or do the interviewing, plus the good old Channel 9 guys.


    Charles

  • User profile image
    wbarthol

    Thanks spod, no it's not blocking me currently as I can use a numeric computed column rather than money.

  • User profile image
    Deactivated User

    Comment removed at user's request.

  • User profile image
    Charles

    Prodev wrote:
    Thanks, so what's the count?  How many Microsoft employees have joined Channel-9?   -JB


    There are currently 412 Microsoft employees registered on Channel 9.

    Charles
     

  • User profile image
    Manip

    Does Gates count as an employee?

    So that's 10%.. certainly doesn't feel like it by the amount you guys post. I would bet that less than 10% of posts are by Microsoft employees.

  • User profile image
    Charles

    Manip wrote:

    Does Gates count as an employee?

    So that's 10%.. certainly doesn't feel like it by the amount you guys post. I would bet that less than 10% of posts are by Microsoft employees.



    Yep. Bill Gates is an employee. It just so happens that he is also the head of the company and one of the founders, but an employee nonetheless.

    I would put my money on your wager. Smiley

    Charles

  • User profile image
    Deactivated User

    Comment removed at user's request.

  • User profile image
    Deactivated User

    Comment removed at user's request.

  • User profile image
    miies

    Of the total of 4,376 (at this moment) Channel9 members, there's a group of, let me guess, about 30 to 40 people of whom I see regular posts. Another few dozen post once in a while. What the heck are all those other lurkers waiting for? Smiley

  • User profile image
    gmiley

    DECLARE @tblTest table
        (
        ColA money NOT NULL,
        ColB_1 AS (($1 + $2)),
        ColC_1 AS (([ColA] + $1)),
        ColB_2 AS CONVERT(MONEY, ($1 + $2)),
        ColC_2 AS CONVERT(MONEY, ([ColA] + $1)),
        ColDT AS SQL_VARIANT_PROPERTY(([ColA] + $1), 'BaseType')
        )

    INSERT @tblTest
        (
        ColA
        )
    VALUES
        (
        $3
        )

    SELECT
        [ColB_1],
        CONVERT(VARCHAR(10), SQL_VARIANT_PROPERTY([ColB_1], 'BaseType'))
            AS 'ColB_1_DataType',
        [ColB_2],
        CONVERT(VARCHAR(10), SQL_VARIANT_PROPERTY([ColB_2], 'BaseType'))
            AS 'ColB_2_DataType'
    FROM
        @tblTest

    SELECT
        [ColC_1],
        CONVERT(VARCHAR(10), SQL_VARIANT_PROPERTY([ColC_1], 'BaseType'))
            AS 'ColC_1_DataType',
        [ColC_2],
        CONVERT(VARCHAR(10), SQL_VARIANT_PROPERTY([ColC_2], 'BaseType'))
            AS 'ColC_2_DataType'
    FROM
        @tblTest

    SELECT [ColDT]
    FROM
        @tblTest

    -------------------------------------
    Results
    -------------------------------------
    ColB_1                ColB_1_DataType ColB_2                ColB_2_DataType
    --------------------- --------------- --------------------- ---------------
    12884903592.0901      money           3.0000                money

    (1 row(s) affected)

    ColC_1                ColC_1_DataType ColC_2                ColC_2_DataType
    --------------------- --------------- --------------------- ---------------
    17179870888.4485      money           4.0000                money

    (1 row(s) affected)

    ColDT 
    ---------
    numeric



    I tested it out a little bit more to check the datatypes. Sure enough they are MONEY. HOWEVER, If you use SQL_VARIANT_PROPERTY() on ([ColA] + $1) before it is put into the field it comes back as NUMERIC and not MONEY. I think we have a problem with Implicit conversions. Anyone at MS able to confirm this is a problem? The Implicit Conversion chart shows that MONEY will propperly convert to NUMERIC. The only thing I can think is that somewhere it is trying to implicitly convert to string or some other strange thing.

  • User profile image
    Charles

    "Is there a nice easy way to lodge bug reports?"
     
    No, sorry. Not yet.


    Charles

  • User profile image
    Manip

    Charles wrote:
    "Is there a nice easy way to lodge bug reports?"
     
    No, sorry. Not yet.


    Charles


    yet! Must I ask? Smiley

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.