Its difficult to do it in one query. You can either use cursors or write a UDF that takes the start time and returns the end time and call it...

check this out : http://vyaskn.tripod.com/code/propercase.txt

Does the company sponsor visa ?

you can throw in a where condition :

where convert(int,col1) = col1

when you convert to int you lose the decimal part. So if its still equal to the original value then...

>>Or ...

If you have an identity column in teh table do the insert and then use

SET guid = @@IDENTITY

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

SCOPE_IDENTITY() is more accurate than @@IDENTITY. Check out books online for more...

looks like you are doing this totalling inside an RS report. you can do something like :

=((Sum(Fields!Valuation.Value * 65/100)) * 0.125)

in your GST field value.

or even add a new...

I think you can set it in the properties section of the report on the Report Manager. You can also set it at design time from VS.NET.

Try increasing the timeout property in the connection string.

also post the structure of your tables ( the parent, child) ones..

at the beginning of the stored proc. and turn it back on at the end.

Sorry to digress again..Yesterday when this post was posted there were no replies all day and suddenly the thread runs into 2 pages over night..??. I think there is hardly...

you can prbly create a connected dataset with a table and do the update all at once and commit the changes using the dataset.acceptchanges() method. check this article from...

I think Remi is right in that when you use COUNT(*) the optimizer chooses which index to use and returns the count faster as compared to COUNT(1) which need not necessarily be...