将MS Access Pivot查询转换为SQL Server 2005 [英] Convert MS Access Pivot Query to SQL Server 2005

问题描述

我在MS Access中有数据透视表查询，我想在SQL Server 2005中运行。任何人都可以帮助我将语法转换为SQL Server。以下是MS Access中的查询：

I have Pivot Table query in MS Access that I would like to run in SQL Server 2005. Can anyone help me to convert the syntax over to SQL Server. The following is the query in MS Access:

展开 | 选择 | Wrap | 行号

推荐答案

这就是我的意思到目前为止，我们已经提出了这个问题。它仍然很慢。有什么建议吗？

This is what I''ve come up with so far. It is still alitte slow. Any advice?

展开 | 选择 | Wrap | 行号

有谁知道更好的方法吗？

Does anyone know a better way of doing this?

如果我正在查看你想要转动的表格以及所需的结果，那么构建查询会更快。如果你可以发布一些样本数据，那就更好了。 />

- CK

It would be faster for me to build your query if I''m looking at your table that you want to pivot and the the desired result.If you can post some sample data, it would be better.

-- CK

这篇关于将MS Access Pivot查询转换为SQL Server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！