squvi.87 (9/14/2015)

---

Sean Lange (9/14/2015)

---

Your question has received a lot of views but no responses. That is because you didn't post a very clear question. Your sample data has two columns...

This is because you really shouldn't be...

mar.ko (9/14/2015)

---

Guys - I have a function that returns a table from a comma-delimited string.

I want to take this a step further and create a function that will return a...

mbrady5 (9/14/2015)

---

Good morning. I am trying to find all instances of a string that contain the letters FSC.

While I am able to find most of them, I am unable to...

_simon_ (9/14/2015)

---

@SeanLange: in reality it is a normal table, I just used temp table in the example script, sorry about that.

My way of doing it now is like this:...

squvi.87 (9/14/2015)

---

Hi There,

Above is the sample data.

This is self referencing table. Mainstream column is based on the sub streams. If any of the sub stream fails then corresponding main stream...

Since you are using a temp table it is highly unlikely that another process is going to be able to access this table as it would be out of scope....

MikeS. (9/13/2015)

---

I've been working in IT, largely as a software developer, for the past 20 years. Much of that time has also been with SQL Server and/or Oracle (I'm preferential...

Kristen the forums here do have some drawbacks that not other forums have but I don't spend hours scrolling through posts on threads I am involved in to find my...

reported as spam.

Kristen-173977 (9/11/2015)

---

Thanks, that looks better.

Is there any means to

a) Click a link for the "first unread post" within the thread?

b) Any ICON...

Nice John. I actually...

Kristen-173977 (9/11/2015)

---

I'm probably being thick, but I'd be grateful if someone could please point me in the right direction.

How do you follow the forum to read new posts in existing...

I am sure that makes...

mohelsheikh (9/11/2015)

---

Thank you ChrisM@Work

when i execute the procedure i have no issue (this mean the procedure syntax is correct and using OPENROWSET is not wrong), but when i call...