Aha. Yes, I think you have it.

This would be a lot easier if the table could have a more-normalised design, eg:

TabXY(x, y_start, y_end, value)

then your queries would work very simply.

I feel like I've stepped into a parallel universe. The language sounds like English, but I don't understand it.

Can you please try again to explain what you are trying to...

timscronin (10/21/2011)

---

I have a column value like this

'Merged Facility Id:0286- Patient Id:999000 PHPatId:28488 with Facility Id:0286-C Patient Id:124013 PHPatId:678839'

What I need to strip out is

0286- ...

Sean Lange (10/20/2011)

---

You can use that in your stored proc with** the need for a GO or dynamic sql. Just make sure to set it off again before you exit....

Grant Fritchey (10/20/2011)

---

What about building a drug name mapping table. You run through the data once, nightly, after a load, something, and map the names supplied to the drugs available...

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