I can tell you based on my time working ExcelForum.com a few years ago the issue of people asking questions and then not acknowledging answers is certainly not unique to...

If the added field in the select list is not in the index, the query optimizer only has two options:

1. Look up the rows you need with the nonclustered index,...

Make sure the behavior of each job step is "Go to the next step".

I agree with SQLRNNR, and to test this you can add the extra field you are selecting to the current nonclustered index as an included field and see if that...

If it should be autoincremented, can it be the identity field? What is the...

I believe this would do the trick:

INSERT INTO table1

( SECTION )

SELECT SECTION

...

Rod at work (5/22/2014)

---

So you...

When you run the query, what kind of scan/seek is being done on dbo.cb? Is there an index that contains begindate?

Yes you can:

--Create table parameter type

CREATE TYPE dbo.TableParamTest AS TABLE

(i INT, string VARCHAR(255));

--Create stored procedure

CREATE PROCEDURE dbo.test

(

@tableparam TableParamTest READONLY ,

...

You've probably already checked this, but I've had problems in the past (in Windows) where the DSN's default database was different than the one I was trying to access, and...

You can use the ISNULL() function:

SELECT ISNULL(fieldthatmaybenull, 'Other value')

FROM ...

I've always been successful by scripting the job to a new Query Editor Window, then changing the connection on that window to the destination server.

Can you post the entire SQL statement where the dynamic string is built?

I disagree that fragmentation would not be removed. As long as the table is big, the fragmentation will be reduced. I have a bunch of crappy third party...

batgirl (5/16/2014)

---

As is often the case, I am now thoroughly confused.

I am pretty sure that I need a vacation, or at least a long weekend.

I assumed that "NOT"...