Do your ALLOC_PROPOSED & MPS_PROPOSED have any clustered indexes at all ? I was wondering why you didn't make your primary keys clustered ?

Also, if the # of rows...

Have you tried running the index tuning wizard against this ?!

sqlindia - I don't think you've addressed ron's question...which of the 2 or many roles would you want displayed ?

Look up sp_dropdevice in BOL...

Is the registrations table the only one throwing up this error ? Have you queried the other tables with varchar columns with no problem ?

Yes you can - if you right click on the table and click on import - the wizard comes up & you can select foxpro as your data source from...

Read up on bulk insert on BOL....

BULK INSERT [ [ 'database_name'.] [ 'owner' ].] { 'table_name' FROM 'data_file' }

[ WITH

...

Remi - here's an interesting link considering you just said that you wanted to be called Neo/Luke...

http://news.yahoo.com/s/zd/20050519/tc_zd/152359

Enjoy the break!

Long live the Queen.....(or at least holidays in her name!!!)

Remi - my response was only to correct the update that I originally posted - not a solution to Alex's problem (which in any case you have resolved in your...

Remi - apologies for the delay (that darn thing called work keeps interrupting) - yes, you're right (surprise! surprise!) - that does return all the nulls...

I was confusing it with...

Ananda - pl. follow this link for comma separated list...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=174305#bm174355

OOPS - Like Ron K. said yesterday - should learn to type faster!

Seems to me you should add another clause to this:

UPDATE Ticketing SET TicketPriceExVat =

(SELECT TicketPriceExVat FROM TempTicketing

WHERE TempTicketing.EventID = Ticketing .EventID

AND TicketPriceExVat IS NOT NULL)

Here's something to get you started - these will give you a list of computed columns from all the user tables:

SELECT syscolumns.name FROM syscolumns

JOIN sysobjects ON sysobjects.id = syscolumns.id

AND...