I am curious why you need this information.

Are you preparing to write the monster SELECT statement and want to see what system can handle it?

Or are you simply doing a...

You could use a join to match the View and Table on GENDATANUM

and then use where conditions to select the records that do not match

SELECT GENDATANUM, ...

I find it amazing that people can work in the IT/Software industry and promote this sort of copy write infringement.

Also most of these books are around $30 even cheaper...

I'm not sure if there is a max number of AND OR statements in SQL 2000, Surely the logical and practical limit would always be a lot less than...

A View could help in this situation as you have a few joins,

but first i would look at writing a more optimized query.

For example

(b.strTitle like '%' + @Keyword +...

It depends.

Are you using a lot of Joins or Aggregations it your query?

The only way you can really prepare for this is to get hold of a copy and build a demo application and learn your way around the system. If you...

Setup an ODBC connection to your database.

Click on data -> Import External Data -> New database query

and select your database or an exsisting query

The data can be easily refreshed...

Fair enough, VPN would be the case if large amounts of data is to be transferred.

Financial application can mean a lot of things though and not enough...

The VPN suggestion is one way, but it would be costly and maybe difficult to convince your clients to set up all this infrastructure to get your application working.

You...

No you can't sorry.

you will have to do this through a front-end application

Could it be a case of your disks filling up with the transaction log?

have you checked for free space?

You could steup some API calls to your SQL server, put these APIs on IIS that is located on the same network as your SQL server.

The customer applications...

yes there are ways,

What sort of network does your organisation have?

Use a stored procedure,

with a LIKE clause in the where statement

or if you want better matching you can use character matching or pattern matching.

Post you table DDL and some sample...