Thanks.. that is EXACTLY what I'm looking. Now my only issue is putting the info into a table. Every time I try an insert I get an error message that says
Server: Msg 8164, Level 16, State 1, Line 1
An INSERT EXEC statement cannot be nested.
Server: Msg 8164, Level 16, State 1, Line 1
I've tried using adding it to the SP's or as a seperate statement and receive the same error.. I'm getting VERY frustrated..
Any more help would be appreciated.
Thanks
Susan