I would recommend steering well away from this type of splitter. They perform acceptably for very small datasets, of course it is...

kalikoi (9/18/2013)

---

I have a table as follows

col1 col2 col3 col4 col5

A 11:30 13:30 15 11.30,11.45,12.00,12.15,12.30,12.45,13.00,13.15,13.30

i need the...

Since nobody else suggested it I guess I feel that I should. A more long term fix for this would be to normalize your data instead of fighting a denormalized...

PSB (9/18/2013)

---

When joining #temptable T1 to #temptable T2 on T1.Project = T2.Project , AND T1.Product = T2.Product LEFT(T1.SNum ,5) = LEFT(T2.SNum ,5)

WHERE T.Product ='UC' AND T2.Product ='UC' AND LEN(T2.SNUM)...

This works for the sample data you provided. There is no guarantee this will continue to work if the format of the html changes in the future. You may have...

PSB (9/18/2013)

---

Hi,

MyTotUnits field should get updated from field Units based on the condition below :

When Project ,Product ( UC only) and (LIKE) SSum (P-110 from ID = 1 IS...

Here is a great place to start.

http://www.red-gate.com/community/books/accidental-dba

ddl = data definition language

In other words, the create table statement.

something like:

Create table #MyTarget

(

...

Can you provide the ddl for the target table?

What are you trying to do with this? Are you wanting to parse individual values or store the html string? Some clarity in your question will go a long way...

Why are you executing this stored proc via dynamic sql? You are adding complications when it is not needed. You are most likely not getting the desired results because you...

anusha.minnu02 (9/17/2013)

---

Please help me, what are the system procedures and system functions that are used for validating whether a user is a valid user or not when we click on...

It looks like you have pasted a portion of your query a second time. Look where the first ORDER BY is, you then have FROM ... the same sql as...

Prathibha.m (9/18/2013)

---

Could implement. Any easier way??

declare @ClaimSequence varchar(2000), @count int, @counter int, @tpin varchar(8000)

SET @ClaimSequence ='101, 1, 300,333|101,2, 30, 400'

CREATE TABLE #temp(id int not null identity(1,1) ,...

Not at all insane if...