Note: the post previous to yours is nearly two years old.

GilaMonster (10/25/2011)

---

I'll...

Gail, would you consider writing an article about this? It would generate lots of interest, I am sure.

I don't think so. There are custom components available here[/url], including more than one Regex component which looks promising, though I've never used any of them. Rather than doing that,...

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,

...