Posted by Hugo Kornelis on 04/18/07 19:18

On 18 Apr 2007 11:57:53 -0700, pbd22 wrote:

(snip)
>MY final question is - why don't I get any data returned with the
>query? Shouldn't I be seeing results with the column headers? Or, is
>this just to show that the query works in debug mode? Sorry - still
>trying to learn my way around stored procedures.

Hi Peter,

You're probably going to hate me for this, but my best guess is that
your tables simply don't contain any data that matches the criteria in
the trigger. I already hinted at this in my previous reply (though I
left a back door open for the possibilty that one of the queries
contained a copy/paste error).

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

• Next in forum: Re: How To Return A "Range Of Rows"??
• Prev in forum: Disabling or Getting Rid of Foreign Keys So I Can Drop My Table
• Thread view: Re: How To Return A "Range Of Rows"??

[Reply to this message]