Search from over 5422 jobs!
Advanced Search
;
				WITH myCTE as 
				(SELECT
					MemberID
					,JobID
					,ContactID
					,CASE Featured
						WHEN 1 THEN 'Featured'
						ELSE 'Standard'
					END as Featured
					,Mass as IsRecruiter
					,Flagship
					,Company
					,Title
					,City
					,state as [State]
					,arealong as Arealong
					,countryName as Country
					,CountryID
					,DateAdded
					,DateActive
					,CASE DateDiff(d, DateActive, GetDate())
						WHEN 0 THEN 
							CASE 
								WHEN DateDiff(hh, DateActive, GetDate()) < 0 THEN 'Just Now'
								WHEN DateDiff(hh, DateActive, GetDate()) = 0 THEN 'Just Now'
								WHEN DateDiff(hh, DateActive, GetDate()) = 1 THEN '1 hour ago'
								ELSE CAST(DateDiff(hh, DateActive, GetDate()) as varchar(3)) + ' hours ago'
							END
						WHEN 1 THEN '1 day ago'
						ELSE 
							CASE 
								WHEN DateDiff(d, DateActive, GetDate()) > 30 THEN '30+ days ago'
								ELSE CAST(DateDiff(d, DateActive, GetDate()) as varchar(4)) + ' days ago'
							END
					END as DateAddedDisplay
					,LastUpdated
					,Category as IndustrySector
					,cCategory as CareerType
					,iCategory as IndustryType
					,(SELECT MPE FROM Job j WHERE j.JobID = job_flat_table.JobID) as MPE
					,FrontPage
					,JobViewCount as [Views]
					,ROW_NUMBER() OVER (PARTITION BY MemberID ORDER BY LastUpdated DESC) as RowNum
					,count(*) over() as TotalJobs 
					,(SELECT PartnerPage FROM Member M WHERE M.MemberID = job_flat_table.MemberID) AS Partner
					,(SELECT COUNT(TrackApplyID) FROM TrackApply TA WHERE TA.JobID = job_flat_table.JobID AND GETDATE() BETWEEN DATEADD(MONTH,-1,GETDATE()) AND DATEADD(DAY,1,GETDATE())) AS NoofApplications
					
				FROM [job_flat_table] WITH(NOLOCK)
				
				WHERE Active = 1 AND Approved = 1 AND MemberID NOT IN (124942,163953,169942)
					AND DateActive < GetDate()
					AND DateExpire > GetDate()
					 AND Mass IN (0)  AND JobTypeID IN (4) 
				)
					SELECT * INTO   #TEMP  FROM myCTE  
	                ORDER BY 
	                    YEAR(LastUpdated) DESC, MONTH(LastUpdated) DESC, DAY(LastUpdated) DESC,
	                    CASE 
	                    
	                        WHEN RowNum <3 THEN 1 
	                        WHEN RowNum <4 THEN 2 
	                        WHEN RowNum <6 THEN 3 
	                        WHEN RowNum <8 THEN 4 
	                        WHEN RowNum <10 THEN 5 
	                        WHEN RowNum <12 THEN 6 
	                        WHEN RowNum <14 THEN 7 
	                        WHEN RowNum <16 THEN 8 
	                        WHEN RowNum <18 THEN 9 
	                        WHEN RowNum <20 THEN 10 
	                        WHEN RowNum <22 THEN 11 
	                        WHEN RowNum <24 THEN 12 
	                        WHEN RowNum <26 THEN 13 
	                        WHEN RowNum <28 THEN 14 
	                        WHEN RowNum <30 THEN 15 
	                        WHEN RowNum <32 THEN 16 
	                        WHEN RowNum <34 THEN 17 
	                        WHEN RowNum <36 THEN 18 
	                        WHEN RowNum <38 THEN 19 
	                        WHEN RowNum <40 THEN 20 
	                        WHEN RowNum <42 THEN 21 
	                        WHEN RowNum <44 THEN 22 
	                        WHEN RowNum <46 THEN 23 
	                        WHEN RowNum <48 THEN 24 
	                        WHEN RowNum <50 THEN 25 
	                        WHEN RowNum <52 THEN 26 
	                        WHEN RowNum <54 THEN 27 
	                        WHEN RowNum <56 THEN 28 
	                        WHEN RowNum <58 THEN 29 
	                        WHEN RowNum <60 THEN 30 
	                        WHEN RowNum <62 THEN 31 
	                        WHEN RowNum <64 THEN 32 
	                        WHEN RowNum <66 THEN 33 
	                        WHEN RowNum <68 THEN 34 
	                        WHEN RowNum <70 THEN 35 
	                        WHEN RowNum <72 THEN 36 
	                        WHEN RowNum <74 THEN 37 
	                        WHEN RowNum <76 THEN 38 
	                        WHEN RowNum <78 THEN 39 
	                        WHEN RowNum <80 THEN 40 
	                        WHEN RowNum <82 THEN 41 
	                        WHEN RowNum <84 THEN 42 
	                        WHEN RowNum <86 THEN 43 
	                        WHEN RowNum <88 THEN 44 
	                        WHEN RowNum <90 THEN 45 
	                        WHEN RowNum <92 THEN 46 
	                        WHEN RowNum <94 THEN 47 
	                        WHEN RowNum <96 THEN 48 
	                        WHEN RowNum <98 THEN 49 
	                        WHEN RowNum <100 THEN 50 
	                        WHEN RowNum <102 THEN 51 
	                        WHEN RowNum <104 THEN 52 
	                        WHEN RowNum <106 THEN 53 
	                        WHEN RowNum <108 THEN 54 
	                        WHEN RowNum <110 THEN 55 
	                        WHEN RowNum <112 THEN 56 
	                        WHEN RowNum <114 THEN 57 
	                        WHEN RowNum <116 THEN 58 
	                        WHEN RowNum <118 THEN 59 
	                        WHEN RowNum <120 THEN 60 
	                        WHEN RowNum <122 THEN 61 
	                        WHEN RowNum <124 THEN 62 
	                        WHEN RowNum <126 THEN 63 
	                        WHEN RowNum <128 THEN 64 
	                        WHEN RowNum <130 THEN 65 
	                        WHEN RowNum <132 THEN 66 
	                        WHEN RowNum <134 THEN 67 
	                        WHEN RowNum <136 THEN 68 
	                        WHEN RowNum <138 THEN 69 
	                        WHEN RowNum <140 THEN 70 
	                        WHEN RowNum <142 THEN 71 
	                        WHEN RowNum <144 THEN 72 
	                        WHEN RowNum <146 THEN 73 
	                        WHEN RowNum <148 THEN 74 
	                        WHEN RowNum <150 THEN 75 
	                        WHEN RowNum <152 THEN 76 
	                        WHEN RowNum <154 THEN 77 
	                        WHEN RowNum <156 THEN 78 
	                        WHEN RowNum <158 THEN 79 
	                        WHEN RowNum <160 THEN 80 
	                        WHEN RowNum <162 THEN 81 
	                        WHEN RowNum <164 THEN 82 
	                        WHEN RowNum <166 THEN 83 
	                        WHEN RowNum <168 THEN 84 
	                        WHEN RowNum <170 THEN 85 
	                        WHEN RowNum <172 THEN 86 
	                        WHEN RowNum <174 THEN 87 
	                        WHEN RowNum <176 THEN 88 
	                        WHEN RowNum <178 THEN 89 
	                        WHEN RowNum <180 THEN 90 
	                        WHEN RowNum <182 THEN 91 
	                        WHEN RowNum <184 THEN 92 
	                        WHEN RowNum <186 THEN 93 
	                        WHEN RowNum <188 THEN 94 
	                        WHEN RowNum <190 THEN 95 
	                        WHEN RowNum <192 THEN 96 
	                        WHEN RowNum <194 THEN 97 
	                        WHEN RowNum <196 THEN 98 
	                        WHEN RowNum <198 THEN 99 
	                        WHEN RowNum <200 THEN 100 
	                        WHEN RowNum <202 THEN 101 
	                        WHEN RowNum <204 THEN 102 
	                        WHEN RowNum <206 THEN 103 
	                        WHEN RowNum <208 THEN 104 
	                        WHEN RowNum <210 THEN 105 
	                        WHEN RowNum <212 THEN 106 
	                        WHEN RowNum <214 THEN 107 
	                        WHEN RowNum <216 THEN 108 
	                        WHEN RowNum <218 THEN 109 
	                        WHEN RowNum <220 THEN 110 
	                        WHEN RowNum <222 THEN 111 
	                        WHEN RowNum <224 THEN 112 
	                        WHEN RowNum <226 THEN 113 
	                        WHEN RowNum <228 THEN 114 
	                        WHEN RowNum <230 THEN 115 
	                        WHEN RowNum <232 THEN 116 
	                        WHEN RowNum <234 THEN 117 
	                        WHEN RowNum <236 THEN 118 
	                        WHEN RowNum <238 THEN 119 
	                        WHEN RowNum <240 THEN 120 
	                        WHEN RowNum <242 THEN 121 
	                        WHEN RowNum <244 THEN 122 
	                        WHEN RowNum <246 THEN 123 
	                        WHEN RowNum <248 THEN 124 
	                        WHEN RowNum <250 THEN 125 
	                        WHEN RowNum <252 THEN 126 
	                        WHEN RowNum <254 THEN 127 
	                        WHEN RowNum <256 THEN 128 
	                        WHEN RowNum <258 THEN 129 
	                        WHEN RowNum <260 THEN 130 
	                        WHEN RowNum <262 THEN 131 
	                        WHEN RowNum <264 THEN 132 
	                        WHEN RowNum <266 THEN 133 
	                        WHEN RowNum <268 THEN 134 
	                        WHEN RowNum <270 THEN 135 
	                        WHEN RowNum <272 THEN 136 
	                        WHEN RowNum <274 THEN 137 
	                        WHEN RowNum <276 THEN 138 
	                        WHEN RowNum <278 THEN 139 
	                        WHEN RowNum <280 THEN 140 
	                        WHEN RowNum <282 THEN 141 
	                        WHEN RowNum <284 THEN 142 
	                        WHEN RowNum <286 THEN 143 
	                        WHEN RowNum <288 THEN 144 
	                        WHEN RowNum <290 THEN 145 
	                        WHEN RowNum <292 THEN 146 
	                        WHEN RowNum <294 THEN 147 
	                        WHEN RowNum <296 THEN 148 
	                        WHEN RowNum <298 THEN 149 
	                        WHEN RowNum <300 THEN 150 
	                        WHEN RowNum <302 THEN 151 
	                        WHEN RowNum <304 THEN 152 
	                        WHEN RowNum <306 THEN 153 
	                        WHEN RowNum <308 THEN 154 
	                        WHEN RowNum <310 THEN 155 
	                        WHEN RowNum <312 THEN 156 
	                        WHEN RowNum <314 THEN 157 
	                        WHEN RowNum <316 THEN 158 
	                        WHEN RowNum <318 THEN 159 
	                        WHEN RowNum <320 THEN 160 
	                        WHEN RowNum <322 THEN 161 
	                        WHEN RowNum <324 THEN 162 
	                        WHEN RowNum <326 THEN 163 
	                        WHEN RowNum <328 THEN 164 
	                        WHEN RowNum <330 THEN 165 
	                        WHEN RowNum <332 THEN 166 
	                        WHEN RowNum <334 THEN 167 
	                        WHEN RowNum <336 THEN 168 
	                        WHEN RowNum <338 THEN 169 
	                        WHEN RowNum <340 THEN 170 
	                        WHEN RowNum <342 THEN 171 
	                        WHEN RowNum <344 THEN 172 
	                        WHEN RowNum <346 THEN 173 
	                        WHEN RowNum <348 THEN 174 
	                        WHEN RowNum <350 THEN 175 
	                        WHEN RowNum <352 THEN 176 
	                        WHEN RowNum <354 THEN 177 
	                        WHEN RowNum <356 THEN 178 
	                        WHEN RowNum <358 THEN 179 
	                        WHEN RowNum <360 THEN 180 
	                        WHEN RowNum <362 THEN 181 
	                        WHEN RowNum <364 THEN 182 
	                        WHEN RowNum <366 THEN 183 
	                        WHEN RowNum <368 THEN 184 
	                        WHEN RowNum <370 THEN 185 
	                        WHEN RowNum <372 THEN 186 
	                        WHEN RowNum <374 THEN 187 
	                        WHEN RowNum <376 THEN 188 
	                        WHEN RowNum <378 THEN 189 
	                        WHEN RowNum <380 THEN 190 
	                        WHEN RowNum <382 THEN 191 
	                        WHEN RowNum <384 THEN 192 
	                        WHEN RowNum <386 THEN 193 
	                        WHEN RowNum <388 THEN 194 
	                        WHEN RowNum <390 THEN 195 
	                        WHEN RowNum <392 THEN 196 
	                        WHEN RowNum <394 THEN 197 
	                        WHEN RowNum <396 THEN 198 
	                        WHEN RowNum <398 THEN 199 
	                        WHEN RowNum <400 THEN 200 
	                    ELSE 202
	                    END
					--SELECT * FROM(SELECT * , RowNumber = ROW_NUMBER() OVER (ORDER BY (SELECT 0)) from   #TEMP)TT 
					SELECT TOP 2 * INTO #MPE FROM #TEMP WHERE MPE = 1 
					SELECT TOP 1 * INTO #PP FROM #TEMP WHERE #TEMP.jobid NOT IN (SELECT jobid FROM #MPE) AND #TEMP.Partner = 1 AND #TEMP.NoofApplications < 10 ORDER BY #TEMP.NoofApplications
					SELECT * INTO #JOBRES FROM #TEMP WHERE #TEMP.jobid NOT IN(SELECT jobid FROM #MPE) AND #TEMP.jobid NOT IN(SELECT jobid FROM #PP)
					SELECT * INTO #RES FROM (SELECT * FROM #MPE UNION ALL SELECT * FROM #PP UNION ALL SELECT * FROM #JOBRES) AS RR 
					SELECT * FROM( SELECT * , RowNumber = ROW_NUMBER() OVER (ORDER BY (SELECT 0)) FROM #RES)TT 
					DROP TABLE #TEMP 
					DROP TABLE #MPE
					DROP TABLE #PP 
					DROP TABLE #JOBRES
					DROP TABLE #RES
				
struct
Cause
struct
ErrorCode 2714
Message [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database.
SQLState 42S01
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database. at macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.execute(Unknown Source) at com.intergral.fusionreactor.jdbc.StatementSurrogate.execute(StatementSurrogate.java:55) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1229) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:517) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:495) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:354) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301) at cfjob2dsearchresults2ecfm80708231._factor17(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:279) at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52) at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:338) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doHttpServletRequest(FusionReactorCoreFilter.java:503) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:337) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 159
RAW_TRACE at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 279
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor17(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:279)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 52
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 1
RAW_TRACE at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 21
RAW_TRACE at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\internships.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 328
RAW_TRACE at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource agcareers
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database.
ErrorCode 42S01
Message Error Executing Database Query.
NativeErrorCode 2714
RootCause
struct
ErrorCode 2714
Message [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database.
SQLState 42S01
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database. at macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.execute(Unknown Source) at com.intergral.fusionreactor.jdbc.StatementSurrogate.execute(StatementSurrogate.java:55) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1229) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:517) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:495) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:354) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301) at cfjob2dsearchresults2ecfm80708231._factor17(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:279) at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52) at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:338) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doHttpServletRequest(FusionReactorCoreFilter.java:503) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:337) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 159
RAW_TRACE at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 279
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor17(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:279)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 52
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 1
RAW_TRACE at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 21
RAW_TRACE at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\internships.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 328
RAW_TRACE at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S01
Sql ; WITH myCTE as (SELECT MemberID ,JobID ,ContactID ,CASE Featured WHEN 1 THEN 'Featured' ELSE 'Standard' END as Featured ,Mass as IsRecruiter ,Flagship ,Company ,Title ,City ,state as [State] ,arealong as Arealong ,countryName as Country ,CountryID ,DateAdded ,DateActive ,CASE DateDiff(d, DateActive, GetDate()) WHEN 0 THEN CASE WHEN DateDiff(hh, DateActive, GetDate()) < 0 THEN 'Just Now' WHEN DateDiff(hh, DateActive, GetDate()) = 0 THEN 'Just Now' WHEN DateDiff(hh, DateActive, GetDate()) = 1 THEN '1 hour ago' ELSE CAST(DateDiff(hh, DateActive, GetDate()) as varchar(3)) + ' hours ago' END WHEN 1 THEN '1 day ago' ELSE CASE WHEN DateDiff(d, DateActive, GetDate()) > 30 THEN '30+ days ago' ELSE CAST(DateDiff(d, DateActive, GetDate()) as varchar(4)) + ' days ago' END END as DateAddedDisplay ,LastUpdated ,Category as IndustrySector ,cCategory as CareerType ,iCategory as IndustryType ,(SELECT MPE FROM Job j WHERE j.JobID = job_flat_table.JobID) as MPE ,FrontPage ,JobViewCount as [Views] ,ROW_NUMBER() OVER (PARTITION BY MemberID ORDER BY LastUpdated DESC) as RowNum ,count(*) over() as TotalJobs ,(SELECT PartnerPage FROM Member M WHERE M.MemberID = job_flat_table.MemberID) AS Partner ,(SELECT COUNT(TrackApplyID) FROM TrackApply TA WHERE TA.JobID = job_flat_table.JobID AND GETDATE() BETWEEN DATEADD(MONTH,-1,GETDATE()) AND DATEADD(DAY,1,GETDATE())) AS NoofApplications FROM [job_flat_table] WITH(NOLOCK) WHERE Active = 1 AND Approved = 1 AND MemberID NOT IN (124942,163953,169942) AND DateActive < GetDate() AND DateExpire > GetDate() AND Mass IN (0) AND JobTypeID IN (4) ) SELECT * INTO #TEMP FROM myCTE ORDER BY YEAR(LastUpdated) DESC, MONTH(LastUpdated) DESC, DAY(LastUpdated) DESC, CASE WHEN RowNum <3 THEN 1 WHEN RowNum <4 THEN 2 WHEN RowNum <6 THEN 3 WHEN RowNum <8 THEN 4 WHEN RowNum <10 THEN 5 WHEN RowNum <12 THEN 6 WHEN RowNum <14 THEN 7 WHEN RowNum <16 THEN 8 WHEN RowNum <18 THEN 9 WHEN RowNum <20 THEN 10 WHEN RowNum <22 THEN 11 WHEN RowNum <24 THEN 12 WHEN RowNum <26 THEN 13 WHEN RowNum <28 THEN 14 WHEN RowNum <30 THEN 15 WHEN RowNum <32 THEN 16 WHEN RowNum <34 THEN 17 WHEN RowNum <36 THEN 18 WHEN RowNum <38 THEN 19 WHEN RowNum <40 THEN 20 WHEN RowNum <42 THEN 21 WHEN RowNum <44 THEN 22 WHEN RowNum <46 THEN 23 WHEN RowNum <48 THEN 24 WHEN RowNum <50 THEN 25 WHEN RowNum <52 THEN 26 WHEN RowNum <54 THEN 27 WHEN RowNum <56 THEN 28 WHEN RowNum <58 THEN 29 WHEN RowNum <60 THEN 30 WHEN RowNum <62 THEN 31 WHEN RowNum <64 THEN 32 WHEN RowNum <66 THEN 33 WHEN RowNum <68 THEN 34 WHEN RowNum <70 THEN 35 WHEN RowNum <72 THEN 36 WHEN RowNum <74 THEN 37 WHEN RowNum <76 THEN 38 WHEN RowNum <78 THEN 39 WHEN RowNum <80 THEN 40 WHEN RowNum <82 THEN 41 WHEN RowNum <84 THEN 42 WHEN RowNum <86 THEN 43 WHEN RowNum <88 THEN 44 WHEN RowNum <90 THEN 45 WHEN RowNum <92 THEN 46 WHEN RowNum <94 THEN 47 WHEN RowNum <96 THEN 48 WHEN RowNum <98 THEN 49 WHEN RowNum <100 THEN 50 WHEN RowNum <102 THEN 51 WHEN RowNum <104 THEN 52 WHEN RowNum <106 THEN 53 WHEN RowNum <108 THEN 54 WHEN RowNum <110 THEN 55 WHEN RowNum <112 THEN 56 WHEN RowNum <114 THEN 57 WHEN RowNum <116 THEN 58 WHEN RowNum <118 THEN 59 WHEN RowNum <120 THEN 60 WHEN RowNum <122 THEN 61 WHEN RowNum <124 THEN 62 WHEN RowNum <126 THEN 63 WHEN RowNum <128 THEN 64 WHEN RowNum <130 THEN 65 WHEN RowNum <132 THEN 66 WHEN RowNum <134 THEN 67 WHEN RowNum <136 THEN 68 WHEN RowNum <138 THEN 69 WHEN RowNum <140 THEN 70 WHEN RowNum <142 THEN 71 WHEN RowNum <144 THEN 72 WHEN RowNum <146 THEN 73 WHEN RowNum <148 THEN 74 WHEN RowNum <150 THEN 75 WHEN RowNum <152 THEN 76 WHEN RowNum <154 THEN 77 WHEN RowNum <156 THEN 78 WHEN RowNum <158 THEN 79 WHEN RowNum <160 THEN 80 WHEN RowNum <162 THEN 81 WHEN RowNum <164 THEN 82 WHEN RowNum <166 THEN 83 WHEN RowNum <168 THEN 84 WHEN RowNum <170 THEN 85 WHEN RowNum <172 THEN 86 WHEN RowNum <174 THEN 87 WHEN RowNum <176 THEN 88 WHEN RowNum <178 THEN 89 WHEN RowNum <180 THEN 90 WHEN RowNum <182 THEN 91 WHEN RowNum <184 THEN 92 WHEN RowNum <186 THEN 93 WHEN RowNum <188 THEN 94 WHEN RowNum <190 THEN 95 WHEN RowNum <192 THEN 96 WHEN RowNum <194 THEN 97 WHEN RowNum <196 THEN 98 WHEN RowNum <198 THEN 99 WHEN RowNum <200 THEN 100 WHEN RowNum <202 THEN 101 WHEN RowNum <204 THEN 102 WHEN RowNum <206 THEN 103 WHEN RowNum <208 THEN 104 WHEN RowNum <210 THEN 105 WHEN RowNum <212 THEN 106 WHEN RowNum <214 THEN 107 WHEN RowNum <216 THEN 108 WHEN RowNum <218 THEN 109 WHEN RowNum <220 THEN 110 WHEN RowNum <222 THEN 111 WHEN RowNum <224 THEN 112 WHEN RowNum <226 THEN 113 WHEN RowNum <228 THEN 114 WHEN RowNum <230 THEN 115 WHEN RowNum <232 THEN 116 WHEN RowNum <234 THEN 117 WHEN RowNum <236 THEN 118 WHEN RowNum <238 THEN 119 WHEN RowNum <240 THEN 120 WHEN RowNum <242 THEN 121 WHEN RowNum <244 THEN 122 WHEN RowNum <246 THEN 123 WHEN RowNum <248 THEN 124 WHEN RowNum <250 THEN 125 WHEN RowNum <252 THEN 126 WHEN RowNum <254 THEN 127 WHEN RowNum <256 THEN 128 WHEN RowNum <258 THEN 129 WHEN RowNum <260 THEN 130 WHEN RowNum <262 THEN 131 WHEN RowNum <264 THEN 132 WHEN RowNum <266 THEN 133 WHEN RowNum <268 THEN 134 WHEN RowNum <270 THEN 135 WHEN RowNum <272 THEN 136 WHEN RowNum <274 THEN 137 WHEN RowNum <276 THEN 138 WHEN RowNum <278 THEN 139 WHEN RowNum <280 THEN 140 WHEN RowNum <282 THEN 141 WHEN RowNum <284 THEN 142 WHEN RowNum <286 THEN 143 WHEN RowNum <288 THEN 144 WHEN RowNum <290 THEN 145 WHEN RowNum <292 THEN 146 WHEN RowNum <294 THEN 147 WHEN RowNum <296 THEN 148 WHEN RowNum <298 THEN 149 WHEN RowNum <300 THEN 150 WHEN RowNum <302 THEN 151 WHEN RowNum <304 THEN 152 WHEN RowNum <306 THEN 153 WHEN RowNum <308 THEN 154 WHEN RowNum <310 THEN 155 WHEN RowNum <312 THEN 156 WHEN RowNum <314 THEN 157 WHEN RowNum <316 THEN 158 WHEN RowNum <318 THEN 159 WHEN RowNum <320 THEN 160 WHEN RowNum <322 THEN 161 WHEN RowNum <324 THEN 162 WHEN RowNum <326 THEN 163 WHEN RowNum <328 THEN 164 WHEN RowNum <330 THEN 165 WHEN RowNum <332 THEN 166 WHEN RowNum <334 THEN 167 WHEN RowNum <336 THEN 168 WHEN RowNum <338 THEN 169 WHEN RowNum <340 THEN 170 WHEN RowNum <342 THEN 171 WHEN RowNum <344 THEN 172 WHEN RowNum <346 THEN 173 WHEN RowNum <348 THEN 174 WHEN RowNum <350 THEN 175 WHEN RowNum <352 THEN 176 WHEN RowNum <354 THEN 177 WHEN RowNum <356 THEN 178 WHEN RowNum <358 THEN 179 WHEN RowNum <360 THEN 180 WHEN RowNum <362 THEN 181 WHEN RowNum <364 THEN 182 WHEN RowNum <366 THEN 183 WHEN RowNum <368 THEN 184 WHEN RowNum <370 THEN 185 WHEN RowNum <372 THEN 186 WHEN RowNum <374 THEN 187 WHEN RowNum <376 THEN 188 WHEN RowNum <378 THEN 189 WHEN RowNum <380 THEN 190 WHEN RowNum <382 THEN 191 WHEN RowNum <384 THEN 192 WHEN RowNum <386 THEN 193 WHEN RowNum <388 THEN 194 WHEN RowNum <390 THEN 195 WHEN RowNum <392 THEN 196 WHEN RowNum <394 THEN 197 WHEN RowNum <396 THEN 198 WHEN RowNum <398 THEN 199 WHEN RowNum <400 THEN 200 ELSE 202 END --SELECT * FROM(SELECT * , RowNumber = ROW_NUMBER() OVER (ORDER BY (SELECT 0)) from #TEMP)TT SELECT TOP 2 * INTO #MPE FROM #TEMP WHERE MPE = 1 SELECT TOP 1 * INTO #PP FROM #TEMP WHERE #TEMP.jobid NOT IN (SELECT jobid FROM #MPE) AND #TEMP.Partner = 1 AND #TEMP.NoofApplications < 10 ORDER BY #TEMP.NoofApplications SELECT * INTO #JOBRES FROM #TEMP WHERE #TEMP.jobid NOT IN(SELECT jobid FROM #MPE) AND #TEMP.jobid NOT IN(SELECT jobid FROM #PP) SELECT * INTO #RES FROM (SELECT * FROM #MPE UNION ALL SELECT * FROM #PP UNION ALL SELECT * FROM #JOBRES) AS RR SELECT * FROM( SELECT * , RowNumber = ROW_NUMBER() OVER (ORDER BY (SELECT 0)) FROM #RES)TT DROP TABLE #TEMP DROP TABLE #MPE DROP TABLE #PP DROP TABLE #JOBRES DROP TABLE #RES
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:595) at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:517) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:495) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:354) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301) at cfjob2dsearchresults2ecfm80708231._factor17(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:279) at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52) at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:338) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doHttpServletRequest(FusionReactorCoreFilter.java:503) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:337) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database. at macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.execute(Unknown Source) at com.intergral.fusionreactor.jdbc.StatementSurrogate.execute(StatementSurrogate.java:55) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1229) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) ... 63 more
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 159
RAW_TRACE at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 279
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor17(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:279)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 52
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 1
RAW_TRACE at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 21
RAW_TRACE at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\internships.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 328
RAW_TRACE at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database.
where [empty string]
;
				WITH myCTE as 
				(SELECT
					MemberID
					,JobID
					,ContactID
					,CASE Featured
						WHEN 1 THEN 'Featured'
						ELSE 'Standard'
					END as Featured
					,Mass as IsRecruiter
					,Flagship
					,Company
					,Title
					,City
					,state as [State]
					,arealong as Arealong
					,countryName as Country
					,CountryID
					,DateAdded
					,DateActive
					,CASE DateDiff(d, DateActive, GetDate())
						WHEN 0 THEN 
							CASE 
								WHEN DateDiff(hh, DateActive, GetDate()) < 0 THEN 'Just Now'
								WHEN DateDiff(hh, DateActive, GetDate()) = 0 THEN 'Just Now'
								WHEN DateDiff(hh, DateActive, GetDate()) = 1 THEN '1 hour ago'
								ELSE CAST(DateDiff(hh, DateActive, GetDate()) as varchar(3)) + ' hours ago'
							END
						WHEN 1 THEN '1 day ago'
						ELSE 
							CASE 
								WHEN DateDiff(d, DateActive, GetDate()) > 30 THEN '30+ days ago'
								ELSE CAST(DateDiff(d, DateActive, GetDate()) as varchar(4)) + ' days ago'
							END
					END as DateAddedDisplay
					,LastUpdated
					,Category as IndustrySector
					,cCategory as CareerType
					,iCategory as IndustryType
					,(SELECT MPE FROM Job j WHERE j.JobID = job_flat_table.JobID) as MPE
					,FrontPage
					,JobViewCount as [Views]
					,ROW_NUMBER() OVER (PARTITION BY MemberID ORDER BY LastUpdated DESC) as RowNum
					,count(*) over() as TotalJobs 
					,(SELECT PartnerPage FROM Member M WHERE M.MemberID = job_flat_table.MemberID) AS Partner
					,(SELECT COUNT(TrackApplyID) FROM TrackApply TA WHERE TA.JobID = job_flat_table.JobID AND GETDATE() BETWEEN DATEADD(MONTH,-1,GETDATE()) AND DATEADD(DAY,1,GETDATE())) AS NoofApplications
					
				FROM [job_flat_table] WITH(NOLOCK)
				
				WHERE Active = 1 AND Approved = 1 AND MemberID NOT IN (124942,163953,169942)
					AND DateActive < GetDate()
					AND DateExpire > GetDate()
					 AND Mass IN (1)  AND JobTypeID IN (4) 
				)
					SELECT * INTO   #TEMP  FROM myCTE  
	                ORDER BY 
	                    YEAR(LastUpdated) DESC, MONTH(LastUpdated) DESC, DAY(LastUpdated) DESC,
	                    CASE 
	                    
	                        WHEN RowNum <3 THEN 1 
	                        WHEN RowNum <4 THEN 2 
	                        WHEN RowNum <6 THEN 3 
	                        WHEN RowNum <8 THEN 4 
	                        WHEN RowNum <10 THEN 5 
	                        WHEN RowNum <12 THEN 6 
	                        WHEN RowNum <14 THEN 7 
	                        WHEN RowNum <16 THEN 8 
	                        WHEN RowNum <18 THEN 9 
	                        WHEN RowNum <20 THEN 10 
	                        WHEN RowNum <22 THEN 11 
	                        WHEN RowNum <24 THEN 12 
	                        WHEN RowNum <26 THEN 13 
	                        WHEN RowNum <28 THEN 14 
	                        WHEN RowNum <30 THEN 15 
	                        WHEN RowNum <32 THEN 16 
	                        WHEN RowNum <34 THEN 17 
	                        WHEN RowNum <36 THEN 18 
	                        WHEN RowNum <38 THEN 19 
	                        WHEN RowNum <40 THEN 20 
	                        WHEN RowNum <42 THEN 21 
	                        WHEN RowNum <44 THEN 22 
	                        WHEN RowNum <46 THEN 23 
	                        WHEN RowNum <48 THEN 24 
	                        WHEN RowNum <50 THEN 25 
	                        WHEN RowNum <52 THEN 26 
	                        WHEN RowNum <54 THEN 27 
	                        WHEN RowNum <56 THEN 28 
	                        WHEN RowNum <58 THEN 29 
	                        WHEN RowNum <60 THEN 30 
	                        WHEN RowNum <62 THEN 31 
	                        WHEN RowNum <64 THEN 32 
	                        WHEN RowNum <66 THEN 33 
	                        WHEN RowNum <68 THEN 34 
	                        WHEN RowNum <70 THEN 35 
	                        WHEN RowNum <72 THEN 36 
	                        WHEN RowNum <74 THEN 37 
	                        WHEN RowNum <76 THEN 38 
	                        WHEN RowNum <78 THEN 39 
	                        WHEN RowNum <80 THEN 40 
	                        WHEN RowNum <82 THEN 41 
	                        WHEN RowNum <84 THEN 42 
	                        WHEN RowNum <86 THEN 43 
	                        WHEN RowNum <88 THEN 44 
	                        WHEN RowNum <90 THEN 45 
	                        WHEN RowNum <92 THEN 46 
	                        WHEN RowNum <94 THEN 47 
	                        WHEN RowNum <96 THEN 48 
	                        WHEN RowNum <98 THEN 49 
	                        WHEN RowNum <100 THEN 50 
	                        WHEN RowNum <102 THEN 51 
	                        WHEN RowNum <104 THEN 52 
	                        WHEN RowNum <106 THEN 53 
	                        WHEN RowNum <108 THEN 54 
	                        WHEN RowNum <110 THEN 55 
	                        WHEN RowNum <112 THEN 56 
	                        WHEN RowNum <114 THEN 57 
	                        WHEN RowNum <116 THEN 58 
	                        WHEN RowNum <118 THEN 59 
	                        WHEN RowNum <120 THEN 60 
	                        WHEN RowNum <122 THEN 61 
	                        WHEN RowNum <124 THEN 62 
	                        WHEN RowNum <126 THEN 63 
	                        WHEN RowNum <128 THEN 64 
	                        WHEN RowNum <130 THEN 65 
	                        WHEN RowNum <132 THEN 66 
	                        WHEN RowNum <134 THEN 67 
	                        WHEN RowNum <136 THEN 68 
	                        WHEN RowNum <138 THEN 69 
	                        WHEN RowNum <140 THEN 70 
	                        WHEN RowNum <142 THEN 71 
	                        WHEN RowNum <144 THEN 72 
	                        WHEN RowNum <146 THEN 73 
	                        WHEN RowNum <148 THEN 74 
	                        WHEN RowNum <150 THEN 75 
	                        WHEN RowNum <152 THEN 76 
	                        WHEN RowNum <154 THEN 77 
	                        WHEN RowNum <156 THEN 78 
	                        WHEN RowNum <158 THEN 79 
	                        WHEN RowNum <160 THEN 80 
	                        WHEN RowNum <162 THEN 81 
	                        WHEN RowNum <164 THEN 82 
	                        WHEN RowNum <166 THEN 83 
	                        WHEN RowNum <168 THEN 84 
	                        WHEN RowNum <170 THEN 85 
	                        WHEN RowNum <172 THEN 86 
	                        WHEN RowNum <174 THEN 87 
	                        WHEN RowNum <176 THEN 88 
	                        WHEN RowNum <178 THEN 89 
	                        WHEN RowNum <180 THEN 90 
	                        WHEN RowNum <182 THEN 91 
	                        WHEN RowNum <184 THEN 92 
	                        WHEN RowNum <186 THEN 93 
	                        WHEN RowNum <188 THEN 94 
	                        WHEN RowNum <190 THEN 95 
	                        WHEN RowNum <192 THEN 96 
	                        WHEN RowNum <194 THEN 97 
	                        WHEN RowNum <196 THEN 98 
	                        WHEN RowNum <198 THEN 99 
	                        WHEN RowNum <200 THEN 100 
	                        WHEN RowNum <202 THEN 101 
	                        WHEN RowNum <204 THEN 102 
	                        WHEN RowNum <206 THEN 103 
	                        WHEN RowNum <208 THEN 104 
	                        WHEN RowNum <210 THEN 105 
	                        WHEN RowNum <212 THEN 106 
	                        WHEN RowNum <214 THEN 107 
	                        WHEN RowNum <216 THEN 108 
	                        WHEN RowNum <218 THEN 109 
	                        WHEN RowNum <220 THEN 110 
	                        WHEN RowNum <222 THEN 111 
	                        WHEN RowNum <224 THEN 112 
	                        WHEN RowNum <226 THEN 113 
	                        WHEN RowNum <228 THEN 114 
	                        WHEN RowNum <230 THEN 115 
	                        WHEN RowNum <232 THEN 116 
	                        WHEN RowNum <234 THEN 117 
	                        WHEN RowNum <236 THEN 118 
	                        WHEN RowNum <238 THEN 119 
	                        WHEN RowNum <240 THEN 120 
	                        WHEN RowNum <242 THEN 121 
	                        WHEN RowNum <244 THEN 122 
	                        WHEN RowNum <246 THEN 123 
	                        WHEN RowNum <248 THEN 124 
	                        WHEN RowNum <250 THEN 125 
	                        WHEN RowNum <252 THEN 126 
	                        WHEN RowNum <254 THEN 127 
	                        WHEN RowNum <256 THEN 128 
	                        WHEN RowNum <258 THEN 129 
	                        WHEN RowNum <260 THEN 130 
	                        WHEN RowNum <262 THEN 131 
	                        WHEN RowNum <264 THEN 132 
	                        WHEN RowNum <266 THEN 133 
	                        WHEN RowNum <268 THEN 134 
	                        WHEN RowNum <270 THEN 135 
	                        WHEN RowNum <272 THEN 136 
	                        WHEN RowNum <274 THEN 137 
	                        WHEN RowNum <276 THEN 138 
	                        WHEN RowNum <278 THEN 139 
	                        WHEN RowNum <280 THEN 140 
	                        WHEN RowNum <282 THEN 141 
	                        WHEN RowNum <284 THEN 142 
	                        WHEN RowNum <286 THEN 143 
	                        WHEN RowNum <288 THEN 144 
	                        WHEN RowNum <290 THEN 145 
	                        WHEN RowNum <292 THEN 146 
	                        WHEN RowNum <294 THEN 147 
	                        WHEN RowNum <296 THEN 148 
	                        WHEN RowNum <298 THEN 149 
	                        WHEN RowNum <300 THEN 150 
	                        WHEN RowNum <302 THEN 151 
	                        WHEN RowNum <304 THEN 152 
	                        WHEN RowNum <306 THEN 153 
	                        WHEN RowNum <308 THEN 154 
	                        WHEN RowNum <310 THEN 155 
	                        WHEN RowNum <312 THEN 156 
	                        WHEN RowNum <314 THEN 157 
	                        WHEN RowNum <316 THEN 158 
	                        WHEN RowNum <318 THEN 159 
	                        WHEN RowNum <320 THEN 160 
	                        WHEN RowNum <322 THEN 161 
	                        WHEN RowNum <324 THEN 162 
	                        WHEN RowNum <326 THEN 163 
	                        WHEN RowNum <328 THEN 164 
	                        WHEN RowNum <330 THEN 165 
	                        WHEN RowNum <332 THEN 166 
	                        WHEN RowNum <334 THEN 167 
	                        WHEN RowNum <336 THEN 168 
	                        WHEN RowNum <338 THEN 169 
	                        WHEN RowNum <340 THEN 170 
	                        WHEN RowNum <342 THEN 171 
	                        WHEN RowNum <344 THEN 172 
	                        WHEN RowNum <346 THEN 173 
	                        WHEN RowNum <348 THEN 174 
	                        WHEN RowNum <350 THEN 175 
	                        WHEN RowNum <352 THEN 176 
	                        WHEN RowNum <354 THEN 177 
	                        WHEN RowNum <356 THEN 178 
	                        WHEN RowNum <358 THEN 179 
	                        WHEN RowNum <360 THEN 180 
	                        WHEN RowNum <362 THEN 181 
	                        WHEN RowNum <364 THEN 182 
	                        WHEN RowNum <366 THEN 183 
	                        WHEN RowNum <368 THEN 184 
	                        WHEN RowNum <370 THEN 185 
	                        WHEN RowNum <372 THEN 186 
	                        WHEN RowNum <374 THEN 187 
	                        WHEN RowNum <376 THEN 188 
	                        WHEN RowNum <378 THEN 189 
	                        WHEN RowNum <380 THEN 190 
	                        WHEN RowNum <382 THEN 191 
	                        WHEN RowNum <384 THEN 192 
	                        WHEN RowNum <386 THEN 193 
	                        WHEN RowNum <388 THEN 194 
	                        WHEN RowNum <390 THEN 195 
	                        WHEN RowNum <392 THEN 196 
	                        WHEN RowNum <394 THEN 197 
	                        WHEN RowNum <396 THEN 198 
	                        WHEN RowNum <398 THEN 199 
	                        WHEN RowNum <400 THEN 200 
	                    ELSE 202
	                    END
					--SELECT * FROM(SELECT * , RowNumber = ROW_NUMBER() OVER (ORDER BY (SELECT 0)) from   #TEMP)TT 
					SELECT TOP 2 * INTO #MPE FROM #TEMP WHERE MPE = 1 
					SELECT TOP 1 * INTO #PP FROM #TEMP WHERE #TEMP.jobid NOT IN (SELECT jobid FROM #MPE) AND #TEMP.Partner = 1 AND #TEMP.NoofApplications < 10 ORDER BY #TEMP.NoofApplications
					SELECT * INTO #JOBRES FROM #TEMP WHERE #TEMP.jobid NOT IN(SELECT jobid FROM #MPE) AND #TEMP.jobid NOT IN(SELECT jobid FROM #PP)
					SELECT * INTO #RES FROM (SELECT * FROM #MPE UNION ALL SELECT * FROM #PP UNION ALL SELECT * FROM #JOBRES) AS RR 
					SELECT * FROM( SELECT * , RowNumber = ROW_NUMBER() OVER (ORDER BY (SELECT 0)) FROM #RES)TT 
					DROP TABLE #TEMP 
					DROP TABLE #MPE
					DROP TABLE #PP 
					DROP TABLE #JOBRES
					DROP TABLE #RES
				
struct
Cause
struct
ErrorCode 2714
Message [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database.
SQLState 42S01
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database. at macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.execute(Unknown Source) at com.intergral.fusionreactor.jdbc.StatementSurrogate.execute(StatementSurrogate.java:55) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1229) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:517) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:495) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:354) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301) at cfjob2dsearchresults2ecfm80708231._factor18(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:306) at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52) at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:338) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doHttpServletRequest(FusionReactorCoreFilter.java:503) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:337) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 159
RAW_TRACE at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 306
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor18(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:306)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 52
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 1
RAW_TRACE at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 21
RAW_TRACE at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\internships.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 328
RAW_TRACE at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource agcareers
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database.
ErrorCode 42S01
Message Error Executing Database Query.
NativeErrorCode 2714
RootCause
struct
ErrorCode 2714
Message [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database.
SQLState 42S01
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database. at macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.execute(Unknown Source) at com.intergral.fusionreactor.jdbc.StatementSurrogate.execute(StatementSurrogate.java:55) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1229) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:517) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:495) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:354) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301) at cfjob2dsearchresults2ecfm80708231._factor18(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:306) at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52) at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:338) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doHttpServletRequest(FusionReactorCoreFilter.java:503) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:337) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 159
RAW_TRACE at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 306
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor18(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:306)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 52
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 1
RAW_TRACE at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 21
RAW_TRACE at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\internships.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 328
RAW_TRACE at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S01
Sql ; WITH myCTE as (SELECT MemberID ,JobID ,ContactID ,CASE Featured WHEN 1 THEN 'Featured' ELSE 'Standard' END as Featured ,Mass as IsRecruiter ,Flagship ,Company ,Title ,City ,state as [State] ,arealong as Arealong ,countryName as Country ,CountryID ,DateAdded ,DateActive ,CASE DateDiff(d, DateActive, GetDate()) WHEN 0 THEN CASE WHEN DateDiff(hh, DateActive, GetDate()) < 0 THEN 'Just Now' WHEN DateDiff(hh, DateActive, GetDate()) = 0 THEN 'Just Now' WHEN DateDiff(hh, DateActive, GetDate()) = 1 THEN '1 hour ago' ELSE CAST(DateDiff(hh, DateActive, GetDate()) as varchar(3)) + ' hours ago' END WHEN 1 THEN '1 day ago' ELSE CASE WHEN DateDiff(d, DateActive, GetDate()) > 30 THEN '30+ days ago' ELSE CAST(DateDiff(d, DateActive, GetDate()) as varchar(4)) + ' days ago' END END as DateAddedDisplay ,LastUpdated ,Category as IndustrySector ,cCategory as CareerType ,iCategory as IndustryType ,(SELECT MPE FROM Job j WHERE j.JobID = job_flat_table.JobID) as MPE ,FrontPage ,JobViewCount as [Views] ,ROW_NUMBER() OVER (PARTITION BY MemberID ORDER BY LastUpdated DESC) as RowNum ,count(*) over() as TotalJobs ,(SELECT PartnerPage FROM Member M WHERE M.MemberID = job_flat_table.MemberID) AS Partner ,(SELECT COUNT(TrackApplyID) FROM TrackApply TA WHERE TA.JobID = job_flat_table.JobID AND GETDATE() BETWEEN DATEADD(MONTH,-1,GETDATE()) AND DATEADD(DAY,1,GETDATE())) AS NoofApplications FROM [job_flat_table] WITH(NOLOCK) WHERE Active = 1 AND Approved = 1 AND MemberID NOT IN (124942,163953,169942) AND DateActive < GetDate() AND DateExpire > GetDate() AND Mass IN (1) AND JobTypeID IN (4) ) SELECT * INTO #TEMP FROM myCTE ORDER BY YEAR(LastUpdated) DESC, MONTH(LastUpdated) DESC, DAY(LastUpdated) DESC, CASE WHEN RowNum <3 THEN 1 WHEN RowNum <4 THEN 2 WHEN RowNum <6 THEN 3 WHEN RowNum <8 THEN 4 WHEN RowNum <10 THEN 5 WHEN RowNum <12 THEN 6 WHEN RowNum <14 THEN 7 WHEN RowNum <16 THEN 8 WHEN RowNum <18 THEN 9 WHEN RowNum <20 THEN 10 WHEN RowNum <22 THEN 11 WHEN RowNum <24 THEN 12 WHEN RowNum <26 THEN 13 WHEN RowNum <28 THEN 14 WHEN RowNum <30 THEN 15 WHEN RowNum <32 THEN 16 WHEN RowNum <34 THEN 17 WHEN RowNum <36 THEN 18 WHEN RowNum <38 THEN 19 WHEN RowNum <40 THEN 20 WHEN RowNum <42 THEN 21 WHEN RowNum <44 THEN 22 WHEN RowNum <46 THEN 23 WHEN RowNum <48 THEN 24 WHEN RowNum <50 THEN 25 WHEN RowNum <52 THEN 26 WHEN RowNum <54 THEN 27 WHEN RowNum <56 THEN 28 WHEN RowNum <58 THEN 29 WHEN RowNum <60 THEN 30 WHEN RowNum <62 THEN 31 WHEN RowNum <64 THEN 32 WHEN RowNum <66 THEN 33 WHEN RowNum <68 THEN 34 WHEN RowNum <70 THEN 35 WHEN RowNum <72 THEN 36 WHEN RowNum <74 THEN 37 WHEN RowNum <76 THEN 38 WHEN RowNum <78 THEN 39 WHEN RowNum <80 THEN 40 WHEN RowNum <82 THEN 41 WHEN RowNum <84 THEN 42 WHEN RowNum <86 THEN 43 WHEN RowNum <88 THEN 44 WHEN RowNum <90 THEN 45 WHEN RowNum <92 THEN 46 WHEN RowNum <94 THEN 47 WHEN RowNum <96 THEN 48 WHEN RowNum <98 THEN 49 WHEN RowNum <100 THEN 50 WHEN RowNum <102 THEN 51 WHEN RowNum <104 THEN 52 WHEN RowNum <106 THEN 53 WHEN RowNum <108 THEN 54 WHEN RowNum <110 THEN 55 WHEN RowNum <112 THEN 56 WHEN RowNum <114 THEN 57 WHEN RowNum <116 THEN 58 WHEN RowNum <118 THEN 59 WHEN RowNum <120 THEN 60 WHEN RowNum <122 THEN 61 WHEN RowNum <124 THEN 62 WHEN RowNum <126 THEN 63 WHEN RowNum <128 THEN 64 WHEN RowNum <130 THEN 65 WHEN RowNum <132 THEN 66 WHEN RowNum <134 THEN 67 WHEN RowNum <136 THEN 68 WHEN RowNum <138 THEN 69 WHEN RowNum <140 THEN 70 WHEN RowNum <142 THEN 71 WHEN RowNum <144 THEN 72 WHEN RowNum <146 THEN 73 WHEN RowNum <148 THEN 74 WHEN RowNum <150 THEN 75 WHEN RowNum <152 THEN 76 WHEN RowNum <154 THEN 77 WHEN RowNum <156 THEN 78 WHEN RowNum <158 THEN 79 WHEN RowNum <160 THEN 80 WHEN RowNum <162 THEN 81 WHEN RowNum <164 THEN 82 WHEN RowNum <166 THEN 83 WHEN RowNum <168 THEN 84 WHEN RowNum <170 THEN 85 WHEN RowNum <172 THEN 86 WHEN RowNum <174 THEN 87 WHEN RowNum <176 THEN 88 WHEN RowNum <178 THEN 89 WHEN RowNum <180 THEN 90 WHEN RowNum <182 THEN 91 WHEN RowNum <184 THEN 92 WHEN RowNum <186 THEN 93 WHEN RowNum <188 THEN 94 WHEN RowNum <190 THEN 95 WHEN RowNum <192 THEN 96 WHEN RowNum <194 THEN 97 WHEN RowNum <196 THEN 98 WHEN RowNum <198 THEN 99 WHEN RowNum <200 THEN 100 WHEN RowNum <202 THEN 101 WHEN RowNum <204 THEN 102 WHEN RowNum <206 THEN 103 WHEN RowNum <208 THEN 104 WHEN RowNum <210 THEN 105 WHEN RowNum <212 THEN 106 WHEN RowNum <214 THEN 107 WHEN RowNum <216 THEN 108 WHEN RowNum <218 THEN 109 WHEN RowNum <220 THEN 110 WHEN RowNum <222 THEN 111 WHEN RowNum <224 THEN 112 WHEN RowNum <226 THEN 113 WHEN RowNum <228 THEN 114 WHEN RowNum <230 THEN 115 WHEN RowNum <232 THEN 116 WHEN RowNum <234 THEN 117 WHEN RowNum <236 THEN 118 WHEN RowNum <238 THEN 119 WHEN RowNum <240 THEN 120 WHEN RowNum <242 THEN 121 WHEN RowNum <244 THEN 122 WHEN RowNum <246 THEN 123 WHEN RowNum <248 THEN 124 WHEN RowNum <250 THEN 125 WHEN RowNum <252 THEN 126 WHEN RowNum <254 THEN 127 WHEN RowNum <256 THEN 128 WHEN RowNum <258 THEN 129 WHEN RowNum <260 THEN 130 WHEN RowNum <262 THEN 131 WHEN RowNum <264 THEN 132 WHEN RowNum <266 THEN 133 WHEN RowNum <268 THEN 134 WHEN RowNum <270 THEN 135 WHEN RowNum <272 THEN 136 WHEN RowNum <274 THEN 137 WHEN RowNum <276 THEN 138 WHEN RowNum <278 THEN 139 WHEN RowNum <280 THEN 140 WHEN RowNum <282 THEN 141 WHEN RowNum <284 THEN 142 WHEN RowNum <286 THEN 143 WHEN RowNum <288 THEN 144 WHEN RowNum <290 THEN 145 WHEN RowNum <292 THEN 146 WHEN RowNum <294 THEN 147 WHEN RowNum <296 THEN 148 WHEN RowNum <298 THEN 149 WHEN RowNum <300 THEN 150 WHEN RowNum <302 THEN 151 WHEN RowNum <304 THEN 152 WHEN RowNum <306 THEN 153 WHEN RowNum <308 THEN 154 WHEN RowNum <310 THEN 155 WHEN RowNum <312 THEN 156 WHEN RowNum <314 THEN 157 WHEN RowNum <316 THEN 158 WHEN RowNum <318 THEN 159 WHEN RowNum <320 THEN 160 WHEN RowNum <322 THEN 161 WHEN RowNum <324 THEN 162 WHEN RowNum <326 THEN 163 WHEN RowNum <328 THEN 164 WHEN RowNum <330 THEN 165 WHEN RowNum <332 THEN 166 WHEN RowNum <334 THEN 167 WHEN RowNum <336 THEN 168 WHEN RowNum <338 THEN 169 WHEN RowNum <340 THEN 170 WHEN RowNum <342 THEN 171 WHEN RowNum <344 THEN 172 WHEN RowNum <346 THEN 173 WHEN RowNum <348 THEN 174 WHEN RowNum <350 THEN 175 WHEN RowNum <352 THEN 176 WHEN RowNum <354 THEN 177 WHEN RowNum <356 THEN 178 WHEN RowNum <358 THEN 179 WHEN RowNum <360 THEN 180 WHEN RowNum <362 THEN 181 WHEN RowNum <364 THEN 182 WHEN RowNum <366 THEN 183 WHEN RowNum <368 THEN 184 WHEN RowNum <370 THEN 185 WHEN RowNum <372 THEN 186 WHEN RowNum <374 THEN 187 WHEN RowNum <376 THEN 188 WHEN RowNum <378 THEN 189 WHEN RowNum <380 THEN 190 WHEN RowNum <382 THEN 191 WHEN RowNum <384 THEN 192 WHEN RowNum <386 THEN 193 WHEN RowNum <388 THEN 194 WHEN RowNum <390 THEN 195 WHEN RowNum <392 THEN 196 WHEN RowNum <394 THEN 197 WHEN RowNum <396 THEN 198 WHEN RowNum <398 THEN 199 WHEN RowNum <400 THEN 200 ELSE 202 END --SELECT * FROM(SELECT * , RowNumber = ROW_NUMBER() OVER (ORDER BY (SELECT 0)) from #TEMP)TT SELECT TOP 2 * INTO #MPE FROM #TEMP WHERE MPE = 1 SELECT TOP 1 * INTO #PP FROM #TEMP WHERE #TEMP.jobid NOT IN (SELECT jobid FROM #MPE) AND #TEMP.Partner = 1 AND #TEMP.NoofApplications < 10 ORDER BY #TEMP.NoofApplications SELECT * INTO #JOBRES FROM #TEMP WHERE #TEMP.jobid NOT IN(SELECT jobid FROM #MPE) AND #TEMP.jobid NOT IN(SELECT jobid FROM #PP) SELECT * INTO #RES FROM (SELECT * FROM #MPE UNION ALL SELECT * FROM #PP UNION ALL SELECT * FROM #JOBRES) AS RR SELECT * FROM( SELECT * , RowNumber = ROW_NUMBER() OVER (ORDER BY (SELECT 0)) FROM #RES)TT DROP TABLE #TEMP DROP TABLE #MPE DROP TABLE #PP DROP TABLE #JOBRES DROP TABLE #RES
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:595) at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:517) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:495) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:354) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301) at cfjob2dsearchresults2ecfm80708231._factor18(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:306) at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52) at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:338) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doHttpServletRequest(FusionReactorCoreFilter.java:503) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:337) at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database. at macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseStatement.execute(Unknown Source) at com.intergral.fusionreactor.jdbc.StatementSurrogate.execute(StatementSurrogate.java:55) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1229) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) ... 63 more
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 159
RAW_TRACE at cfjobSearch2ecfc837844191$funcGETJOBSEARCHRESULT.runFunction(C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc:159)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\cfc\jobSearch.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 306
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor18(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:306)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 52
RAW_TRACE at cfjob2dsearchresults2ecfm80708231._factor19(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:52)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_JOB-SEARCHRESULTS
LINE 1
RAW_TRACE at cfjob2dsearchresults2ecfm80708231.runPage(C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm:1)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\includes\job-searchresults.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 21
RAW_TRACE at cfinternships2ecfm1143696197.runPage(C:\inetpub\wwwroot\agcareers\www\internships.cfm:21)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\internships.cfm
TYPE CFML
6
struct
COLUMN 0
ID CFINCLUDE
LINE 328
RAW_TRACE at cfapplication2ecfc1768460580$funcONREQUEST.runFunction(C:\inetpub\wwwroot\agcareers\www\application.cfc:328)
TEMPLATE C:\inetpub\wwwroot\agcareers\www\application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object named '#TEMP' in the database.
where [empty string]

