Lynn Pettis (3/23/2010)

Actually there are still a good number of current Dungeons and Dragons players out here. Why not call it a "Guild"? Other professions have Guilds, why...

You can create a FK that references a column that has a unique constraint that is not the primary key. If the Code column in TaxTable is unique and...

TravisDBA (3/23/2010)

---

Michael Valentine Jones (3/23/2010)

---

I wouldn’t go as far as to say that certifications are worthless, but I personally give them no weight at all when I look at a...

I wouldn’t go as far as to say that certifications are worthless, but I personally give them no weight at all when I look at a resume.

I just look at...

What is "marel"?

Also, there is no way I am going to open an XLS file posted on the web.

If you want help, post SQL create table statments and statements to...

Yes

If it is really a primary key, then you would not use the DROP INDEX statement.

You would use ALTER TABLE tablename DROP CONSTRAINT constraint_name

Jeff Moden (3/22/2010)

---

Lookup CREATE FUNCTION in Books Online... Example "A" is a nice, short function that determines ISO week. It could probably be optimized to be an INLINE function...

Hide the update in an execute statement:

if not exists (select * from syscolumns

where id=object_id('Calendar') and name='RDATE')

BEGIN

ALTER TABLE Calendar add RDATE DATETIME

exec ('UPDATE calendar set RDATE = DATE + 36163')

END

ELSE

BEGIN

PRINT 'ALREADY...

CirquedeSQLeil (3/17/2010)

---

I would...

This script will give you a breakdown of the space usage of all tables in a database.

Script to analyze table space usage

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

CASE certainly is more work, especially when you are looking at more than 4 columns.

However, it may be faster if performance...

Hunterwood (3/11/2010)

---

Another alternative:

DECLARE @Sample

TABLE (

account INTEGER NOT NULL,

...

DRI should be the default, without some overwhelming reason not to use it,

And by “overwhelming reason”, I don’t mean that the developers were too lazy to bother, didn't know...

The scripts on the link below demos two methods for doing this.

MIN/MAX Across Multiple Columns

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86906