Rod Carter (5/27/2009)

---

Lynn,

I will do both and thank you for your feedback and help to this point. I truly do appreciate it and am not trying to be difficult....

Damus (5/27/2009)

---

GSquared (5/26/2009)

---

Damus (5/26/2009)

---

I agree its a management Issue.

some other things i would like to see:

- real foreach loops through table rows.

- object oriented friendly organization of stored procs and...

arun.sas (5/26/2009)

---

hi Lynn,

CAST(ABC AS DECIMAL(4,2)) AS 'VAT'is better,

but the orignal datatype is Decimal(38,20),

if the value like 99999.00000000, then again the Arithmetic...

I find the critism of a relative newbie who has taken the time to write an article showing people something they have learned a little much. It may have...

OMG, you really have to be kidding here...

Because DECIMAL(2,2) represents a decimal number with 2 positions, both to the right of the decimal.

Please take some time...

It would help if you would provide the DDL for the tables and views (including base tables for the views) involved in the query. Some sample data for the...

Try this:

CAST(IL.[VAT %] AS DECIMAL(4,2)) AS 'VAT'

First, if you haven't already spent your money on VMWare, may I suggest looking at MS Hyper-V? It is free with Windows Server 2008 and will reduce your costs....

Rod Carter (5/26/2009)

---

Does the index have to be unique? The dataset that I am working with holds time data for a whole week for all employees across the company....

Only if the OP provides the full requirements.

Rod Carter (5/26/2009)

---

Does the index have to be unique? The dataset that I am working with holds time data for a whole week for all employees across the company....

Nathan Davis (5/26/2009)

---

GilaMonster (5/26/2009)

---

What you could try is to put the tables that you don't care about into a different database and set it to simple recovery. Doesn't stop logging,...

In theory, yes. By running regularly scheduled transaction log backups, you will keep the size...

The simplest way is to setup a maintenace plan to accomplish this for you. Look it up in Books Online, it will get you started.