This should do the trick:

INSERT INTO Table2

SELECT DISTINCT Places

FROM Table1 AS A

WHERE NOT EXISTS (

SELECT 1

FROM Table2 AS B

...

Probably cardinality changes in your joins to other tables. I can't tell from here.

Try using DISTINCT in your query (it goes immediately after SELECT).

I would suggest you to check the...

Looks like your view definition comes from an Oracle port, isn't it?

This should do the trick for you:

CREATE VIEW open_items_summary

AS SELECT vendor_name,

...

Duplicate post.

Replies here, please:

http://www.sqlservercentral.com/Forums/FindPost942232.aspx

No, it can't be done.

Depending on the aggregate you're using, you could rewrite the query to achieve the same thing in a different way.

Problem is I don't see any aggregate...

I don't see this in your sample data. Are you sure?

As the message says, INSERT - EXEC cannot be nested.

This probably means that sp_replmonitorhelpsubscription internally uses INSERT - EXEC.

Some workaround could be using OPENROWSET to wrap the procedure:

insert into #replmonitor...

This is a good one:

http://www.youtube.com/watch?v=pZIwhYyz9oQ

That's called "optimistic locking".

ADO and other DB libraries implement this technique natively.

I agree with you, Scott.

This causes some problems when data stored in the table is of type datetime and you just want to filter for the date part.You would generally...

I'm sorry , I don't understand.

Any examples?

Nice editorial, Steve.

I experience the same every day here at work. Looks like people are not paid to do their job, but to push some buttons on the screen.

When something...

Simply foolish choice.

Anyway, you could pre-process the files splitting them into three files depending on the A/B/C flag.

Duplicate post.

Replies here please.

It could definitely be partially used pages.

Try rebuilding / reorganizing the clustered index and all nonclustered indexes.