Thank's

thanks , how i can create job to do it ,periodicaly ?

would you please be more specific , or let me know with example ?

Thanks

source table is like this one :

Customer Code|cslAccumulationInvoiceItmId| cslAccumulationInvoiceRef |cslDeliveryNoteRef| cslProductRef |Amount |Rate CurrencyRate| price before PriceInBaseCurrency| Deliver No| Date-Reci

400560 46663 46644 28532 21 21.54 504807 1 10873542.78 10873542.78 17169 1/10/2012 00:00

400560 46659 46644 28488 21 22.86 504807 1 11539888.02 11539888.02 17146 1/10/2012 00:00

400560 36414 36413 19204 47 17.66 519230 1 9169601.8 9169601.8 10956 11/30/2011 00:00

400560 35305 35304 18176 47 24.12 519230 1 12523827.6 12523827.6 10361 11/27/2011 00:00

400560 96490 96488 84639 47 22.26 568000 1 12643680 12643680 27082 8/8/2012 00:00

400560 35312 35304 18465 47 22.7 519230 1 11786521 11786521 10549 11/28/2011 00:00

______________________________________________

on the destination i have same table , with only add status (bit) column.

i want...

Hello , as you mentioned in the select case i can't set the variable with the value of cursor column,

i used this , it work's but need i put more...

In the select case i have 8 condition,and i make decision on @cslPricingFactorRef value,for example if @cslPricingFactorRef=90000119 then @90000119=@Avamel

if @cslPricingFactorRef=90000120 then @90000120=@Avamel

all of my variable fill in this loop, in...

please attention , these are variable not aggregation function, i chenge it name to ali

SET NOCOUNT ON;

Declare @90000119 varchar(8),@ali varchar(50)

Declare @cslPricingFactorRef varchar(3),@Avamel varchar(50)

SET @90000119 = 0;@ali=0

Declare spid_List2 Cursor FORWARD_ONLY For...

it is not agggregation, the name of my variable is (90000120sum)

i try :

While @@Fetch_Status = 0

Begin

select

CASE

WHEN (@ProductCode = 90000119) and (@cslPricingFactorRef = 95)...

because i need to analysis each row of cursor , and make decision by value of column

i write :

SELECT @90000119Sum = @Avamel

"@90000119Sum" this is variable i declare it,@Avamel is belong to cursor as shown in top

in cursor but give me this error :

Incorrect...

i know it , but i need it value in cursor

what is the best method to deploy this issue ? Trigger ? Notification oR Broker ?

is it possible some one Describe Service Broker shortly and put some example here ?

what is service broker in sql2008 ? can i do that with it ?