lmu92 (1/20/2010)

---

Gianluca Sartori (1/20/2010)

---

...

Well, I can say that I had a...

David Burrows (1/20/2010)

---

CirquedeSQLeil (1/19/2010)

---

Similar situation for me, only it has been...

What are writing about, Paul?

I started writing my first article 9 months ago and it isn't finished yet.:crying:

Work, work and work again.

And... whoops! 30 seconds stolen from work!

Back to work again.

It's an interesting topic, Grant.

There's a hot discussion going on in Italy this week, because of a newspaper's title. They used the word "negro" to say "coloured", when most people...

Thanks for the notice, I was planning to respond later today, you saved me some extra work.

Can you post your solution (or part of it) here so that others having...

Don't worry, you're doing great.

Is this the code that could work on the sample data?

DECLARE @Input TABLE (

Field1 varchar(10),

Field2 varchar(10),

Field3 varchar(10),

Field4 decimal(18,5),

Field5 varchar(10),

Field6 decimal(18,5),

Field7 varchar(10),

Field8 int,

Field9 varchar(10),

Field10varchar(10),

Field11 varchar(10)

)

INSERT INTO @Input...

I don't understand your problem. Are you getting any errors? Are you getting wrong results? What should "correct" results look like?

The UPDATE statement works internally row by row, working on the values definded beforethe update takes place.

It works exactly how you already have stated. I don't understand what you're missing.

Do you mean that you would expect it to set both columns to the original col1 value?

CirquedeSQLeil (1/10/2010)

---

It's probably slumber time.

Or he is waiting just to talk to his developers in India. Which developers will be asking the same questions, if they're worth their salt....

You forgot to note that INSERT/EXEC cannot be nested. If the procedure does internally the same trick, you won't be able to insert the results into a table.

One possible solution...

Congratulations, Gus!

I hope it isn't too far from your house. It takes me from 1 to 1,5 hours every day to drive to my office and it's a pain.

I know...

lobbymuncher (12/29/2009)

---

Gianluca Sartori (11/17/2009)

---

No there isn't. The same applies to Crystal XI, just to be clear. The reporting engine has to know which columns will be returned by the procedure,...

Bru Medishetty (12/28/2009)

---

GilaMonster (12/28/2009)

---

What is this 'console' you speak of? Just about all of my games...