i tried all different ways like closing the browser clear cahce but nothing worked

i am able to run the report locally but when i am running from report server it...

that is the error i am getting

i am thinking that it is the session id ?

this is the error i am getting

i can run other reports in the same environment

Server Error in '/Reports' Application.

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

Execution '4ixfea55rytq2nzmekuussm3' cannot be found (rsExecutionNotFound)

Description: An unhandled exception occurred during...

unfortunaltely i cant post the sql but i can give what i am doing

i created temp tables for looping the databases and for each database there are set of select...

i apolozige for writing in CAPS

i got the following error long time back

Msg 701, Level 17, State 65, Procedure aaa_proc, Line 1249

There is insufficient system memory to run this query.

but...

thanks all for ur help

i think i found the solution using the above( i am not using function to include in dynamic sql)

i used coalesce and >. Let me...

thank you for the reply

i am using it in a dynamic sql so unpivot is difficult?

Is there any other way like using coalsce and order by ?

pls suggest

All thanks for your help .

Problem is resolved.Problem is datatype difference and i changed and it worked fine.

Once again thanks for all your help

actually i used single column

Thank you

I don't know how many paritions but thanks for ur reply

So one Database can have multiple partitions ?

Thank you lowell but do i need to be an DBA to run this adhoc queries

but what if they are having different credentials

verify the format of date it is displaying (10-27-2010)

try this:

use top operator to get one format and delete the other rows

sample code:

delete from tablename where format not in (select top 1 format from tablename

group by isbn,group,format)

let me...