Ah, sarcasm, that I get.

You know, if I had an answer I'd have given it to you. Can I think of a reason I'd use it, no. Does...

Leave awhile I think I should. Cynical I am after reading several posts today.

PM me you may if help you need.

You know, GSquared, that may be what he was looking for, but I didn't want to point him that way if that wasn't what he was looking for. I...

If you read BOL it says it can be used to detect changes of data in a column of data. You noticed that the value changed when a row...

The desert just isn't deep enough...

serkan_sendur (1/29/2009)

---

the question is not ambigious in fact. let say i have an array of 100 elements, i want to get two inputs from the user, one the start index,...

Really ambiguous question, so hard to give a good answer. May I suggest that read the first article I have linked below in my signature block. Follow the...

I think some of us are missing out on the Million Member Party!!!

How about a simple because. I ran your code as is and both checksum_agg returned the same value, 1. I then took the last value out of the...

Try this:

declare @result int

exec dbo.TestProc 5,@result OUTPUT

print @result

In SQL Server 2000, turn each CTE into a derived table in the from clause.

If you need more help than that let me know. I have a meeting to...

David Reed (1/29/2009)

---

Lynn Pettis (1/28/2009)

---

David Reed (1/28/2009)

---

The way that publik skrewel (in the US anyway) teaches "suppository writing" leads many, many people astray. Proper paraphrasing, citation and fair use are...

Okay, it's up. that is just totally weird that I couldn't post the code in the reply itself.

Anyone else ever experience that problem.

Okay, here is the code I put together. Just to be sure, I am using CTE's so this will only work in SQL Server 2005/2008.

I am going to upload...

Okay, here is the code I put together. Just to be sure, I am using CTE's so this will only work in SQL Server 2005/2008.

An explanation is due first....