That is true, but I have run it in SQL 2008 and yes it does work ...

Glad I was able to assist, and I thank you for letting me know.

Here is a SP that I have utilized, you may want to try it. It searches more than just SPs.

CREATE PROCEDURE [dbo].[UDP_FindWordsInaSP]

@Watchword varchar(50)

AS

SELECT distinct

'type' = case...

Congratulations

Thanks for helping so many like myself, even though we do not acknowledge it at the time ... again thanks.

Nice question - straight forward, no tricks -- Thanks

calvo (6/14/2011)

Think that's a MS typo? That page references SQL Server 2008 versions and breaks down the free editions into compact and express. Compact...

http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

Gives 4GB as max database size

GSquared (6/14/2011)

But that almost gets me started on MS Word. I HATE the programmers who wrote that piece of junk and all of the ways it thinks it knows what...

kish1234

I have extracted a portion of your posting and present it below in a readily consumable format. However the table definition and supplied data appears to be...

I am sure that what you have posted is very clear to yourself. But for those who wish to help you, with a tested solution, please post the table...

Many who would attempt to render assistance, most likely would not be familiar with a UB92 form, nor have you given them any idea of where that data for said...

Nice clear question - thanks

To receive tested help please post table definition, including indexes, along with sample data and desired results. You can do this simply if you read the article whose link...

Might I suggest a little reading to help you find the right path to follow.

http://www.sql-server-performance.com/2009/identify-missing-indexes-using-sql-server-dmvs/

and/or

http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx

Right here on SSC

http://www.sqlservercentral.com/articles/Indexing/64134/

Simply put:

INSERT EXEC Statement cannot be nested