Joe

In the FROM clause, tblassignment is aliased as a, tbl3215 as t, and tblfltwrkcntr as f.  These are arbitrary aliases whose purpose is to make your code easier to read. ...

Byron

Please will you give us the CREATE TABLE statement for your temporary table.

Also, please have a read of this - it'll help others to help you as quickly as they...

Joe

I don't think your insert statements will work, because you have not enclosed string and date values in inverted commas.  But that isn't too important - we can put those...

Joe

I don't think Ken meant any offence.  We do get a few chancers on here who want us to work out everything for them, as you have observed!  We're not...

Actually, a low fill factor (apart from 0 which is equivalent to 100) will cause fewer page splits.  If I had a read-only table, I'd make it 100%.  And I...

Hugo

At the moment it's 101 for C and 86 for B.  I was lucky enough to guess the "correct" answer... I figured that R stands for rollup.  However, as so...

Joe

Sorry - DDL is data definition language, in other words the CREATE TABLE statements for your tables.  Sample data in the form of INSERT statements is easiest for us to...

Joe

When you say they don't work, do you mean they return an error, or you don't get the result set you expect?

What is the significance of the first statement?

Some sample...

I don't think your task is as simple as you hope.  With the five files you have, you have no way of specifying what data goes on what file.  When...

The count in Enterprise Manager is only an estimate based on the statistics on your table.  To get a more accurate figure, you should update statistics on your table; to...

See the topic Adding ntext, text, or image Data to Inserted Rows in Books Online.  Please post again if there's anything specific you don't understand.

John

SELECT @@SERVERNAME should do it.

John

Your insert statement is acquiring a lock on your table, which isn't released because the transaction hasn't been committed or rolled back.  That's why you get a timeout when your...

I think you can use a trigger.  If there's an insert or delete, you'll want to audit that, because a whole row will have been affected.  If there's an update,...

You can't do anything like that with SQL authentication in SQL Server 2000.  Your only options are to use Windows authentication or to upgrade to SQL Server 2005.

John