let me check it out is it possible for u to send me the snapshot of ur connections ...and did u check the stored proc by running it in...

Hi chinni..

Could you just send me that sproc or give me some or details so...

Hello mary i have checked with your code evrythng works good .....

as chris sais u need to have an end if u have an begin ,....

i added end to ur...

YES YOU WERE RIGHT I HAVENT POPULATED THE TABLE...GOT IT THKZ STEVE...

STEVE ---IS N HERE THE CHARACTER COUNT IN THAT STRING--

SELECT SUBSTRING(@Parameter,N+1,CHARINDEX(',',@Parameter,N+1)-N-1)

FROM @TALLY

I HAVENT GOT ANY ERROR BUT IAM NOT GETTING ANY OUTPUT IT JUST SHOWS NULL NOTHING AND WHEN I RUN COUNT(*) I GOT AS 0

but when i executed this query in my DB i am not getting any output

--===== Simulate a passed parameter

DECLARE @Parameter VARCHAR(8000)

SET @Parameter = 'Element01,Element02,Element03,Element04,Element05'

--===== Create a...

Does this tally only applies for 2005 or can i make use of this in 2000 also ...PLz let meknow

Yeah i went through it ..i have a ques does it work if i rename it as some other table name instead of dbo.tally ...is thats just the logic or...

Srry i thought they it would be varchar(100) but it is varchar(4000) tats my source code datatype

Column name-- code varchar(4000) from table 1

so i am getting all the codes...

As i am using the sql server 2000 i cant set to max ...and the datatype of the column i am using is varchar(20) ....

HI Munson ...My Comma Splitter it is working i have already used it ..But now the results i am getting are some Codes like A435,b434,4kjf for each row...

what exactly i need is to insert a value from a llocal variable into a temp table for each and evry record using Cursor can i know how can i...

ok what exactly i need is

i have acolumn with data with comma separated in the same column so now i need to remove the comma and iinsert...

i have an issue here what if i have abc,hq,abchq as one type as i got

abc,hq ---when i wrote a function for this then i got as

abc -1...