Again, a mighty broad topic to try an answer in a forum. Perhaps you should be more precise i\whan asking for assistance.

Mighty broad topic to be covered in a forum. Perhaps you should be more precise in your request for assistance.

All we wanted is for you to post the code you have written to try and solve your problem.

Here is my solution using the dbo.DelimitedSplit inline TVF. Use the...

Okay, here is some code for you:

create table dbo.Opportunity

(

OppID int,

abc varchar(20)

)

create table dbo.Book

(

OppID int,

booked int,

BYear int

)

create table dbo.Sales

(

OppID int,

shipped int,

SYear int

)

--inserting into opportunity table

insert into Opportunity values (1,'xxx')

insert into Opportunity...

Just an FYI, your code will not work on my systems without modification. Our servers are configured to use case sensitive collation. You really need to be sure...

Think, I do, that scared him...

CirquedeSQLeil (5/7/2010)

---

GilaMonster (5/7/2010)

---

Here's the Oracle-SQL conversion problem. Maybe stay out for now, we're getting nowhere fast and I don't think adding more people nagging for table defs is going to...

Okay, Gail, I'll stay out as far as posting but I still want to see what it is about.

Why are you adding a column to a table inside a stored procedure?

Some times you have to wonder[/b] how some people actually get jobs working with computers.

Do all the values in the column have at least four \'s?

I see a trip to the TitD in the near future.

Really? Let's take a step back. This is your data, you need to show us how to perform the necessary calculations. I look at the data, and...

Go here.

It will tell you what you need to know.

Okay, similar yet different from your other post, so what have you tried to solve this problem?