Visual Studio 2008 IDE

Question

Hello,

I am currently reorganizing a project of hundreds of ressources , gifs, classes and controls. Since i find it time consuming to manually update the references or the ressources location in each file, i was wondering if there is any way of letting VS2008 update automatically references, namespaces and images paths?

Thanx for your help

Answer 1

I think you got the pivot a bit wrong. I think it should look something like this:

 

SELECT
    *
FROM
(
SELECT
    Categories.CategoryName,
    YEAR(Orders.ShippedDate) AS ShippingYear,
    CONVERT(money,([Order Details].UnitPrice*Quantity*(1-Discount)/100))*100 as Sales
FROM
    Orders
INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID
INNER JOIN Products ON [Order Details].ProductID = Products.ProductID
INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID
WHERE (((Orders.ShippedDate) Between '19960101' And '19971231'))
) AS SourceTable
PIVOT
(
    SUM(Sales)
    FOR CategoryName IN ([Confections],[Meat/Poultry],
                         [Beverages],[Grains/Cereals],[Seafood])
) AS pvt