Updated code : and According to my understanding

returns one row per Country Code with three porttypes import type columns

For each class the ports import types are...

Hi ,

that 's my mistake .. here is the updated script

create function dbo.Function_name()

returns

@returnInfo TABLE

(

ID varchar(50),

area_Code varchar(50),

country_Code varchar(50)

)

as

begin

declare...

Hi PAUL ,

Thanks for code , But i can't use this .. because ..

According to your Code .. the dbo.test table has a chance of indexing(number)...

Ok, thanks Lynn..

Here is Code like

/* Actual store procedure */(main store procedure (sp1))

CREATE PROCEDURE spDR_FINAL_INVESTMENTS

@ID char(2),

@Code char(2),

@Class char(4),

@Date datetime, ...

The #temp table columns 'Declaration' and the substore procedure(sp2) Columns will be the Same ..

When the sub Store procedures (sp2) executes , it gives ouput of 6 columns ,

but it need to insert 4 Columns insert into #temp table , which depeds...

Hi ,

By the reading the replies for my question , i agree that My question is not at all clear or may be the incorrect terminology i am using...

Hi ,

By the reading the replies for my question , i agree that My question is not at all clear or may be the incorrect terminology i am using...

Hi ,

By the reading the replies for my question , i agree that My question is not at all clear or may be the incorrect terminology i am using...

Hi ,

By the reading the replies for my question , i agree that My question is not at all clear or may be the incorrect terminology i am using...

Hi ,

By the reading the replies for my question , i agree that My question is not at all clear or may be the incorrect terminology i am using...

Ok got it .. Thanks a lot Lynn

Ok , Thanks lynn .. I will contact DBA ... I think that is the only way to Fix the Issue ...

by the way ....what's the LOg...

oh... NO ... Contacting DBA is the BIG task .. they will be shrinking / screwing me into the Database ..i think