How many Subscriptions do you have? You have an inner join, so the
subscriber has 3 subscriptions, that may be where you are getting the
extras. You have no WHERE clause.
"Daniel Corrêa" <[email protected]> wrote in message
> I'm running e fairly simple NS application and for some reason some events
> generate more than one notification. After choosing a specific event, I
> used the Query Analyser and performed 3 querys:
> 1- select event from event table => returned only 1 event as expected
> 2- rule query (I changed the CurrentEvents table to the Events table,
> because the event had already been processed) => returned only 1 event as
> 3- select SentTime from NotificationsTable => returned 3 rows!!!
> Can anybody help me? Below is the event rule
> FROM dbo.PurchaseConfirmationsSubscription inner join
> dbo.NSCurrentPurchaseConfirmationsEvents on
> dbo.PurchaseConfirmationsSubscription.SubscriberID =