Try this:

ROUND(Col1 * Col2, 8)

Krasavita (1/19/2010)

---

I can't re name table, I need to leave 200 million records and that table and I need to delete 190 millions records.

I created store procedure:

BEGIN

SET ROWCOUNT 1000000;

...

itsmeman (1/18/2010)

---

No cursors were used. 150,000+ records took an hour to change, yup, bad, bad, bad. Those 150,000 could have had many more charges associated with the records. Both tables...

Ninja's_RGR'us (1/18/2010)

---

With that many rows you may also consider 2 more things :

How many rows will be left after the delete? Sometimes it's just faster to figure out...

My guess, they ran the update that took 11...

I have to agree with Gail again. If you can provide us with more specifics, table DDL (CREATE TABLE statement(s)), sample data (series of INSERT INTO statement(s)) for then...

Should have seen this to begin with, here is what you need to do:

Change:

INSERT INTO Files (Dir, FilePath)

(

SELECT('O', filePath) FROM #Temp

)

To:

INSERT INTO Files(Dir, FilePath)

SELECT 'O', filePath FROM #Temp;

What is the exact error message you are getting.

ragie (1/16/2010)

---

sorry bout that Lynn.

i'm writing a sp where the goal is to get two output parameters: the fileid, and filepath. as you saw from the first post, i...

ragie (1/16/2010)

---

Thanx Lynn. i don't know why i didn't see that!

quick question, is it possible to do an INSERT SELECT like this:

INSERT INTO Files (Dir, filePath)

SELECT('O', filePath) FROM #Temp

it's...

Jeffrey Williams-493691 (1/15/2010)

---

And, just to make things a...

backup data base MyDB to disk = N'MyDB.bak'; -- remove space between data and base, only way to get this to post from work

restore database MyDBClone

from disk = N'MyDB.bak'

with...

Use RESTORE HEADERONLY, that will tell you what type of backup the native backup file contains.

Not really, your only choice is to run DBCC CHECKDB with repair_allow_data_loss option. The optimum solution would have been to restore from a previous database backup prior to the...

So you are saying that you have no previous backups made before getting this CHECKDB error, correct?