Cast them to numeric(9,2) before casting to varchar. It will cause the value to be rounded and then displayed with 2 decimals.

eg: replace CAST(DeliveredQty AS VARCHAR(10)) with CAST(CAST(DeliveredQty AS NUMERIC(9,2))...

krypto69 (1/18/2009)

---

As for the code block. I'm a little confused..I looked at the example again and I thought I matched it, but I'm guessing you want 'GO's in between the...

For what it's worth, if I had that error on a production database, I'd pick the second option if it was feasible (due to time constraints). Or you can just...

The default trace won't avoid such happenings. It'll only tell you who did it. The default trace (as it's...

Unfortunately, with that error you only have two options.

1) Edit the system tables directly to remove the orphaned records (very tricky, as the system tables are very complex on SQL...

Almost. What do you want the results to look like?

p.s. Can you put that lot into a code block so it doesn't cause scrolling?

No!

That's a single update statement, no need to do it row by...

ravikanth (1/18/2009)

---

DBCC TRACEON(1204,1222)

1204 - This trace flag reports deadlock information formatted by each node involved in the deadlock

1222 - This trace flag formats deadlock information, first by processes and then...

Enable traceflag 1222. You can use use a DBCC statement (DBCC TRACEON(1222,-1)), or add -t1222 to the startup parameters of the SQL instance (needs a restart to take effect)

Once that...

Short answer,...

I've got one that's getting tech-reviewed...

You can write one yourself, based off sys.tables, sys.column and sys.types. It's not difficult, thought it is a it tedious to write (I don't have one, but I did similar...

You need to give more information here. A lot more.

What's your manager talking about migrating?

SQL CLR is the CLR (the common language runtime) within SQL Server (2005+). It allows...

Of course, as long as you're in full or bulk logged recovery and nothing has truncated the log since the diff.

No.

Insert the data into a temp table that has an identity and then select with the identity column.

Please post SQL 2000-related questions in the SQL 2000 forums.