Coffeehouse Thread

31 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

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
    pierlove

    Thanks, so what's the count?  How many Microsoft employees have joined Channel-9?  Do you have subscription statistics that you could share with the community?  -JB

  • 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
    pierlove

    Charles wrote:

    There are currently 412 Microsoft employees registered on Channel 9.
     


    Charles,

    Thank you for that 'bit' of information.  How many users total?  Do you have data yet as to how many users are sticking around or 'active'.

    I am only interested in this information for its aesthetic value, one advantage of posting this kind of information may be that people will be able to better measure the value of our 'community'.

    Strength in numbers?

    Manip wrote:

    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. 
     


    So, I would bet that most of those registered MS Employees are subscribed to the RSS here.  And that any of them will post to relevant threads as they see fit. (meaning they have good reason to do so)

    Thanks again Charles, I think your doing a great job! 

    JB

  • User profile image
    pierlove

    Charles,

    I have an idea that should be fairly easy to implement, and may make the forums even more alive.

    On the Forum Topic List And near the user name of the person that started the thread. Perhaps you would place a mini-icon  indicating that a MS Employee has posted to or started that topic.

    This in reference to:

    Manip wrote:

    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. 


    I think that this will bring attention to those threads that do have MS Activity.

    Thanks,

    Jamie

  • 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

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.