Only a bit? 😀

I was thinking along similar lines, but couldn't face writing out all that nesting!

Yes, you would need to install the Excel stuff on the server in order to manipulate the Excel spreadsheet to the degree you would like.

Personally, I don't like this approach...

You could add a SELECT LEN() just to verify that.

Griffster (10/24/2011)

---

Elliott Whitlow (10/24/2011)

---

Yes you can but what I am unsure about is order of precedence. If you happen to have the same variable in the config data will...

thulani.moyana 79207 (10/24/2011)

---

...

I'm wondering why the single exec('Use database') does not affect the statement immediately after it as I would have thought it is executing on the target database but...

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