Select query does'nt return values

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)

Select query does'nt return values

Author

Topic

reddymade
Posting Yak Master

165 Posts

Posted - 2006-02-17 : 12:00:10

I have the following select query:
On the server it does bring records, but when i use the same query on another machine it does'nt bring any rows at all: it does have data on that machine.


SELECT TAB_ccsNetSU.SUNumber, TAB_ccsNetSU.SUTitle, 

rtrim(isnull(CONVERT(varchar(10),TAB_ccsNetSU.PDReceivedDate,101),'')) AS PDReceivedDate, 
rtrim(isnull(CONVERT(varchar(10),TAB_ccsNetSU.PDToReviewDate,101),'')) AS PDToReviewDate, 
rtrim(isnull(CONVERT(varchar(10),TAB_ccsNetSU.PDToContractorDate,101),'')) AS PDToContractorDate, 
rtrim(isnull(TAB_ccsNetSU.PDSupervisor,'')) as PDSupervisor, 
TAB_ccsNetSU.SUID, rtrim(isnull(TAB_ccsNetActions.ActionDescription,'')) as ActionDescription, 
rtrim(isnull(CONVERT(varchar(10),TAB_ccsNetSU.PDNeedDate,101),'')) AS [When]
FROM TAB_ccsNetSU INNER JOIN
TAB_ccsNetActions ON TAB_ccsNetSU.SUID = TAB_ccsNetActions.ModuleRecordID 
WHERE (TAB_ccsNetActions.ModuleName = 'SU')
GROUP BY TAB_ccsNetSU.SUNumber, TAB_ccsNetSU.SUTitle, TAB_ccsNetSU.PDReceivedDate, 

TAB_ccsNetSU.PDToReviewDate,  TAB_ccsNetSU.PDNeedDate,
TAB_ccsNetSU.PDToContractorDate, TAB_ccsNetSU.PDSupervisor, TAB_ccsNetSU.SUID, 

TAB_ccsNetActions.ActionDescription

Please thank you very much for the help.

karuna
Aged Yak Warrior

582 Posts

Posted - 2006-02-17 : 12:21:18

Both the machines have same set of data?
Are you getting any errors or just that the query doesnt return any records?

Thanks

Karunakaran

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources