Yes, but fortunately it was only one point worth

Although there are several methods for paging qith SQL Server data available, I would transfer all data once at the beginning with GetRows(). So now you have an array and...

Can you be more specific on this?

Do you want to show some kind of summary?

I guess you were like me, and missed the word NOT in the question

I would also use two separate columns for project code and student (ID ?). The rest (eg, the presentation of A00001 can easily be done at the client application.

Very good catch

Erland Sommarskog has written something about dynamic sql along with Cursors here http://www.sommarskog.se/dynamic_sql.html

Can you get your hands on Inside SQL Server 2000?

The book has an indepth explanation on locking. But BOL is a good start, too.

Actually you cannot reindex the system tables, although there is an s_proc for this with sp_fixindex. sp_fixindex is doing dbcc dbreindex for all objects where object_id > 100 and dbcc...

Would you post the outcome of this when you have solved it?

Great Allen, how can I find out at which point which library is loaded?

BTW, thought I'd mention that xp_regenumvalue is undocumented.

FWIW

Yes, this should quality for the longest in the last months.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=4&messageid=103168

Okay, I found it to be another side-effect when not using IE.

Ok, Mainstream time again.

Hi Thomas,

surely a little bit late for a reply, but here it goes.

Yes, the human brain is the most powerful database around. Curious how the indexes would look like.

Now...

Call me a purist, but I like to keep full control over what I develop. When I started programming using Turbo C (almost forgot the name) there was no such...