Well, in the absence of any other information I'd suggest you try something like this:

INSERT into Table1(col1,col2,col3)

Select T2.data1, t3.data2, t4.data3

From (Select data1, row_number() Over(order by (1)) as...

What error are you getting?

Make sure that you have the job step's database set correctly.

We cannot see your XML. Try attaching it as a .txt file.

Sure:

IF id=10

BEGIN

with mycte(id,name,status)

as

(

...

Do you have a separate index on every column that you can search on? You ned this at a minimum to get any kind of performance out of a...

I would be happy to check out this SQL code if you could post it in a form that we can use it. If you are having difficulty cutting...

I believe that this is either a SQL Server bug or a corruption of one of the system databases. I would recommend contacting Microsoft.

GilaMonster (10/4/2008)

---

There are two places with very bad estimates:

The clustered index scan of Inv_AeX_AC_Client_Agent, which estimates 1901 rows and gets over 6000. It may be that this is...

The costs aren't times. They're a unit-less measure calculated from estimated time, estimated CPU,...

OK, here is the SHOWPLAN XML Statistics from after a run. Note that this is not from the production system, but rather from my laptop after I copied the...

Probably not from the production environment in the time that I have left (it...

Not sure. I am considering parameter sniffing as a possibility for why the query plan for a query is so wrong. I have attached it as a .TXT...

Jonathan Kehayias (10/1/2008)

---

That would be my thoughts on this exactly,...

You'll have to give me a clue as to what is wrong with the results from my query if you want me to change it for you.

Yes, as Jonathan shows, Certificates allows you to get around the TRUSTWORTHY requirement, because you cannot use DB level authorities to use another Server-level Certificate-based Login.