Dear Friends,
The SQLCMD parameter setting I encounter problem with this part of the coding:
strSqlInsert &= " Where (SalesID <> @SalesId ) "

Here is the error message:
Incorrect syntax near the Keyword 'Where'

Using SQL String with SQLCMD parameters to create a new record at SQLSERVER2000 table, TBLSales. but t's not working with WHERE statement.

Here are the...