bellis,

Oh yeah...now THAT'S a good idea!  Why didn't I think of that?  I guess it's because I haven't had to mess with Access for a while.

Well there's your answer; use SQL, not foxpro! 

Just kidding; I'm assuming your constrained to deal with the foxpro tables.

select c.CustomerID, o.OrderID

From

 (

 Select  CustomerID, max(DateOfOrder)...

I think EM reports off of the sysindexes table:

Select  so.name, convert(int, sc.rowcnt) as RowsInTable

From sysobjects so (nolock)

JOIN sysindexes sc (nolock) on so.id = sc.id

WHERE  sc.indid < 2

order by RowsInTable desc

If your...

Ahh...I see.  OK, the "Column Headers" you refer to are Query Analyser specific, and have nothing to do with tSQL.  It's kinda confusing (like "Go"), but it is just a...

I'm confused by what you mean with "Column Headers".  As for exporting to csv; use DTS.

cl

This is JUST A FIX; I am not advocating this as the best method.

declare @name varchar(20),

  @dbid  int ,

  @sql1 nvarchar(4000),

  @size nvarchar(100),

  @min nvarchar(20)

declare dbname cursor for

select convert(varchar(20),name) as name, dbid from sysdatabases...

It seems a lot of this debate is about "ease of use".  People are challenged when faced with 300 tables.  However, I've found that, if you learn how to work...

Haa haa haa!!!!

Sorry....

--------------------------------------------------------------

Quote:

One thing I don't agree with, Calvin, is the non-clustered index. 

--------------------------------------------------------------

You mis-understand, the nonclustered index is on the "Trade" table; I would assume the clustered index would be on the...

Jeffrey,

This shouldn't really be a performance question; it's more of a design question.  For example; do you want to change your code everytime a new TradeTypeID is created?  If you...

amachanic,

Both articles referenced talk about using check constraints and triggers instead of foreign keys.  Lots of overhead!

cl

Oh yeah, you can use a csv (or other delimiter) and use the output parameter for multiple rows.  However, you then have to parse the string:

declare

 @ncommand nvarchar(1000),

 @nparmlist nvarchar(100),

 @fname varchar(8000)

set...

As long as your returning one row, hoo-t's example is prefered.  If you're returning more than one row.  If not, then use a table to store the returned values.

declare

 @ncommand...

Actually, I thought it was pretty clear, although I agree with "too wordy".

Main point being that constraints can't be properly maintained with the "MUCK" table design, and the fact that...

Atiq,

I don't understand your technique.  Does "x" in the subquery mean a parameter?  I tried running this on pubs, and as expected it failed.

declare @int int

select @int = 10

select top...