Here is a thread that discusses this.

http://www.sqlservercentral.com/Forums/Topic556439-146-1.aspx

Luis Cazares (1/16/2014)

---

Hey Sean,

It seems that the OP wrote the expected results and attached the sample data. So adding...

gatorfe (1/16/2014)

---

Hello we have a detail table in our erp systm that generates timestamp and message info per order. We are trying to create syntax so we can show...

Can you post GetNums? There have been a few different proper case functions around here over the years. They are always a challenge because sometime you want every word capitalized...

Shanmuga Raj (1/16/2014)

---

I have to get the query for data in an column and delete if the data exists

My data is

COLUMNA

-------------

(Location is Asia and Location is Africa) and (Manager...

It does seem that what you need it a string splitter. The one posted above will work but the performance of that will be awful. Please take a look at...

Nice job posting the ddl. Can you post some data? Remember we are all volunteers...

Your code works perfectly fine. It was not returning Doc jr because you filtered it out in your where clause. The easiest way here is to add filtering to the...

Posting in call caps is considered yelling. No need to yell, we are all friends around...

Rod at work (1/15/2014)

---

Hi Sean,

At this point I'm considering the possibility of using NVARCHAR. We didn't, back in the day when the database and tables were first created (~1997 or...

Shanmuga Raj (1/15/2014)

---

declare @ch varchar(200)

declare @result varchar(200)

set @ch = 'US , CA- I have been there'

BEGIN

set @result = LTRIM(RTRIM(CAST(@ch as varchar(max))))

set @result...

For anybody else stumbling across here I formatted this query so it is more legible.

SELECT DISTINCT d.dlr_reference_num,

...

marcjason (1/15/2014)

---

I have a stored procedure which executes multiple stored procedures.

I want it to run each stored procedure and if the result for any of the stored procedures is not...

Awesome job posting clean ddl. There are a few questions here. What is the balance? I assume it is some sort of calculation between inward and outward? Also, you said...

hlsc1983 (1/15/2014)

---

Grant Fritchey (1/15/2014)

---

I agree on the number of students. Also, what's the difference between student_pk and student_id? Seems like one or the other isn't needed unless the ID is...