How to run this quert in MS SQL?

[vkunirs]

Hi

i am running this query in MS-Access successfully.

but if i execute the same query in MS SQL then it is not working.

This is My Query:

TRANSFORM Count(INVENTORY.b_error) AS suc
SELECT INVENTORY.d_date, Count(INVENTORY.id_inventaire) AS tot
FROM INVENTORY
GROUP BY INVENTORY
.d_date PIVOT INVENTORY.b_error;


Errors are :

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'INVENTAIRE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'PIVOT'.

[PaulH]

sql server isn't ms access. it has not transform or pivot functions. what exactly are trying to get as output?

[vkunirs]

Hi

actually i want to get some data from the database.
at that i was unable to get that, then using the MS-Access query wizard i
built that .
so it is working in that fine.
but when i execute the same in the SQL Server it is not working.

any how i got sol for that query.