I think...

Oleg, I'm glad you clarified this... I thought you were saying it...

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

-- it would have made things easier...

Looks like Dan beat me - he did this pretty much the same way I was working on.

Here's my solution. The basic difference from Dan's solution is that I'm using...

I think that full text has a good possibility here for you.

To answer your original question, use the DelimitedSplit function to return the words into a table.

IF OBJECT_ID('dbo.DelimitedSplit8K') IS...

Thought-provoking. Very nice... as are the replies.

Jan Van der Eecken (6/4/2010)

---

Are you saying you want to see all columns from Table2 as well? Then Wayne's example only needs a tiny change:

SELECT t1.*, t2.*

FROM Table1...

allenjasonbrown (6/5/2010)

---

Wayne --

I am stuck!

Here is the code I am running:

.....

WIth the input being....

28259,Security,Security,SUCCESS AUDIT,MIS631,6/1/2010 9:53:11 PM,624,ekilgore\KILGORE,"User Account Created: New Account Name: rfitzbetter ...

allenjasonbrown (6/5/2010)

---

Hi Wayne - I am trying to set up the other record types.

Can you explain what this field does "Pos3-Pos2-15"

SubString(c1.Field9, Pos2 + 14, Pos3-Pos2-15 ----I understand this means start...

For those of you'll using TFS... how do you migrate from Dev through Prod?

Our configuration management team is trying to get us to "just do a build and move everything"....

deeomen (6/4/2010)

---

Posted - 06/04/2010 : 05:34:06

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

wanted output

when the running sum of no_of_ticketsreq reaches 250 i need...

John Rowan (6/4/2010)

---

In fact, since your Table A will only ever hold one value (since you are not getting this from a table in the DB, but from the @ID...

You might also be able to simplify it like this:

-- get the first three, if there are that many

SELECT OrderID, InsuranceName, PayerPartition

FROM #OrdersII o

WHERE PayerPartition <= 3

UNION...

DECLARE @test TABLE (Col1 float)

INSERT INTO @test

SELECT 10.125 UNION ALL

SELECT 50.2550 UNION ALL

SELECT 40.5

SELECT sum(round(col1,2,1))

FROM @test

Good catch John. If we go this route, we'll also need some DDL/DML for sample data. See the first link in my signature for how to do this.