Not to mention that this is using global temp tables. What happens when you have two users using this proc? The first person's data will be truncated when the second...

erikd (10/9/2013)

---

dwain.c (10/7/2013)

---

But it can also be done with a single call to PatternSplitCM:

WITH SampleData(MyString) AS

(

SELECT' [{mark,peters,mr}{jane,fonda,mrs}{john,doo,mr}{james,bond,mr}]'

)

SELECT MyString

,Col1=MAX(CASE WHEN ItemNumber%6 = 2...

Again, without table definitions, indexes and an actual execution plan we are shooting in the dark. Both Jeff and I have suggested you read the article about how to post...

And the posted query clears up the Oracle suspicion. You might try posting in the oracle section or maybe find better luck on an Oracle forum.

Execution plans are cached....

sqlfriends (10/9/2013)

---

I have a query to pull the first contact of students.

The table has all contacts like parent/guardian, friends family, emergency contact etc.

I would like to the first priamry contact...

RamSteve (10/9/2013)

---

Hi ,

All of the posts here work and the one i gave also works but i am looking for other ways of doing it in a simple manner and...

RamSteve (10/9/2013)

---

here applying condition 99 is not needed as i need to delete all the rows in TableA with the same condition WHERE deleteflag is 1 for all the products...

Sure as soon as you post everything in a consumable format. As I said previously, I am not going to spend an...

OK gotcha. Lowell and I have posted a couple of fairly ugly cursor based solutions over the years around here. However ChrisM posted a really slick set based approach to...

Don't rush into posting table definitions just yet. I suspect you are wanting to look at all tables, there is no point in posting that much detail for this type...

OnlyOneRJ (10/9/2013)

---

We have

Server name- TESTXXAB

Database name - TEST_USER

This DB have many Tables

Now we have to write a query which will search the data in the tables which contains the...

Here is the challenge. You are looking for help to your problem. From what you have posted it will take me...

Stefan Krzywicki (10/9/2013)

---

Sean Lange (10/9/2013)

---

Stefan Krzywicki (10/9/2013)

---

Sean Lange (10/9/2013)

---

Stefan Krzywicki (10/9/2013)

---

jcrawf02 (10/9/2013)

---

Stefan Krzywicki (10/8/2013)

---

SQLRNNR (10/8/2013)

---

Stefan Krzywicki (10/8/2013)

---

Well, time to polish the resume and start looking for work. Just given a...

Stefan Krzywicki (10/9/2013)

---

Sean Lange (10/9/2013)

---

Stefan Krzywicki (10/9/2013)

---

jcrawf02 (10/9/2013)

---

Stefan Krzywicki (10/8/2013)

---

SQLRNNR (10/8/2013)

---

Stefan Krzywicki (10/8/2013)

---

Well, time to polish the resume and start looking for work. Just given a 1 month notice.

They want...