at a time more than 8 users executing sp_xml_preparedocument what

we r using xmlconcept , sp_xml_preparedocument taking 1/8 of the total memor
y
but our front end tool is PB .often our application close cause of locking
at a time more than 8 users executing sp_xml_preparedocument what will
happen , i need urgent soultionMake sure you are using sp_xml_removedocument
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Subramaniyan Ramesh" <SubramaniyanRamesh@.discussions.microsoft.com> wrote
in message news:29D5FD50-CA2B-4090-B589-0749BC460200@.microsoft.com...
> we r using xmlconcept , sp_xml_preparedocument taking 1/8 of the total
> memory
> but our front end tool is PB .often our application close cause of locking
> at a time more than 8 users executing sp_xml_preparedocument what will
> happen , i need urgent soultion

Asp.net

I am designing a website which uses dates input to calculate the total cost of product, using this code

pdatstart =request.form(txt1)
pdatend=request.form(txt2)
plngwd=datediff(dateinterval.day,pdatstart,pdatend)

but it returns an error saying cast from string to type date is not valid
and how can i use it to calculate for the cost in the shopping basket.

ThanxxAre you using this in Crystal Report formula field?