Now,i want to split the following string in the below format.

Declare @Str varchar(4000)

set @Str = 'David,karthikeyan'

Expected Format:

D

D A

D A V

D A V I

D A V I D

K A R T...

Kindly explain me how and why with proper example.

Thanks.But,is it possible to get lastmonth's lastdate without using localvariables ?

I mean i want to find last month's last date only ? I don't required the current month's first,last month.Just...

I am using sqlserver2000 and sybase12.5.3.

Jef,

Wow ! Really interesting! It opens my eye broadly.

Thanks for your explanation with good example.Once again,Really i am wondering about your skill.

I didn't check your second code.I am going to...

Jeff,

Really i am wondering about your skill.

Can you explain me your two different queries in detailed ?Also,

1. What do you mean by @Delim+Remarks+@Delim ?

i.e Why...

Stephen ,before changing your trigger logic,do you...

how to form setbased query Without using spt_values table ? is there any other way to avoid while loop ?

Say for example i have to write a query to display...

and you also get it from the syscomments table.

select text

from syscomments

where id = object_id('procedurename')

Thanks Chris.

Jeff,Thanks a lot for your answer.

Thanks a lot for all experts. Your suggestions are very useful to me.

Jeff,

Sorry for late reply.

Solution:

Create table Extract

(

ID Int,

Remarks varchar(100)

)

insert into Extract

select 1,'123-01,EX,2600'

insert into Extract

SELECT 2,'123-01,EX,2600,123-02,EX,2600'

insert into Extract

SELECT 3,'123-01,EX,2600,123-02,EX,2600,123-02,EX,2600'

For example i have inserted 3 rows.Metnik wants to extract in the below format.

ID...

So far i have faced around 20 to 25 interviews.But so far i have attended one client interview only before 1 year. Also i haven't worked in client place.Yes,So far...

confident level