User Defined Data types are so much fun! I have over 1500 of them in my database.:crying:

You...

Something like this?

SELECT T.Table_Type, T.Table_Name, C.Column_Name

FROM INFORMATION_SCHEMA.TABLES T

INNER join INFORMATION_SCHEMA.COLUMNS C ON T.Table_Name = C.Table_Name

I tackled it a bit differently. Example of the running totals[/url] theory applied below. The downside to this method is that you will get rows set to true...

Steve T (11/11/2008)

---

Garadin (11/11/2008)

---

SQL DBA 808 (11/11/2008)

---

Steve T: Yes. That's very close to what I need to do. Thank you.

Garadin: I will read that and see...

Seconded.

SQL DBA 808 (11/11/2008)

---

Steve T: Yes. That's very close to what I need to do. Thank you.

Garadin: I will read that and see if I can...

What happened to varchar 100! 😀

How about something like this:

[font="Courier New"]SELECT T1.ID,

   COALESCE(T2.Name, T3.Name, T4.Name) [Name],

   COALESCE(T2.Language, T3.Language, T4.Language) [Language],

   (SELECT [Description] FROM #Table1 WHERE ID = T1.ID...

SQL DBA 808 (11/11/2008)

---

I think I would do this with the combination of a While and a Cursor.

The Header record can and will appear many times in the course of...

A Case Statement should do the trick:

insert into dbo.Customers (CustomerID, Name, ShortName, ReferenceNo, EffectiveDate, Status, CreateDate)

select A.Account_number, A.Customer_name, A.Known_As, A.Legacy_Account_Number, A.Account_Established_Date, CASE WHEN A.Customer_Status = 'I' THEN...

Guess this wasn't that urgent after all eh? :hehe:

In any case, you were close. (Next time, explain how you tried to modify it and say that your modifications didn't...

Paul,

This is becoming the Oracle post all over again. You supply very little data about your issue, and when we try to guess with your half supplied information, you...

If you are using sequential ID values, you could take the easy way out and use an outer self join on id = id-1. That said, if there are...

This would be that aforementioned "more elegant way". :hehe:

Shouldn't be necessary, and probably isn't efficient. I don't see the need for a cursor here.

Basic concept:

IF EXISTS(Select * From SomeTable Where Condition = True) -- Test the existence of your data

UPDATE SomeTable

...

ELSE

INSERT INTO Sometable...

That works for one row. If you're wanting to...