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|RateCurrencyRate|price beforePriceInBaseCurrency|Deliver No|Date-Reci

4005604666346644285322121.54504807110873542.7810873542.78171691/10/2012 00:00

4005604665946644284882122.86504807111539888.0211539888.02171461/10/2012 00:00

4005603641436413192044717.6651923019169601.89169601.81095611/30/2011 00:00

4005603530535304181764724.12519230112523827.612523827.61036111/27/2011 00:00

4005609649096488846394722.2656800011264368012643680270828/8/2012 00:00

4005603531235304184654722.7519230111786521117865211054911/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 ?