hi,

Thank you.Now I can able to select the table.

but if there is any error in sp still the error comming again....

error:

--------

ransaction count after EXECUTE indicates that a...

ok Thank you.Its Working

Thank you very much.It's working fine.

I have created date in my table.

ok.Thank you..

thank you. It's work fine.

but while I am giving like

select ROUND(16.8712,0) it gives the result like 17.0000

It has been resolved by converting as numeric datatype

Hi,

your query works perfectly.I need the same what u send.

Thank you very much..

Hi,

project country vendor cost

------- -------- ------ ----...

Thank you craig.

It may solve my issus

It give result like 0Y : 2M : 63D

I need the result like:2M:2days (2010-08-10,2010-10-12)

Thank you much.

Now I understood.My requirement is only convert the variable not to print that.

So as u said conversion has worked without any problem.

THANK YOU VERY MUCH

Thank you very much

now it works fine.

but my requirement is I want to specify column name and data type dynamicaly

how to specify dynamically with this query

------------------------------------------

declare @sql varchar(max)

set...

because I need to specify columns name as variable dynamically

so that I am expecting this to run with exec

now I am using value fun in both of the cases...

hi,

It gives error like

(Must declare the scalar variable "@Data")

but @data is xml type parameter of sp.