Let them try , fair use applies here 😀

SQLkiwi (3/4/2011)

---

Plagiarism is when you're pretending the work is your own and not giving proper credit.

Copyright infringement is when you're reprinting the work without permission.

It is possible to do both...

Try this link http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Glad to help ,

The plan is indeed a window into exactly what sqlserver has done ( and to a certain extent, why) to resolve the query.

Design is everything ,...

Data type look poorly thought out to me, why are year and qtr varchar's ?

SELECT TOP 20 PrimSSN, SecSSN, [Year], DocType, [PageCount], ReturnId, IMAGEPATH

FROM finals WHERE [Year] = '2009' AND

(PrimSSN...

Please post the DDL , the plan has many convert implicits in it.

Just be sure to ensure that performance is within SLA boundaries with a production size of data.

Homework ?

Try this article

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

The scheduled reports are implemented by SqlAgent jobs.

Is SQLAgent running on the machine ? Is there any thing of relevance in the Agent error log ?

1 ) http://tinyurl.com/6fmaq32

2) http://tinyurl.com/4vzkg4n

3) http://tinyurl.com/4s8l977

:Whistling:

Please see this post (http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ ) for how best to help us to help you

It would seem to me that if you are having to do this sort of dynamic update on a regular basis, something is wrong with you design.

If you can revisit...

Gianluca Sartori (3/2/2011)

---

I wish I could, Jeff!

This statement is inside a system stored procedure and I can't modify it. I must admit I tried (when everything else failed) and my...

Sound like a rolling balance problem,

use a cursor or take a look at a 'quirky update' solution.

This is the file for the...