sqlnewbie17 (6/8/2016)

---

I tried this code on one of the tables which has col values as fadsf-ff,fsdf-ffg,edf-d

and this code should select values after the '-' in the string from colA

SELECT SUBSTRING...

Have you checked out the following article Geocode Addresses in T-SQL[/url]? I've never tried it, so can't really offer any more than that.

Drew

Lookup sys.sp_MSforeachdb

Drew

This type of processing is referred to as RBAR (Row By Agonizing Row), because it is a HORRIBLY inefficient approach in the vast majority of cases. Why don't you tell...

sqlnewbie17 (6/6/2016)

---

How do I inner join between 2 tables(inner join TableA.ColA=TableB.ColA) with this kind of data ?

My comparision values from TableA will be values after the '-' i.e (SS,SE,SD,SA)

TableA ...

TheSQLGuru (6/6/2016)

---

I didn't read all this thread, and I'm not going to start now. 😉 But it is REALLY hard to think of a scenario in which this WHERE clause...

Jacob Wilkins (6/6/2016)

---

I didn't say it will return only rows with RN=1 and transtype='Shipment'.

I said it will return all such rows.

The "period" was to indicate that the current...

Jacob Wilkins (6/6/2016)

---

It sounds like the problem is that you're returning rows where current quantity is 0, which violates one of your requirements.

If that's the case, then at least that...

chandan_jha18 (6/6/2016)

---

So is there no way out of this mess? Is it possible to have a new table with same structure with a computed column where we do a bulk...

marcossuriel (6/6/2016)

---

Hello Drew,

I was out for a few days. I'm back to work today. I'm sad to report that your solution doesn't produce the correct results when I put it...

Eirikur Eiriksson (6/6/2016)

---

Quick thought, the isnull statement is redundant ad null is never equal to null. It will on the other hand impede performance as the resulting execution plan will...

Ray K (6/6/2016)

---

drew.allen (6/6/2016)

---

Ray K (6/5/2016)

---

WayneS, nice to finally meet you in Philadelphia this past Saturday. Good to place faces to all the names and aliases from here in...

A little clarification on the reasoning behind Luis' code.

The reason to use the STUFF function, is that it can replace a string of one length with a string of another...

Ray K (6/5/2016)

---

WayneS, nice to finally meet you in Philadelphia this past Saturday. Good to place faces to all the names and aliases from here in the forums!

BTW, I...

Wayne West (6/3/2016)

---

I don't always drink beer, but when I do, I put a semi-colon in front of it. 😀

This is why I like Mladen Prajdic's SSMS Tools[/url]: Ctrl-A, Ctrl-K,...