An error was encountered while performing your search.

If you were doing a keywrod search, it is possible that there was a problem with the search string you provided.

Please use the Advanced Search.



Advanced Career Search


Industry Sector: Agribusiness
Food/Processing
Government/Industry Groups
Production/Farming
Industry Type:
Animal Health
Animal Production - Beef
Animal Production - Dairy
Animal Production - Other
Animal Production - Poultry
Animal Production - Swine
Aquaculture, Fishing, Seafood
Chemical, Pesticide and Fertilizer
Commodities and Trading
Communications, Promotion, and Public Relations
Crop Production
Education and Extension
Energy, Biofuels and Alternative Energy
Equipment, Manufacturing and Technical
Feed Nutrition
Finance, Banking, Insurance and Real Estate
Food & Beverage Products and Processing
Government, Policy and Legal
Horticulture, Turf, Viticulture and Ornamental
Input Retail, Cooperative and Related Crop Services
Natural Resources, Environmental, Mining and Forestry
Pest Management
Plant & Soil Sciences, Seed and Biotechnology
Precision Ag
Produce and Produce Related Services
Career Type:
Accounting/Finance/Asset Management
Administrative/Clerical
Agronomist
Analyst/Estimator
Business Development/Strategic Management
Communications/Public Relations
Consultant/Agent
Crop Scout
Custom Applicator/Pest Control
Customer Support
Economist
Editorial/Writing
Education/Training
Engineering
Farm & Ranch Operations/Herdsperson/On Farm
Food Services/Hospitality
Human Resources
IT/Software Development
Legal/Policy
Logistics/Distribution
Maintenance/Repair
Manufacturing/Production
Marketing/Branding
Medical/Health/Safety
Merchandiser/Trader/Broker
Nutritionist/Formulator
Operations
Operator/General Laborer
Processing
Procurement/Purchasing
Project/Program Management/Construction
Quality Assurance
Researcher/Research & Development
Risk Management/Security
Sales/Retail
Scientist
Skilled and Technical Trades
Specialists
Technician
Transportation/Truck Driver
Veterinarian/Vet Assistant
Warehouse/Cellar Worker/Inventory
Years Experience:
Country:
Region:
State:
All Words:
Exact Phrase:
Exclude words:
Any word:
 
Search Help:
Keyword:
  • All Words: All of the words in this list will be found in the job posting.
  • Exact Phrase: The exact phrase enterd will be found in the job posting.
  • Exclude Words: None of the words in this list will be found in the job posting.
  • Any Words: Any of the words in this list will be found in the job posting.
You can use any combination keyword options when searching.
Career/Industry Type: You can select as many as you like, by not selecting any, it will search all career and industry types.

Signup Newsletter

Sign up for our Newsletter

Applicant    Employer

University Partner

University Partners

The AgCareers.com University Partners program is designed to showcase and share information about educational advancement opportunities in agriculture for our users.