I am converting this code from Access to MSSQL,
I have an error that reads:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]'rnd' is not a recognized function name.
The code says:
strSQL = "SELECT * FROM [feedback] WHERE feedbackstatus = 'show' ORDER BY rnd(-(1000*dc_feedbackKey)* " & R & ")"
It randomizes the set of records.
Anyone know how to write this out for MSSQL?
Also is there an online reference for comparrissons between Access, MSSQL, and MYSQL for ASP code?