Jeff Moden (6/27/2008)

---

Sorry, Stephanie......

Hmmm... I suppose the second table is the best way to do it, if I'm allowed to do so. At least I now have ammunition.

An interesting point about the editorial is that these inexperienced DBAs were attending a professional conference. That means they were likely being paid, both in time and travel, by their...

Jeff, I like your schema better. Thanks for clarifying how phone numbers and addresses are ideally stored.

Based on the schema fragments you've posted, I'm seeing the following situations:

- Different phone ids may represent the same phone number

- Customers may share phone numbers

- A customer may have...

Why?

You should ask...

As for why to get certified, I find it intersting that the discussion tends to concern whether having a certification can get you a job. The consensus seems to be...

Replace

WHERE T.N < DATALENGTH(M.SalesRepList)

with

WHERE T.N <= DATALENGTH(M.SalesRepList)

There was an error in the query I originally wrote. I forgot to account for the tildes added at front and end. Sorry about...

Excellent reference! I've been looking to solve a similar problem, and this is it!

muten79 (6/19/2008)

---

Hello again!

I've been reading this article:

http://www.sqlteam.com/article/implementing-table-inheritance-in-sql-server

It simulates OOP's hierarchy like Michael suggested.

It could work.

Thanks...

Steve, you got the essence of the Zone exactly! At least, what it is to me.

I also have a time problem with it. My best productivity doesn't start until about...

I bet the 3% who got it "right" just clicked all the answers without looking anything up because the answer "all of the above" is a common pattern for a...

I have copied queries directly from Jeff Moden's article at:

http://www.sqlservercentral.com/articles/TSQL/62867

and modified them to suit this purpose.

Using the test data you posted (not repeated here)...

First, create a Tally table,...

It works! I've posted the completed procedure below (goes with the schema from the first post).

CREATE PROCEDURE RecordNextScheduledEntry (@entryId INT)

AS

DECLARE @newEntryId INT

-- create primary entry

INSERT INTO Entry (accountId, transactionDate, sequenceNumber,...

Wait, I think I got it... wrote something that compiles, now I have to test it...

You've simplified the schema... I see that... I have no idea what those tables are! I'm having trouble figuring out how it matches my problem. How do T1, T2 and...