Is is possible to rewrite this cursor to CTE to gain some performance benefit:

BEGIN

DECLARE yr_cursor CURSOR

FOR

...

Thanks guys; its working fine now

Thanks for trying at least Lowell

Attached the proc for your review; please let me know how I can replace the cursors to set based operations.

Thnks

I am also attaching the index fragmentation percentage on the db

Ooops sorry, forgot to attach the file....

Even after I did reorganized index and updated statistics on the table that is heavily used by the view , I don't see any performance improvement. I am attaching my...

Thanks a bunch!

Also, can you please point me to a good link about tuning a query or Stored Procs

Regards

Aj

Hello

can you please look the execution plan and let me know if you see anything I can do to improve the query performance; I would appreciate it so much

I am...

Yes, I need to ; because I am modifying the existing procedure where it written in dynamic sql

Sorry, I meant to say I need to know how can prevent from sql injection

Yes, you are right; basically, I am getting the @year as varchar(4) parameter and I need to add that in the dynamic sql where clause with other condition. Can...

Thanks

Also, how can I create an index on a computed column such as " incident_year"

Thanks

Right function is not getting the data; in the table it is datetime but I converted to varchar(10) in the view like this...

CONVERT(VARCHAR(10),I.DateOfIncidentDte, 110 ) as incident_date

Thanks

Thanks so much, but when I am running the query Datepart function is not getting the year from the column which should be 2011