DTS (Compute issue) - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

DTS (Compute issue)

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-16 : 08:43:20

Ngo-cho writes "When I run the following query in Query Analyzer, all the rows are returned including the computed data, but if I run it using a DTS package, only 12 rows are returned. The computed data is not returned. What might be the reason.
Please advice.

SELECT
C.LOGIN,
A.NAME ANAME,
E.NAME ENAME,
A.DESC_TEXT,
A.X_SFA_ANT_START_DT,
A.X_SFA_RATE_PER_HOUR,
B.FCST_REVN,
D.NAME DNAME
FROM
S_EMPLOYEE C,
S_OPTY A,
S_ORG_EXT E,
S_OPTY_POSTN B,
S_STG D
WHERE
A.ROW_ID = B.OPTY_ID AND
C.ROW_ID= A.CREATED_BY AND
D.ROW_ID=A.CURR_STG_ID AND
A.PR_DEPT_OU_ID=E.ROW_ID
ORDER BY D.NAME DESC
COMPUTE SUM(B.FCST_REVN) BY D.NAME
COMPUTE SUM(B.FCST_REVN)"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources