Not sure if this is possible or not but I have a sql file that I'd like to run out of focus SQL editor:

 DECLARE @D1 DATETIME
			DECLARE @D2 DATETIME
			SET @D1 = DATEADD(d,DATEDIFF(d,0,GETDATE())-1,0)
			SET @D2 = DATEADD(D,1,@D1)
 
 
			select
				logid,
				extension,
				calls
			from (
				select distinct
				Lucent_Log_new,
				staffed.logid,
				staffed.extension,
				calls = sum(staffed.acdcalls)
				FROM approach_db a
			LEFT OUTER JOIN 
				dagent staffed
			on
				RIGHT(LTRIM(RTRIM(a.Lucent_Log_new)),7) = (right(ltrim(rtrim(staffed.logid)),7))
			LEFT OUTER JOIN (SELECT DISTINCT AGENTKEY=SUBSTRING(AGENTKEY,4,7)
				FROM FirstCallRes where SEGMENTTIMESTAMP BETWEEN @D1 AND @D2) T
			ON
			RIGHT(LTRIM(RTRIM(a.Lucent_Log_new)),7) = T.AGENTKEY
			WHERE 
			staffed.row_date = @D1 and
			a.EmpRoleID is not null and
			a.EmpRoleID <> 0 and
			a.IS_MANAGER = 0 and
			a.[Is Lead?] = 'No' and
			a.Lucent_Log_new is not null
			AND T.AGENTKEY IS NULL
			group by 
			Lucent_Log_new,
			staffed.logid,
			T.AGENTKEY,
			staffed.extension
			) tbl
			where
			calls > 0
ORDER BY 3 DESC
 

keep getting this error

  THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: SQLOUT
 BYPASSING TO END OF COMMAND

 

The file does contain date parameters. Not sure if that's the reason or not. Thanks for any help possible.

Joe

This message has been edited. Last edited by: Kerry,

Are there any other errors ?

Could you post the code before and after the SQL?

I am not sure if we can do TSQL using WebFocus SQL Pass Thru. Remove the lines where you are declaring your SQL variables.
Then hardcode a date range instead of using SQL variables. If that works then replace your SQL variables with WebFocus variables.

where SEGMENTTIMESTAMP BETWEEN '01/01/2012' AND '12/31/2012'