Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have an access query that looks like

TRANSFORM Avg([Detailed Measures - EP].[Calculated  Percentage Value]) AS [AvgOfCalculated  Percentage Value]
SELECT [Detailed Measures - EP].NPI, [Detailed Measures - EP].[Business State/Territory], [Specialty Group].[SPECIALTY GROUP]
FROM [Detailed Measures - EP] 
INNER JOIN [Specialty Group] ON [Detailed Measures - EP].Specialty = [Specialty Group].SPECIALTY
WHERE ((([Detailed Measures - EP].[Objective Identifier/Title]) Not Like "NQF*") 
    AND (([Detailed Measures - EP].[Attestation Status])<>"Rejected"))
GROUP BY [Detailed Measures - EP].NPI, [Detailed Measures - EP].[Business State/Territory], [Specialty Group].[SPECIALTY GROUP]
PIVOT [Detailed Measures - EP].[Objective Identifier/Title];

I would like to convert it to SQL Server Query/View. Please advise

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.