Yes the N' casts to unicode.

Happy to help.

Good luck with that project.

Let me make this real simple.

Make a vbX app.  Then run this statement :

SELECT OBJECT_NAME(ID) AS ObjectName, Colid, Text FROM dbo.SysComments AND OBJECTPROPERTY(id, 'IsMsShipped') = 0 ORDER BY Object_ObjectName,...

Or actually more like :

update table

set col1 = substring(col,1,50),

col2 = substring(col,51,100),

col3 = substring(col,101,150),

col4 = substring(col,151,200),

col5 = substring(col,201,250)

I asked for sample data because you said the datatype was varchar(50) X 5.

Unless you are sure that all columns used the full 50 characters on every row you in...

NP.

The only small problem I can see is that you can only have 999 batches.  Maybe I'm just paranoid but maybe I'd use 5 numbers so that I could eventually...

Can you post some sample data and the required results so we can know what you need exactly (and point you in the right direction).  Table DDL could be very...

Not really.  The guy I e-mail didn't even read the message yet and there's nothing else I can think of so looks like you are on your own at the...

Can you post the exact link.  The nly 2 ones I found don't do any better than what has been discussed here already... aside from over-validation.

So try adapting my last query to accomodate your actual tables.  Tell us if you need further help after you tried that.

Yup, that should cover it. 

Thanx for keeping everyone posted.

What do you expect from that?

COUNT(*) allows the server to use the fastest access path (will choose an index scan instead of clustered scan whenever possible).

Try this.  This formula is based on the recordid and not the number of records in the "batch".  Tell me if this is not exactly what you need.

ALTER TABLE dbo.myWorktbl

ADD...

Still don't see the need for loops and dynamic sql.  Can you post the tables DDL some sample data and the required output from that data.  I'm sure we can...

Just thaught of a work around.  This is untested because I don't have 2005 installed at home.

Make a reporting table with whatever data the developpers need to see.  Insert the...