OK, How can I make sure that my process return erro level value of 0.

Yeah my error clearly shows that my process is not returning 0 instead its returning 1. I didnt shedule my pkg yet, trying to execute individual task from my DTS...

Ok I got it worked but how can i delete last char in my FirstName column, coz I have ',' there which i dont need it.

I need to update the existing table

To say directly what i need...

I have to get the modified date n time automatically of a single record when it is changed. How can I do tht?

Hey...its Ok, i understand that.

As I dont want to reveal my original names so used in tht way. Any help for that error?

when I used the above given query I am getting the folling error, Any help?

Server: Msg 107, Level 16, State 3, Line 1

The column prefix TableB does not match with...

Table A

Col1    Col2        Col3     Qtr

1      2004-05     BOG     0

2      2004-05     BANT    0

3      2003-04     BOG     0

Table B

Col1    Col2        Col3     Qtr

1      2004-05     BOG     367.5

2      2004-05     BANT    12.3

3      2003-04     BOG     55

4      2004-05     BOG      7120 

Result:...

Table A   X(PK)  Y(PK)  Z(PK)   Qtr(default=0)

Table B    M(PK)   Qtr      -         -

No of rows in both tables are diferent. I want to move data in Qtr column of B to Qtr column of A.

No,

whatI mean is when I select a record in my application, I want to make it as true in my bit filed....

OK, thanks for ur replies, and have a gud week end

so..it means we cant do it at database?

My output shud be inthis way

ProductID Quantity  Totals

1                 5

1                10        15

2                10

2                25        35

3               15

3               30        45

                            95

Any help?

I need the result set of the above query in the column totals.

I am using the follwing query to get my result order by productid, but I want the result set in a seperate column, how can i do that, can any...