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???

First, question. Where is the backup file located, tape, network share (mapped drive or UNC), or a local disk?

My gut feeling, your backup is corrupt. If local tape,...

In addition to your execute plan, we will also need to see your query and the DDL for the table including all indexes that are defined on it as well.

Everything you posted may, in your mind be helpful, but we also need to see your stored procedure.

Mr J (11/24/2008)

---

Can someone please explain to me why this is not working ??

CREATE TABLE test AS

(SELECT A, MAX(B)

FROM ...