Database

--------------------------------------------------------------------------------

I have spent weeks on a SSRS reporting services 2005 report. I set up a subscription to email automatically. Managers with Outlook 2003 can view the report perfectly. Managers with Outlook 2007 get a truncated and garbled email report from Report Manager. Has anyone come across this before???

When migrating from oracle 10g to 11g, I've a stored procedure with a syntax like:

select * from table1
union
select t,y from
(select * from table2)aliasQuery
where (select max(t)from (select t from table 3 where table3. t=aliasQuery.t)

query works well with 10g but 11g returns error that aliasQuery not defined

may be this syntax no longer supported in 11g or here is some database missing configurations

Thanks