SQLRNNR (4/12/2012)

---

Steve Jones - SSC Editor (4/12/2012)

---

Both printers here are acting up. One doesn't want to inject ink on the the paper. The other keeps sending offline messages to...

Then there would be several of the rest of us who...

capn.hector (4/12/2012)

---

Lynn Pettis (4/12/2012)

---

drew.allen (4/12/2012)

---

I've come to the conclusion that he's not really interested in answers. He's...

Here is the complete solution based on the information you have provided so far.

select ? from ?

Why are you so stubborn about posting ddl and sample data? If you would...

suhailtajraja (4/12/2012)

---

the table that i have provided is the actual table. is that needs to be in new temp table so that i dont mess with the actual table? also,...

Are you calling the Update method of your sqladapter? The update will not work when there is more than 1 base table. You have to execute your dynamically built sql...

You already provided that table. Here it is all at once.

CREATE TABLE [dbo].[INT_AUX_FAVORITES](

[USER_ID] [int] NOT NULL,

[TYP_IND] [smallint] NOT NULL,

[ENTITY_ID] [int] NOT NULL,

[ENTITY_SRC_ID] [int] NOT NULL,

[DOMAIN_ID] [int] NOT NULL,

[ENTITY_NM] [nvarchar](150) NOT...

And if you are doing this as a single insert and you cancelled it, the implicit transaction would have been rolled back so there would be no data. If you...

phood (4/12/2012)

---

Okay, I've done so many different things I'm starting to get myself confused so let me make sure I have it down.

here is my select command with the join:

select...

Posting them as insert statements would be the preferred method. That way the people offering to help get your data in an easily consumable format.

There are far more tables than just the favorites. Also, we need sample data for each table.

this is just a shot in the dark but I assume you passing in @Matter_ID and @Project_ID?

See if this select would get all int_aux_favorites that you want deleted for a...

I can pretty much guarantee there is no need for a cursor for this. This is nothing more than a delete statement inside a loop. This can pretty easily be...

But each constraint must have a unique name.

The ambiguous column name means you need to specify which table it is coming from. Add the table alias to each column.

The join is from Access to SQL so you...