I agree with Mattie. Please can we go back to the old way of having threads only appear on the newsletter once. That way readers don't have to...

Joe

That looks as if it will fit the bill.  Unfortunately, I'm off home now and I have three weeks out of the office, so I probably won't be able to...

Joe

LOL indeed!  t does stand for table, but as I explained, I could have used any other letter(s) instead.

John

Rohit

This information about your error is available in Books Online.  Have you checked your error message and run DBCC CHECKDB?

A

system assertion check...

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