Surely another possibility is building a mapping table, if this is likely to be a repeated process?

Something like this:

select 'CITALOPRAM TABLETS' Pseudonym,

...

SQL_Surfer (10/20/2011)

---

SQL server...So do i need to restore msdb database? Can I restore this msdb into test server and retrieve my old package from there? But the test server will...

Is the package stored in the file system or in SQL Server?

Either way, you're probably looking at some sort of restore, unless you have the package stored somewhere else.

What is your question, precisely?

Having said that I think making the last step an archive and/or rename of the processed file is the way to go. Then you know it hasn't been processed because...

.. 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.