I have one unusual situation where in my sql query works fine under 9.1. But under 9.2 the program never finishes execution. At the end I have to abruptly exit the program.
I am using Unix SAS. Let me know if any one has answer.
Here is my query
connect to sqlsvr(user=aaaa pwd='xxxxxxxxxxx' datasrc=pppp);
** All Edit checks **;
Execute(select dbo.fnlds(projectname, 'eng') as Project, CRFDrafts.ProjectId, CRFDrafts.CrfdraftId
into #tmpDrafts
from projects
inner join CRFdrafts on CrfDrafts.projectId = projects.projectid
) by sqlsvr;
create table mmnecdl2 as select *
from connection to sqlsvr
(
Select Draftchecks.CRFDraftId as CRFDraftId, ProjectId, Isvalid, Draftchecks.DraftCheckName as DraftCheckName, Project, created
from #tmpDrafts
inner Join Draftchecks on Draftchecks.crfdraftid = #tmpDrafts.crfdraftid
and isvalid = 1
and created >= "&startdt"
order by Project
);
... View more
