SELECT TYPE,vendor,discontinueddate, datepart(quarter,[discontinueddate]) AS 'Quarter'

from dbo.EOL

WHERE DISCONTINUEDDATE > DateAdd(M,-24,GETDATE()) and DISCONTINUEDDATE < DATEADD(D, 1, DATEDIFF(D, 0, GetDate()))

Order by Discontinueddate

Hence my question >> do you have access to the html code generated??

I have never worked with RS so I can't help you any further than this. Good luck.

Check this out for articles on performance tuning. This will get you going .

http://www.sqlservercentral.com/articles/articleList.asp?categoryid=37

SELECT TYPE,vendor,discontinueddate, datepart(quarter,[discontinueddate]) AS 'Quarter'

from dbo.EOL

WHERE DISCONTINUEDDATE > DateAdd(M,-24,GETDATE())

Order by Discontinueddate

I'm not gonna answer that on every forum you posted >> I think that the only way you can do that is to put an instead of update trigger in...

There's no fixed number. I can imagine a large datastore having only a few dozen sps running an 8 way server to the ground while another app with 1000+...

do you have access to the html code generated??

...a href="new url" target="NEW"...

I have written a trigger for such a case.  I have a linked server that holds all our billing info but just connecting to it takes like 5 seconds, so...

Sorry, just got back.

Actually re-reading this thread I feel I must add this :

1 - This is the sample code you missed in my link to another thread which...

Insert into dbo.AuditTable (Col1, Col2...) Select Col1, Col2 from Inserted I inner join Deleted D on I.id = D.id where (I.Col1 D.Col1 OR I.Col2 D.Col2...)

select stud_id, last_name, first_name

from stutable1

where stud_id in

(

select stud_id

from stutable1

group by stud_id

having count (stud_id) >1

)

order by last_name, stud_id

Can't help you with that, I never saw that problem or read about it.

Are the databases set to auto-close?

I don't know how to do it from the oracle side... maybe someone else here knows but I guess you'd have better luck on an Oracle site.

I thaught that it may have something to do with reporting but looks like I was wrong...