GilaMonster (1/24/2009)

---

I guess that's because Gail is used both as...

Nope, it's Goldie. 🙂 I think I'm going to change my user name.

And, thanks... that's one of the posts I was looking...

Don't know if this helps, Jeff, but I found a post from a few months back that was asking to solve this problem.

The OP did not say why he needed...

That works great. Thanks, Jacob.

I also realized that another option would be to use the built-in stored procedure sp_sproc_columns.

GSquared (1/14/2009)

---

I'd have one table with the item ID and it's default description, and another table with the PK on item ID and customer ID, and the customer-specific description. ...

B (1/14/2009)

---

Hi,

I see you've solved this now but here is the answer I came up with....

declare @customerID int

set @customerID = 2

SELECT * FROM @Categories where CustomerID =@customerID

union all

SELECT *...

GSquared (1/14/2009)

---

I would seriously rethink this solution. Customer-generated descriptions should, really, be in a separate sub-table.

Otherwise, you're likely to end up with two or more descriptions for the same...

Solved it! Thanks to some help from a co-worker.

DECLARE @Results TABLE

(

CategoryID INT

,Description VARCHAR(20)

)

INSERT INTO @Results

SELECT CategoryID, Description

FROM @Categories

WHERE CustomerID IS NULL

UPDATE R

SET R.Description = C.Description

FROM @Results R

JOIN @Categories C ON...

Yes, it would be ideal to do the conversion in the front end application. But sometimes you do need to do the conversion in the database.

I also forgot to mention that it is easier & faster to do this in code instead of SQL.

I would recommend doing that if at all possible.

I agree that times should be stored as UTC in the database.

However, usually the user wants to see dates/times in their own time zone.

The only way to do this is to store the daylight savings information per region in the database.

Then you can write functions to calculate time change.

The Code Project has an...

I agree! WAY too nice.

Jeff, in...

:hehe: I was waiting for you to respond to this one. :hehe:

Jeff says he thinks his way is going to end up faster than yours.

It...