SELECT    

    dbo.[Web-Registration-Golf].Delegation AS Facility

    ,ISNULL(COUNT(dbo.[Web-Registration-Golf].StateID), 0) AS Lvl2NonPlayCount

FROM        

    dbo.[Web-Registration-Golf]

        LEFT JOIN dbo.certifs

--        INNER JOIN dbo.certifs

            ON...

http://www.sqlservercentral.com/columnists/jselburg/2824.asp

CREATE PROCEDURE dbo.test;1

AS

    SELECT 1

I'm not 100% on this, but I don't think the SSMS will install if 2005 SSMS is already on the machine. I believe, you need to uninstall 2005 SSMS and...

Ravi, in the release notes it states that you may have to manually removed the registry entry. Check the release notes/known issues for details. ...

[EDIT] From the release...

Lynn, unfortunately your solution seems to take quite a while to run when there are 100,000 + rows.

mrpolecat, your solution runs...

mrpolecat wins a piece of PIE for that one.....

OK, this is the 2005 forum, that's why I thought you had it.

As far as the file or string question....I don't know, but I'm someone else will answer that one...

Wouldn't VARCHAR(MAX) do the trick?

I can't help you there, I've only just started .NET ...

My first thought would be to pull the RDL file into memory and manipulate it then save and call the report. Since they're nothing more than XML files, I'm sure...

Sorry, Anders is correct. You can use dynamic sql, but I try to avoid it...

If ALL of your label_value's are known then yes, you can. If not, then it can not be done with PIVOT. That's the one downfall with PIVOT that I've come...

Can you post the DDL for your table and some sample data along with required results? Your question is fairly straight forward, but without sample data it's hard to exactly...

Use two tables instead of Text boxes. Using two identical datasources with a filter on one for >0 and the other with <0.