Hi martin

Try this;

DECLARE @t TABLE (Name VARCHAR(40), Id INT, Amount FLOAT, Date DATETIME, JobId INT, SeqNo INT)

INSERT INTO @t

...

Ramesh (5/9/2009)

---

saurabh.dwivedy (5/8/2009)

---

Ramesh (5/4/2009)

---

Most of the time cursors/loops performs poorly than set based methods with only some rare cases when loops performs better than a set-based approach.

In your case, one...

Paul White (5/9/2009)

---

Florian Reischl (5/9/2009)

---

Yep, from my side. I like this syntax but it depends on...

Maybe something to clarify

I'm not doubtful or afraid ;-). There have been some threads where I wrote "sorry" or "apologize" or "my mistake". I noticed whenever I write one of...

Hi Paul

Paul White (5/9/2009)

---

Florian Reischl (5/8/2009)

---

I think I misunderstood your code and the intention. This is a really nice deal if you want to be sure that there is no...

Hi

I did not analyze the complete statement since now. BOL says the query is restricted to 8k.

Maybe stupid question: What if you just pot the code into a procedure on...

Bob Hovious (5/8/2009)

---

Blame Jeff Moden for the proliferation of pork chop projectiles. 😛

I much prefer slapping people around with a large trout.

It's an texture...

Hi Jamie

Completely nothing to apologize from my side.

Greets

Flo

Paul White (5/8/2009)

---

I am?

I am!

Were you about to post something similar? Because I claim prior art!

See http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/t-sql-variables-multiple-value-assignment.aspx

My comment is at the...

Hi

Nothing technical to add from my side. I just have to say thank you all for teaching me about many things I didn't know before!

Taking my head of to all...

Paul White (5/8/2009)

---

Hey Flo,

I hope you know that I would have offered to read it too - but I have had very little time this week to check the threads...

Paul, you're a very spooky man... :crazy:

:laugh:!

Hi Alvin

Thank you also for your offer!...

Kit G (5/8/2009)

---

Flo,

If you want a purely English grammar-type proofread, I'd be more than happy to give your article a review. Since I'm very new to SQL, the technical...

Thank you also very much!!! How can I send it to you?

Greets

Flo