Welcome Keith,

Don't let Joe Celko's comments upset you. Some people are bound and determined to always speak down to everyone – they like to make themselves feel important. That is...

Now I am dealing with someone who does not understand the value of temp tables (to me). He says eliminate them - they cause problems.

On the same subject - who out...

I believe this is the real issue here:

Select @@version on our 2 servers displays the following:

Production Server:

Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c)...

From another member here:

"The name of a temp table is actually a 132 byte name consisting of the user name, the table name used during the CREATE, a wad of...

test reply from Gary

A little trick here...

You will have an identity column in an SQL table to match the identity column in Excel; however, before you dump the info into SLQ, make sure...

Thanks Remi

To refer to a variable, use @villaname

This will not work for finding EXACT matches (i.e. Profit and profitablilty)

It finds "profit" twice.

How can we have the instance count be "1" and not count "profit" inside of profitability?

The LEN(Replace.... finds the instances - even if it is used in another word (i.e. profitability).

How can I get only EXACT matches??

Any ideas

Here is a sample connection string and query, to our SQL Server. It works great.

I hope it helps.

<%

Response.Expires = 0

' Set variables, build connection string and open connection

Dim objConn, objRS, strQuery, strConnection

Set...

sp_columns will do it

I had the same issue once when I had a query with a bunch of inner joins inside the SP.

I moved the query to a view and then referenced the view...

Thanks Jim,

For years, I worked in a place that had a dedicated SQL Server Administrator that took care of all this "stuff". I have been writting Cold Fusion, Java Script and SQL...