try formatting your value fields in the report before exporting. Use something like "0" or "0.00" in the format field and see if that works

The last of the three I got now. Please let me know if you need more info

Blocked stmt

(@P1 nchar(12),@P2 float,@P3 float)

SELECT * FROM JDE_PRODUCTION.PRODDTA.F4941

WHERE (...

here is another:

Blocked stmt

(@P1 nchar(10),@P2 nchar(30),@P3 float,@P4 float,@P5 float,@P6 float,@P7 float,@P8 float,@P9 float,@P10 nchar(15),@P11 nchar(2),@P12 numeric(18, 0),@P13 float,@P14 float,@P15 numeric(18, 0),@P16 float)

INSERT INTO JDE_PRODUCTION.PRODDTA.F57CD100

VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16)

BLOCKING STMT

(@P1 float)SELECT *...

Hi - Sorry it took so long. Problem came up now again. You will see the result of the query and that the table select that is blocking has nothing...

Will investigate the memory thanks.

As far as I know it will then give diff waittime not a lck. Do you know of a way to make sure, accept for the normal perfmon?

Here is some screen shots.

Actually I am still struggeling to see what the code is that is blocking. I have tried activity monitor and inputbuffer but the system is giving me the same query...

Maybe found the problem. The command "DBCC inputbuffer" did not give the correct code that was actualy locking tables. I checked the activity monitor and that session had 4 diff...

I ran that query while the locks was in place but the query did not return any information.

Yes I fixed the SP and it is working fine now. Are you saying that SQL gets stuck on par sniffing for 3 hours? Thats how long I ran the...

I understand that it will take longer to create the exec plan but should it take this long? I have been running the execute SP for 55 min now and...

thanks for the replies. I did discuss these points with the developer of the report and they are unable to change the way it works. This is a KRONOS database...

it split a comma delimited string into fields. +- 6 fields.

wschampheleer (2/4/2010)

---

Here's what I would do:

- consider adding the missing index that the sqlplan mentions

- use a temp table #timesheets rather than a table variable @timesheets to see whether that...