Normally I would say use a WHILE loop however this should work better.

1) Create a permanent table for duplicating objects.

CREATE TABLE tblDuplicate (

[uid] [int] PRIMARY KEY

)

And fille it with numbers...

Sorry no server near by but try CONVERT(numeric(12,3), '4,668.90') see the thing with ISNUMERIC only check it the string or value can be interpreted as a valid integer, floating point...

Don't know anything that exists in SQL right off but take a look here at a C++ example on how to do this. It can be converted into an XP...

Haven't done this much, so usually I just use EM oto do it. Not really sure what all it does to add it but if yuo want to know setup...

Seems like it has to be configuration related. Try dropping the link and recreating. Also, what Service Pack level is your SQL 7 server, I test SP4 and could not...

The key with anything is to be aware of what you allow to run against your server and the impact it has. I spend sometimes several hours a week fighting...

When SQL 7 first came out I was involved with the Y2K project. In that capacity I devised a way to tie serveral non-related Problem Management databases together using SQL7...

Not not really exactly like that in one query. However if the last column has a finite number of possible answers you could create a CASE statement to denote each...

The best one to tell if the NIC is bottlenecked is to use Network Interfaces/Output Queue Length.

From Explain window

quote:

---

Output Queue Length...

Glad to here you found a solution. I almost bet if the SP was moved by attaching the database that it was using a previous compile and execution plan stored...

There is no TSQL equivilent in SQL 7 like is being stated here, SPs work and XPs work but you cannot use them inline so technicall SELECT sp_encrypt('ssss') doe you...

XML is a hierarchy structure file. Lots of examples on the web and you can use various providers to persist data to files, I do this for configuration data on...

Try SELECT COUNT(*) FROM TABLEB and SELECT COUNT(*) FROM TABLEA and see if either gives you an invalid object return, that should narrow which it is.

"Don't roll your eyes at...

If it exists then double check you didn't typo and are not missing a ( or ) where it should be. If the table name is actually number then you...

Boy I need to learn to read complete messages, oops.

INSERT INTO targettable (targetcol1, targetcol2, etc) SELECT origincol1, origincol2, etc FROM origintable (Any where clause you need against the origintable)

"Don't roll...