refer this and all your problems would be taken care of.

http://secretgeek.net/sql_ent_page.asp

Good to know all this time i was doing the same conversion you mentioned.

extra work reduced 🙂

I love VB.NET it'll be unfortunate it it'll be phased out..

i also love the fact that you don't have to build in vb.net to get rid of the compile errors.

This question is worded poorly. Web Assitant should have been Web Assistant stored procedures...:w00t:

\\172.16.4.80\OT Files\hdf0307.txt

try to have the name of the folder of 'OT Files' without spaces and try.. like 'OTFiles'

Select Top 1 CustID

from <TableName>

Group by CustID

Sort by Desc

or

Select Max(CustId)

from <TableName>