Have you checked to see if there are any tasks running under the Windows Task Manager?

And I can't stress enough, be sure to read the discussion as well. There is much to learned from...

In many cases we don't actually need the entire table structure to help splve a problem. Many times, only a subset of the columns are relevent to a problem...

RexHelios (4/30/2013)

---

Lynn Pettis,

Thanks, but the "AdjustedTotal" should be a sum of previous "AdjustedTotal" and current total. Your solution is showing sum of Previous "Total" and current "Total".

I will try to...

By the way, if you are converting MoYear to a datetime value, you really should store it in a datetime column, not back as a character string.

Something like this?

DECLARE @BaseData TABLE (ID INT, Total INT)

INSERT @BaseData (ID, Total)

VALUES

(1, 215),

(2, 86),

(3, 43),

(4, 101),

(5, 92),

(6, 64),

(7, 117),

(8, 59),

(9,...

Are we talking...

If you want a character version (or at least close) of the value shown as datetime, look at the last convert in the following:

declare @TestDate varchar(10) = '01/2013';

select

...

If you run the following, you will see that the datetime value is implicitly converted to the character string you showed:

declare @TestDate varchar(10) = '01/2013';

select

@TestDate,

...

latingntlman (4/30/2013)

---

I just tried your suggestion as:

update table

set MoYear = convert(datetime, stuff(MoYear,3,0,'/01'), 101)

When I select the table the values are displaying as Dec 1...

Have a read here regarding the options, particularly for @body_format:

http://msdn.microsoft.com/en-us/library/ms190307.aspx

You really are doing too much. You can create a computed column using the convert part shown below, just replace the variable @TestDate with your column name :

declare @TestDate...

bgdjwoods (4/30/2013)

---

Good question but neither answer was correct. Granted you do NOT get an error but the truncate does not technically run either. If you go back and...

DBA12345 (4/29/2013)

---

I need add multiple rows and take sum of that row in to single column

Server|||| Cost

abcd ||||| 75

abcd ||||| 25

dtgr ||||| 65

dtgr ||||| 35

table should lok like below.

Server||||| Cost

abcd...

Oh, and ANY changes (code, schema, database, etc.) should be tested first in a development and QA environment prior to going into production.