Please don't post the same question again. Please direct all replies to the original thread

Take a look at the top expression and order.

The other thing that will ALWAYS come into play somewhere along the line. Initially it sounds like a generic procedure to handle all the dml for lookup tables can be...

bcampbell-1136357 (6/13/2011)

---

Thanks again for all the replies. I think the idea of a stored proc that includes the insert statement followed by an update statement might work. It seems like...

abhisheksrivastava85 (6/13/2011)

---

Hi All,

I want to update my flag column based on incoming row i.e if suppose...

I am guessing that this can be converted to a set based solution and get rid of that horribly slow cursor RBAR logic. Post some ddl and sample data along...

I agree 1000% with Dave that the database is not the place for this info. You will be kicking yourself when you either change domains or at some point add...

I think you can incorporate the ROW_NUMBER from the other code thing you were working on a couple days ago. But not really sure how your data looks to be...

If this is a one time update I would say that is probably the easiest way for you to handle it. If this is an ongoing process then you will...

lgoolsby 86333 (6/9/2011)

---

Does not work. I am attempting this just on NUMERATOR and all stays NULL. I tried 2 ways:

1:

UPDATE invoices set numerator = CASE NUMERATOR WHEN NULL...

fyi, you can run SELECT * FROM fn_helpcollations() to view all the available collations.

kwoznica (6/9/2011)

---

Sean Lange (6/8/2011)

---

those functions won't help you unless you are in a...

lgoolsby 86333 (6/9/2011)

---

I have a table, INVOICES, of which I need to conditionally update 1 of 3 fields based on which one(s) already have a value.

My Table:

CREATE TABLE...

the problem with using the Exists clause in this case is that there are duplicates in the source. Using the Not exists will eliminate those in the source that are...

You could change the datatype to date. Otherwise you need to another solution for a primary key.