It also makes me wonder what company he works for as well. Must not have much in the way of data or they'd probably be complaining about system performance;...

Alvin Ramard (3/26/2009)

---

Derek Dongray (3/26/2009)

---

He still hasn't got it ...

http://www.sqlservercentral.com/Forums/FindPost684294.aspx

Have any of you seen the challace and viewed another way it looks like a face?

Or a cube drawn on paper,...

Changing methods a bit here, so here is some test code for you to play around with:

--DeptID X Y z

--A1 1 10 12 5

--A2 1 13 17 7

--A2 2...

Well the blizzard hasn't hit here yet in...

foxjazz (3/26/2009)

---

Bob, just because I know how to do updates (in mass) or inserts in mass to tables. Doesn't mean I favor the language of use. Don't get me wrong,...

No. SQL Server 2005 will "act like" SQL Server 2000.

Access to SQL Server 2005 features and capabilities.

Good response. I was just trying to make sure that everyone had a good idea as to what is "duplicate" data and that which isn't. In a strictly...

jparra (3/25/2009)

---

I'll jump on the bandwagon here. When designing a database, I first normalize and see where that gets us. When requirements or performance demand denormalization, there isn't...

Scott T (1/16/2009)

---

--With simple calculation we don't care about data-type (float or decimal)

--====================================

--When we start calculation like the following one, we should use decimal

-- Let's see example

--====================================

DECLARE @APR ??????? (18,3)

--------------------------------------

SET...

Actually, we used the Force!

Intuitive guess work. Things just didn't seem to be working correctly.

It does come down to business requirements. If you need to be able to regenerate any reports, then images of invoices won't be of benefit.

This is a double post. Let's try and keep everything in one thread, here. Especially since this is a SQL Server 2000 question, it really doesn't belong in...

Without more information there really isn't much more I can do. You may not have the permissions necessary to provide the info needed since you also could not get...