microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Duplicate Notifications

Subject: Re: Duplicate Notifications
From: "Andy Wilbourn"
Date: Fri, 2 Dec 2005 12:07:43 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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

"Daniel Corrêa" <[email protected]> wrote in message 
news:u8ls%[email protected]
> 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
> 



<Prev in Thread] Current Thread [Next in Thread>
  • Re: Duplicate Notifications, Andy Wilbourn <=