Thanks for your reply.

we have no option for go to appliction code.

The main application, they call only my stored proc not application code.

one applicationA is directly calling my procedure for giving data to applicationB.

inside of the proc,

I need to call the Java webservice and get data from applicationC.

It returns some data...

Hi All,

Thanks for your help.

I followed all your instruction and set the "RetainSameConnection = 'TRUE' ".

My Problem solved. Thanks very much.

Thanks,

Nithiyanandam.S

Hi,

Try this. This may be help you something

create proc usp_idtest

(@var varchar(10))

as

begin

select distinct * from idtest

where ( PATINDEX('%'+left(@var,1)+'%', data) > 0

...

Hi,

1. Add 12 columns to temp table (JanFlag .....DecFlag)

Column Datatype should be tinyint. We need to insert the following values.

0 - not editable

1 - editable

...

Hi Kavitha,

Refer this...

http://www.codeproject.com/KB/database/SQLDynamicPivots.aspx

This would help you something...

Thanks,

Nithi

Now I am using textbox input for date column

Already we have the calender control in front end (vb.net).

Now my client needs to the following format for date.

(for different end users in different states)

The following formats will insert through...

my proc looks like,

declare @tblvar1 (company varchar(25), ...)

declare @tblvar2 (company varchar(25), ...)

declare @tblvar3 (company varchar(25), ...)

insert into @tblvar1 (company ,....)

select company......

...

hi sean,

Thanks for your reply. thanks lot

hi vikram ,

Pls don't waste others time

your article --- what is this ?

Insert Multiple Records using a Single insert statement

By vikram kharbanda,

Total article...

Hi

Paul White NZ, Thanks lot.

Thanks for your help.

Thanks ALL. Thanks lot.

I tried to get the above qry. could you please check and verify this query...

select s.name schemaname, o.name tablename, i.name identitycolname,

ins.constraint_name...