Viewing 15 posts - 1 through 15 (of 21 total)
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...
August 22, 2011 at 3:19 am
Thank you very much.It's working fine.
June 3, 2011 at 12:19 am
I have created date in my table.
May 16, 2011 at 10:49 pm
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
April 28, 2011 at 12:39 am
Hi,
your query works perfectly.I need the same what u send.
Thank you very much..
April 18, 2011 at 1:27 am
Hi,
project country vendor cost
------- -------- ------ ----...
April 18, 2011 at 12:44 am
Thank you craig.
It may solve my issus
January 5, 2011 at 3:02 am
It give result like 0Y : 2M : 63D
I need the result like:2M:2days (2010-08-10,2010-10-12)
January 5, 2011 at 2:46 am
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.
December 12, 2010 at 10:20 pm
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
------------------------------------------
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...
November 24, 2010 at 9:15 pm
hi,
It gives error like
(Must declare the scalar variable "@Data")
but @data is xml type parameter of sp.
November 24, 2010 at 8:56 pm
Viewing 15 posts - 1 through 15 (of 21 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy