Posted by pbd22 on 04/18/07 19:41

Ah, yes. You were right Hugo. It was a problem with my select
statement.

Thanks again for your help, MUCH appreciated!

Cheers.
Peter

Hugo Kornelis wote:
> 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

[Back to original message]