I'm still struggling with this issue. But I may have found out why I can't get SSRS as an option when I install SQL Server 2005 Express with Advanced Options....

Here is another good definition of using this style of groups

Hmm, well it seems to be working now. I simply changed the way I called the select statement. I read here that SQL Anywhere doesnt support the catalog name, i.e.

SELECT...

OK, nm I solved it. Just used

SELECT @duplicates = (SELECT * FROM MY_CTE)

to set the value of @duplicates

--First check that table is not already made and get rid of...

Thanks, that looks very informative, I'll give it a look over. Also never thought of using IDENTITy() for...

Thanks, that is exactly what I was trying to do only I wanted to somehow do it in 1 table pass not 2. I thought there was a way to...

The code includes 1 while statement...

lmu92 (6/14/2010)

---

I'd also recommend you change the structure of your procedure names:

it's considered as bad practice to start your stored procedures with sp_ since SQL server will try to find...

The whole process is a lot more complicated then I have explained. 3 mins seems quite reasonable for what it actually does in the end. I do have a question...