vijay-367524 (4/15/2013)

---

Hello,

I have a sql table as below

AutoIdPIDItemIdItemItemValue Date

7560 432 1 Wbc 4 ...

It works just like the way your joins do. You can't reference a table that has not yet been joined. CROSS APPLY is really nothing more that more complex subselect.

select...

maxlezious (4/15/2013)

---

Hi,

When i run your code, on the second column actType I get '}' with all the results.

For example:

254}

254}

254}

Is it possible for you to remove the '}'...

With nearly 300 points I assume you have been around here awhile. Please take a few minutes and read the article at the first link in my signature. Then post...

Melanie Peterson (4/15/2013)

---

OK, it's Monday, brain is (more or less) refreshed and I'm posting the text of the sp, including the T-SQL that seemed to be causing the code to...

I think we can do it like this. Basically we just use a word boundary and a simple replace. This will find any values with numbers between 13 and 16...

parikiti (4/12/2013)

---

sorry for the late reply...

Case 1:the first column can be considered as first one and also there is a time assigned when the that particular row was created like...

An interesting question. The duplicate ID's was certainly a nasty distraction. I managed to notice the ID issue but wonder what this question was really trying to test/teach. I think...

We are getting there.

The sample data is excellent. That...

That is somewhat more clear. What would be best at this point is to post ddl (create table scripts), sample data (insert statements) and sample output based on your sample...

Now that you decided to go full on CLR for this you have a myriad of resources for your searches. I found this one which looks pretty good.

http://www.regular-expressions.info/creditcard.html

Here is another...

It is pretty scary!! After seeing yours I modified mine slightly to avoid the second cte which means our code is so close to the same it isn't even funny.

;with...

LOL I should have refreshed. Seems that Lowell beat me to the punch again.

Here is one way using DelimitedSplit8K.

;with split as

(

select AcctNum, Item

from #Data

cross apply dbo.DelimitedSplit8K(FuelType, ';')

)

, SingleVals as

(

select distinct * from split

where Item > ''

)

select AcctNum,

STUFF((select ';' + Item

from SingleVals s2

where...

Melanie Peterson (4/12/2013)

---

SSCrazy Eights - thanks for the warning. The input to this stored procedure, however, is done entirely through choices made in lists populated from the database. The user...