Is there a nice easy way to lodge bug reports?

Prodev wrote:

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

Heck no! 

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

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

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.

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

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

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?

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.

Charles wrote:

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


Charles

yet! Must I ask?