Do you want to test DateDesc for within the last 30 days?

If so, then maybe this (added that check to the WHERE clause):

select

activityname,

dd.datedesc,

dateadd(hour, - 5, DD.DateDesc) AS date_completed,

getdate()-1 as...

Have to admit, I just upgrated in place from SQL 2005 to 2008. It's fairly straightforward. (Nothing at all like the huge changes going from SQL 2000 to...

Very nice, but technically wouldn't remainder 1s be table A, remainder 2s be table B and remainder 0s be table C?

Sean Lange (2/14/2013)

---

ScottPletcher (2/14/2013)

---

Nope, you're not quite there yet, one other changed to make.

You should always specify the owner (schema name) on objects in a trigger. There are very...

That's a significant change!

In order, here's a quick list of the most important things to do first:

1) Make sure the DBA role will fit you. As a developer, you...

Nope, you're not quite there yet, one other changed to make.

You should always specify the owner (schema name) on objects in a trigger. There are very few always/never rules...

Jeff Moden (2/13/2013)

---

ScottPletcher (2/13/2013)

---

I wouldn't use a separate schema, first of all because of the security considerations: you'll break the ownership chain, thus forcing a lot more security checks on...

JKSQL (2/13/2013)

---

I just can't seem to find an article in how User Defined table types are stored. Do these go into the TempDb? Also is there an advantage...

Just imagine if SQL itself tried to use all these prefixes? That would be a royal pain!

In general they use the prefix to logically group things, such as sys.dm_db_*,...

RonKyle (2/13/2013)

---

Why would you never do this? I've seen dimension tables...

Grant Fritchey (2/13/2013)

---

Ever is probably an over-reaction, but in general these types of naming conventions just don't make sense. How is tblInvoices easier to understand than Invoices? How is it...

nsmith 8448 (2/13/2013)

---

Thanks everyone. Great input. No school project, just thrown into the fire without much experience in creating databases. Also, not using "tbl" on the tables, just noted it...

Employee_Contact: Clus_Key = ( Emp_Id, Location, Type[, Sequence] )

....Emp_Id FK

....Location FK --<<-- alpha or numeric code for contact location: Home|Work|etc..

....Type FK --<<-- alpha or numeric code for contact type: Phone|Email|etc..

....Sequence...

Hmm, if you're going to go live with this, you need to do some further normalization and use less-prefixed names, as below.

Employee (abbreviated "Emp" below): Clus_Key = ( Emp_Id )

....Emp_Id...

I understand English may not be your first language, so I won't criticize any of those aspects of your post. I've tried learning a foreign language and know how...