At the granular level I would store all figures in the currency of origin and I'll identify the currency.

I would also have a DIM_CURRENCY_CONVERSION table storing daily conversion rates for...

What kind of shop are you working...

useruser888 (6/27/2010)

---

I am an Oracle Apps DBA and have been looking for a Apps DBA job for over a year. 🙁 I really don't know when/will I find one... A...

This is very bad mojo.

DBA owns the structure but not the data, user community owns...

1- Get some background in relational theory, C. J. Date may be a good start.

2- At the same time build a home lab a.k.a. install SQL Server in a home...

Ray K (6/23/2010)

---

Just curious: why single table? When I first read the question, my initial...

Did you get it in writting?

Does the organization uses a ticketing system? in the affirmative case ask for a fully...

Assuming script is creating #Open temp table, how about...

insert into #Open

select order_hdr_id,...

You are correct. Thank you Wayne.

I would start by trying...

select *

from TABLE_PRIVILEGES

where GRANTOR = 'offending_account'

WayneS (6/23/2010)

---

IMO, you'd be better off with a regular column that is updated by an UPDATE,INSERT trigger. A default value wouldn't be necessary, since the trigger would do always maintain...

In this particular case I'll probably go with a denormalized solution - single table.

OR...

1- Rename your master table as TablenameBase

2- Create a view Tablename (same name as the original table) so all current queries could continue doing those ugly "select *")

3- Add new...

As far as I know the burden is on the Operating System and not on the database engine. When SQL Server needs more space and datafile is set to...

Since a persisted computed column is actually stored in the target table as opposed to a plain computed column that is virtual - why not use a standard column and...