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.
-Andy
[quoted text, click to view] "Daniel Corrêa" <daniel.correa@e-component.com> wrote in message
news:u8ls%23nf5FHA.3416@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> 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
> expected
> 3- select SentTime from NotificationsTable => returned 3 rows!!!
>
> Can anybody help me? Below is the event rule
>
> SELECT
>
> dbo.PurchaseConfirmationsNotificationNotify(dbo.PurchaseConfirmationsSubscription.SubscriberId,
> dbo.PurchaseConfirmationsSubscription.DeviceName,
> dbo.PurchaseConfirmationsSubscription.SubscriberLocale,
> NSCurrentPurchaseConfirmationsEvents.RECLOC,
> NSCurrentPurchaseConfirmationsEvents.ItineraryXMLId,
> NSCurrentPurchaseConfirmationsEvents.NotificationSubject,
> NSCurrentPurchaseConfirmationsEvents.MarketingContent,
> NSCurrentPurchaseConfirmationsEvents.BannerUrl1,
> NSCurrentPurchaseConfirmationsEvents.LinkUrl1,
> NSCurrentPurchaseConfirmationsEvents.BannerUrl2,
> NSCurrentPurchaseConfirmationsEvents.LinkUrl2)
>
> FROM dbo.PurchaseConfirmationsSubscription inner join
> dbo.NSCurrentPurchaseConfirmationsEvents on
> dbo.PurchaseConfirmationsSubscription.SubscriberID =
> dbo.NSCurrentPurchaseConfirmationsEvents.SubscriberID
>
