谁能帮我看看怎么RE-WRITE这段CODE？ - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

谁能帮我看看怎么RE-WRITE这段CODE？

谁能帮我看看怎么RE-WRITE这段CODE？# Database - 数据库

m*e2010-03-29 07:03

1 楼

原来的是：
SELECT dbo.tblDim_Period.Code AS MnthYr, dbo.tblDim_Account.Code AS
Account, dbo.tblDim_Prism.Code AS Prism, dbo.tblDim_Facility.Code AS
Facility,
dbo.tblDim_Product.Code AS Product, CASE WHEN dbo.
tblDim_Product.Accrual IS NULL
THEN 'ACT_ACT' ELSE dbo.tblDim_Product.Accrual END AS
ProdAccrl, dbo.tblDim_Channel.Code AS Channel, dbo.tblDim_Collateral.Code AS
Collateral,
dbo.tblDim_Reprice.Code AS RePrice, dbo.tblDim_Purpo

i*a2010-03-29 07:03

2 楼

what's the purpose of rewriting? or what are you trying to archive?

m*e2010-03-29 07:03

3 楼

try to see the difference. can you help? thanks.

【在 i****a 的大作中提到】

: what's the purpose of rewriting? or what are you trying to archive?

i*a2010-03-29 07:03

4 楼

My question is what kind of difference you want to see. If the query is
giving you the correct result then its a correct query.
Often there are multiple ways to write a query in sql. Access generated or
not, there is no need to rewrite a query just because you can. Unless you
thing there is a performance problem.

【在 m****e 的大作中提到】

: try to see the difference. can you help? thanks.

m*e2010-03-29 07:03

5 楼

i need to add 5 fields to this, but someone told me it would take hours to
do that, because it needs "pivot" in SQL. i don't get it.
in what situation it would need pivot by adding new fields to a table?

【在 i****a 的大作中提到】

: My question is what kind of difference you want to see. If the query is
: giving you the correct result then its a correct query.
: Often there are multiple ways to write a query in sql. Access generated or
: not, there is no need to rewrite a query just because you can. Unless you
: thing there is a performance problem.

i*a2010-03-29 07:03

6 楼

If those 5 fields contains multiple rows per lookup and you need to treat
them as different columns, then you need to pivot them.
I think you should communicate with your programmers better.

【在 m****e 的大作中提到】

: i need to add 5 fields to this, but someone told me it would take hours to
: do that, because it needs "pivot" in SQL. i don't get it.
: in what situation it would need pivot by adding new fields to a table?