is your InvoiceGuid unique as name suggests or it is also duplicated? IF it is then

select InvoiceGuid

...

Hi Peter,

This is really great!!

I use lists as param to stored procs to insert data into tables often, this function will come handy, I have written couple of parsing...

Use a trigger, that is the only solution i can think of!!

Query Analyser

Entrerprise Manager

SQL Profiler

PerfMon

Double Take

SQLCompare

---

you can use quotes around the values where you think data have "," in between.

e.g:

Select Id, '"' + isNull(Location) + '"', col2.. from table....

This will result in something like

1,"Spain,...

I agree with Jules.

It would help if you paste your DDL.

If #temptable is created inside Sp_A, and it returns data, then SP_B will run with no issues..There might be some other issue inside...

TempDb will grow when you use temporary tables or variables to get data.

you can find the stored procs using trace...

John I agree with you, but sitll here is my solution::::

CREATE FUNCTION LeftPadZeros(

@Amount bigint,

@Length int

)

RETURNS varchar(20)

AS

BEGIN

DECLARE @retVal varchar(20)

DECLARE @HoldVal varchar(20)

DECLARE @CurLen int

set @HoldVal =...

Thanks Ryan for providing some good links. They are good.

Thanks John

I definitely have in mind to move that parsing code to a function.

It will be easier if you give table structure or columns from where to fetch data.

Thanks

Declare @Name Varchar(255)

Declare @ID_LIST Varchar(255)

Declare @Temp Table

(

Name varchar(255),

ID_LIST Varchar(255)

)

Declare cur1 scroll cursor for Select name from table1 group by Name

Open cur1

Fetch cur1 into @Name while @@Fetch_Status =0

Begin

Set @ID_LIST=null

Select...

do you want that in single query?

This cabe easily be achived by using cursors..

Thanks

CREATE Procedure GetCardNumber

as

BEGIN

SET NOCOUNT ON

Select dbo.fn_GetNumber(card_number) from candidates

SET NOCOUNT OFF

END

Hope this is what you want

Thanks