If I have the time, I'll try. I have few issues right now here at work that I have to figure out.

Doesn't mean you need better english, just better information. The DDL for the tables, sample data for the tables, expected results based on the sample data. All this...

GilaMonster (11/25/2008)

---

I didn't ask for the entire proc. I said, if you want us to do all of the work for you, give us table definitions (as create table statements),...

Check your share permissions.

YSLGuru (11/25/2008)

---

To perform the following command which is using pseduo names because an NDA disallows my...

First, you don't need a cursor. Second, your description of the problem is a little difficult to follow. What would help you is to take the time to...

So, before we start doing anything, how about you show us what you have already done to try and achieve your requirements?

Don't double post. It splits the efforts and responses you may receive.

Please use the following forum post for responses: http://www.sqlservercentral.com/Forums/Topic608392-357-1.aspx

This is an awesome site with many great people willing to share thier knowledge. I know I have picked up many new ideas here, and learned some tricks to...

Just used some of the concepts behind running totals to help eliminate RBAR in another post. The concept used here isn't just useable for running totals. It can...

Proper etiquette would have you posting your final code for others to see how the problem was solved.

Also, it would be interesting to know if there was a performance improvement...

Since you are using SQL Server 2005 (this is posted on a SQL Server 2005 forum), instead of triggers executing stored procedures with the business logic to move data, you...

Okay, your original post isn't the clearest on what you are trying to accomplish, so here is my suggestion. Read the article I have linked below in my signature...

Then there are posts like this one http://www.sqlservercentral.com/Forums/Topic607983-1291-1.aspx and you spend hours of your own time coming up with a solution to replace thier RBAR code; you ask for sample...

Insert into c

a,b

select

@a,@b

from table where

not(a=@a and b=@b)

does that help???