Any of the 'Gurus Guide to Transact SQL....' books by Ken Henderson is a must-have.

If you're really serious, you need to get a grip on the internals as well -...

If you're referring to the virtual tables 'deleted' and 'inserted' that triggers have access to, those are only visible to the specific trigger. If you want to grab data from...

You may also be thinking of this? (also needs a premade table to load into like the above example)

Using DBCC Result Set Outputs

Many DBCC commands can produce output in tabular...

This isn't quite what you asked for, it's a bit more specific in regard it only looks for empId's that have codes 1 and 2 and only when the amt...

BOL comes as an option to install when installing the client tools for SQL Server. It's a real must-have documentation, and always the first place to go when you're wondering...

Agreed, the workaround for having > 1000 FK references to a single table is to re-think, re-make, re-design the whole thing. This is not a normal number of FK's.

If you want to do this with Transact SQL, it is possible by using xp_cmdshell.

See BOL for further details.

/Kenneth

If I'm not mistaken, you want COALESCE as equvivalent to ISNULL, not NULLIF

NULLIF does not do the same thing as ISNULL.

/Kenneth

For what it's worth (but you already know that) the amount of data returned by each statement in the view (and also size of intermediate workingsets) plays a large role...

If I understand your question, you want to generate vCalendar appointments from Transact SQL..?

It seems doable, since it can be plain text, though I don't know if it qualifies as...

Unfortunately, there is no PIVOT in SQL Server 2000 - it will be in SS 2005, though..

I don't speak Access too well, but...

Would this help?

select  *

from  myTable

where dateColumn >= dateadd(mi, -1, '2005-03-08 13:15:44.880')

and dateColumn <= dateadd(mi, 1, '2005-03-08 13:15:44.880')

/Kenneth

That would depend on what it is to be counted..

The poster asked to count 'records'... (though it's not entirely clear what the actual intention is

The problem then lies within that particular view, it's not bcp's fault.

Anyway, you found a workaround

/Kenneth

To find for each customer in table B the latest update, regardless of which status..?

select  custid, max(datecreated) as maxDate

from tableB

group by custid

..should answer that

Though, I'm not entirely clear as...