Hi all, I'm running into a problem that has me absolutely stumped.
In my environment, we have 3 locations, and thus 3 file servers and 3 sql servers.
2 of these locations are on 2k advanced, and the third is on 2003 server.
The problem i'm having is involving an ASP script.
To make a lot of code short,
-asp page passes in vars to a store procedure
-stored procedure populates a temp table and uses a sysobjects temp table as well
-temp table is then joined to a View
In the view lies the problem.
in alter mode, it looks like this:
Code:
ALTER view dbo.vw_DSHistory_1 as select top 100 percent datepart(hour,calltime) as HourOfCall, cast(left(callTime,11) as datetime) as DayOfCall, agent, reason, finishcode, resultcode, status, c.job_name from SJ4005_CallHistory as h join SJ4005 as c on h.i3_rowID = c.i3_rowID where calltime between '08/03/2004 8:00:00' and '08/03/2004 23:59:59' order by cast(left(callTime,11) as datetime), datepart(hour,calltime)
The dates and 'SJ4005' is a dynmaically written view passed in vars to the store procedure.
Code:
insert into @tempResults
(fields)
--values in a select:
select
.
.
.
.
from
vw_DSHistory_1 h
group by h.Job_Name, h.DayOfCall, h.HourOfCall
order by h.DayOfCall, h.HourOfCall, h.Job_Name
This all works 100% on two of our servers.
word for word copy paste onto our 3rd, on 2k3, and the view is not updating the variable fields.
Is there a setting im missing?
does 2k3 have some kind of permission issue with passing a var from more than one thing? (asp -> sp -> vw)
Thanks in advance
ASP Free Forums Sponsor:
August 3rd, 2004, 02:51 PM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
