date as filename

Question

i'm trying to use date as filename.my date format is dd/mm/yyyy.so how can i remove the "/" so that system can accept the date as filename.ex:210604.txt

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