DBD
New Member
- Joined
- May 5, 2004
- Messages
- 25
Ok, See if anyone has heard this one before. It's wacky
A while back I created a macro that excutes a Stored Proc on SQL SERVER and simply returns results to a worksheet. The Proc is a hard coded query (see code). The Wacky thing is that the same query (hard-coded not dynamic) returns less results in 2003. Example, In Excel 2000 and 2002 the results are 145 records. In Excel 2003 the results returned are 103.
Any Idea??
- thanks
DBD
A while back I created a macro that excutes a Stored Proc on SQL SERVER and simply returns results to a worksheet. The Proc is a hard coded query (see code). The Wacky thing is that the same query (hard-coded not dynamic) returns less results in 2003. Example, In Excel 2000 and 2002 the results are 145 records. In Excel 2003 the results returned are 103.
Any Idea??
- thanks
DBD
Code:
---CODE From STORED PROC in SQL Server (No Params Passed)----
---Only only showing it to show it is hard coded.
SET TextSize = 16000
SELECT pkey as [CAPA #], OrgLevel1, BriefSummary, Status, Originator, QSM, Assignee, name AS [Product Type], dateentered, AssignedToDate, RequestedReplyDate,
ImpDate, [Assigned Org Level 3], Rtrim(SupplierName) + ' (' + rtrim(SupplierID) + ')' AS Supplier, CMTS as Comments
FROM vw_CAPAReportDetails
GO
