The code you've got there gives that error because as far as exec(@exec) is concerned, @rc isn't declared. exec() is just a shell, I believe.

If using the shell...

quote:

---

I tried to build a Unique index on the copy of the table when it already had the data in it, and...

Hmm. I've never observed that behavior. Could you past in some code we can look at?

--SJTerrill

Thank you! Looks like this is going to help me today.

Regards,

--SJTerrill

Another point to be aware of when using binary sort: if you reference a foreign (linked) server with a different collation method in a JOIN or WHERE clause, you may...

Try SELECT Round(12345.6789,2). This should return 12345.6800. Note that ROUND doesn't actually modify the precision of the result. If the second argument is negative, it is interpreted as a number...

the BETWEEN clause is, unfortunately, exactly what the word means. When used with datetime data '8/1/2003' is interpreted as 'August 1, 2003 00:00:00.000' and '8/31/2003' is interpreted as 'August 31,...

sxg,

Is the average you wish to calculate a moving average (say, for purchases up to 90 days back)? Or... is it an average for all history of purchases? In either...

Yes, though I don't know of many who would recommend it. For SQL 2000 (don't remember if this worked in 7.0):

In EM, right click on a table in the database...

Shas,

Again, thanks for the response. The remote box is also SQL Server authentication only. I'm not sure that the mixed mode security will fix my woes.

The primary rubs are that...

Thanks for the reply!

We're connecting using just SQL authentication. This doesn't also require a domain user on the remote machine, does it?

Another point I didn't mention! The remote box isn't...

JMeyer,

Assuming your SET DATEFIRST is set for Sunday, then this should do the trick:

DECLARE		@ThisDate AS datetime,

		@NextSaturday as datetime

SET @ThisDate = GetDate()

Totally unrelated to topic, I know... but here's some fairly cool pictures of California interchanges, including the 'four-level' in L.A.

http://members.cox.net/mkpl/interchange/interchange.html

SJTerrill

We've had some success with WinAce, but the largest files we've tried with the product were on the order of 30GB. There's a free trial if you want to give...

This is somewhat rough, but I think addresses your last question.

SELECT		syob.name 'ObjectName',

--		syco.name 'ColumnName',

--		syco.type,

		syob.type 'ObjectType',

		syus.name 'UserName'

FROM		sysobjects syob

		JOIN

		sysusers syus

		ON syob.uid = syus.uid

		/* If you want column data

		LEFT OUTER...