.. And the job runs on server A too?

Are you running BIDS on the same server as you have scheduled the job?

Applying Lowell's suggested method to my real-world version of this problem worked splendidly. >300k records updated in less than a second.

Thanks again.

Haha. Thanks for the excellent...

vick12 (10/13/2011)

---

Hi All,

Thanks for your replies. Actually I am using SSRS to develop a report and I need to sort the data based on a sort input parameter the user...

True, of course.

You are very much more accommodating than I would ever be, an...

I suspect (just a wild guess) that the query contains DISTINCT in the select list and, since the OP is selecting the converted date, can only ORDER BY the converted...

cyndi_kemp (10/12/2011)

---

That was it, changing the join to a left outer join did the trick. Thanks so much for your help. Sorry about the table names, come from...

SET @someval = ISNULL((SELECT Name FROM SOMETABLE WHERE ID=3),'')

OR

SELECT @someval = ISNULL(Name,'') FROM SOMETABLE WHERE ID=3

This assumes that the subquery returns no more than one row, which might not be...

Without more information, this is impossible to answer.

Please post the full text of the error message you are receiving.

This question is not detailed enough.

Please provide sample data, showing source data and desired output, as described in the link in my signature.

Files in the same folder cannot have the same name.

Best practice is to move your files to an archive folder after processing them - so the only files in the...

Why not just use a Foreach loop to process all files in the folder, regardless of name?

Or maybe *.txt - whatever works.

Do the files need to be processed in order?

You can say that again.

Or can you?

😀

If this code is driving an Execute SQL task and a number is required for a subsequent precedence constraint, the query should return a number!