Are you just trying to round the Value column?

If so, have you looked at the T-SQL "Round" function? http://msdn.microsoft.com/en-us/library/ms175003.aspx

dndaughtery (10/18/2010)

---

I need to get data from servers running SQL Server worgroup. Is it possible to run a package on a server which is running SQL Server Enteprise version and...

You'll have to shrink the databases to get that file space back. Watch out for both file and data fragmentation when you do that.

You can have more than one step in an SQL Agent job. Move the second job into the first one, as Step 2.

Does the disk space taken up by...

Take a look at the Create Database syntax in Books Online (or on MSDN). It has an option for re-creating a log file when you create a database from...

Since selecting from multiple tables is just about the most basic function there is in a database, I think what you should probably do is take a class or read...

If it's a large amount of data from Server B, then you might want to insert into a table variable, then from that insert into a temp table that you...

I'm not sure what you mean by wanting to have the department name in the header. Do you mean as a row in the file?

Do you have the scripts that were used to roll in the schema updates? If so, are they reversible?

When I roll out any major database change, I make sure...

I missed that you need to partition the number.

Is there a reason that the incrementing number needs to be stored in the database? Can you store a datetime or...

No clue. The company I ran into it at went out of business in 2007. No clue what happens with 2008.

You need to separate the two query conditions.

Do you have a "customers" table of some sort? I'm assuming the customer_no column in the orders table refers to something like...

I was more thinking...

Brandie Tarvin (10/15/2010)

---

Wow. You...

Stefan Krzywicki (10/15/2010)

---

I can post for quite...