|
|
You're in the
sql server reporting services
group:"marking" the processed elements in data-driven subscription
sql server reporting services:
arrive in a table and i would like to send confirmation messages which contain the content of the order. The RS has an "every 5 minutes" schedule and should send e-mail just about the new orders to the customers. How could I differentiate the new elements from the old ones? - or - How can I "mark" the orders, when the confirmation report was created that they were processed? Thanks in advance, Kolos
[quoted text, click to view] "Kolos Daniel" <d1974kol@mailbox.hu> wrote in message news:OeW5p0GgEHA.556@tk2msftngp13.phx.gbl... > I would like to use e-mail delivery for the following scenario: new orders > arrive in a table and i > would like to send confirmation messages which contain the content of the > order. The RS has an "every > 5 minutes" schedule and should send e-mail just about the new orders to the > customers. > > How could I differentiate the new elements from the old ones? > - or - > How can I "mark" the orders, when the confirmation report was created that > they were processed? > > Thanks in advance, > Kolos > > >
[quoted text, click to view] "Kolos Daniel" <d1974kol@mailbox.hu> wrote in message news:OeW5p0GgEHA.556@tk2msftngp13.phx.gbl... > I would like to use e-mail delivery for the following scenario: new orders > arrive in a table and i > would like to send confirmation messages which contain the content of the > order. The RS has an "every > 5 minutes" schedule and should send e-mail just about the new orders to the > customers. > > How could I differentiate the new elements from the old ones? > - or - > How can I "mark" the orders, when the confirmation report was created that > they were processed? > > Thanks in advance, > Kolos > > >
????
[quoted text, click to view] "Bender" <roman.ilic@avtenta.si> wrote in message news:%23%23BJFeHgEHA.3416@TK2MSFTNGP09.phx.gbl... > > "Kolos Daniel" <d1974kol@mailbox.hu> wrote in message > news:OeW5p0GgEHA.556@tk2msftngp13.phx.gbl... > > I would like to use e-mail delivery for the following scenario: new orders > > arrive in a table and i > > would like to send confirmation messages which contain the content of the > > order. The RS has an "every > > 5 minutes" schedule and should send e-mail just about the new orders to > the > > customers. > > > > How could I differentiate the new elements from the old ones? > > - or - > > How can I "mark" the orders, when the confirmation report was created > that > > they were processed? > > > > Thanks in advance, > > Kolos > > > > > > > > > >
Hi Kolos,
We do something similar. We have an additional field in our subscription Queue which has a Processed Flag field (just a BIT). We update this field whenever the entry has been processed via the data driven subscription's query. If you don't want to add a field to this table, you could create an additional table recording a log of processed Orders. HTH Matt [quoted text, click to view] "Kolos Daniel" <d1974kol@mailbox.hu> wrote in message news:OeW5p0GgEHA.556@tk2msftngp13.phx.gbl... > I would like to use e-mail delivery for the following scenario: new orders > arrive in a table and i > would like to send confirmation messages which contain the content of the > order. The RS has an "every > 5 minutes" schedule and should send e-mail just about the new orders to the > customers. > > How could I differentiate the new elements from the old ones? > - or - > How can I "mark" the orders, when the confirmation report was created that > they were processed? > > Thanks in advance, > Kolos > > >
That's on the right track, but I'd like to also point out that an easy way
to update the "flag" field is to use a stored procedure. Within the sproc you can return the records affected by the email notice and revisit each row to update the flag value. =) Matt [quoted text, click to view] "Matt" <NoSpam:Matthew.Moran@Computercorp.com.au> wrote in message news:ucN2OnDrEHA.868@TK2MSFTNGP10.phx.gbl... > Hi Kolos, > > We do something similar. > > We have an additional field in our subscription Queue which has a > Processed > Flag field (just a BIT). We update this field whenever the entry has been > processed via the data driven subscription's query. If you don't want to > add a field to this table, you could create an additional table recording > a > log of processed Orders. > > HTH > > Matt > > "Kolos Daniel" <d1974kol@mailbox.hu> wrote in message > news:OeW5p0GgEHA.556@tk2msftngp13.phx.gbl... >> I would like to use e-mail delivery for the following scenario: new >> orders >> arrive in a table and i >> would like to send confirmation messages which contain the content of the >> order. The RS has an "every >> 5 minutes" schedule and should send e-mail just about the new orders to > the >> customers. >> >> How could I differentiate the new elements from the old ones? >> - or - >> How can I "mark" the orders, when the confirmation report was created > that >> they were processed? >> >> Thanks in advance, >> Kolos >> >> >> > >
lol, actually, I do use a stored procedure. I was being just more general
and wasn't sure of Kolos's particular scenario. [quoted text, click to view] "Matt Temple" <mtemple@dslextreme.com> wrote in message news:10q9p1l72kj6iaa@corp.supernews.com... > That's on the right track, but I'd like to also point out that an easy way > to update the "flag" field is to use a stored procedure. Within the sproc > you can return the records affected by the email notice and revisit each row > to update the flag value. =) > > Matt > > "Matt" <NoSpam:Matthew.Moran@Computercorp.com.au> wrote in message > news:ucN2OnDrEHA.868@TK2MSFTNGP10.phx.gbl... > > Hi Kolos, > > > > We do something similar. > > > > We have an additional field in our subscription Queue which has a > > Processed > > Flag field (just a BIT). We update this field whenever the entry has been > > processed via the data driven subscription's query. If you don't want to > > add a field to this table, you could create an additional table recording > > a > > log of processed Orders. > > > > HTH > > > > Matt > > > > "Kolos Daniel" <d1974kol@mailbox.hu> wrote in message > > news:OeW5p0GgEHA.556@tk2msftngp13.phx.gbl... > >> I would like to use e-mail delivery for the following scenario: new > >> orders > >> arrive in a table and i > >> would like to send confirmation messages which contain the content of the > >> order. The RS has an "every > >> 5 minutes" schedule and should send e-mail just about the new orders to > > the > >> customers. > >> > >> How could I differentiate the new elements from the old ones? > >> - or - > >> How can I "mark" the orders, when the confirmation report was created > > that > >> they were processed? > >> > >> Thanks in advance, > >> Kolos > >> > >> > >> > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |