You are here: Re: Identifying results sets when stored procedure called multiple times « MsSQL Server « IT news, forums, messages
Re: Identifying results sets when stored procedure called multiple times

Posted by wxbuff on 10/19/05 04:25

Erland -

Thanks for the reply.

I work for a software company whose support organiztion is broken into
groups. Each group supports certain products and within each group
there are multiple support levels (the typical level 1, level 2
etc...). The management would like a report to follow some parameters
such as the number of new support incidents in a given period, the
number closed etc...

At the first level, the report returns results based on the level of
the support worker regardless of the products.

The next level of breakdown is by product. That is where I used my
phrase 'parsing' - I have a cursor that reads the products for which
incidents were opened during the specified period and a table is
created summarizing the work done for each product.

As I sit here, I realize that there are efficiencies to be gained
(maybe? - I am still a novice) by using 'group by' etc... but I was
specfically asked to create a report that showed discrete tables for
each product. Hence the cursor.

I appreciate what you are saying about performance but the concern
there is not as high as it might be elsewhere as this report will run
on a weekend against a server which is not supporting other heavily
utilized applications.

Hope this helps clarify.

Danielle

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация