That tally table is neat. I'm going to try and figure out how to apply this to my table. It is about 300,000 rows.

It is a varchar(5500). There are 300,000 or so comments (rows).

I've been away from the computer most of the weekend (a first for me). Lots of interesting solutions. The simplicity of the code stuns me. Thanks!

simplicity may...

http://en.wikipedia.org/wiki/Enterprise_Manager

OK, looks like Enterprise Manager went away in SQL 2005.

New question:

Other than database size issues, is the Express version totally functional? Thanks.

I'm not sure I understand your question. Is all that data in a single field? If yes and all you want to do is import it and add...

Thanks for your response. I'm out of town so not near my SQL box to try this. Wouldn't I need the UDF also? Thanks.

I reloaded sql server service pack 4 and it quit crashing.

I figured it out, I need to add WITH NO_INFOMSGS.

Backup LOG R2008 WITH NO_LOG

DBCC SHRINKFILE ('R2008_log',1,TRUNCATEONLY) WITH NO_INFOMSGS

BUT your point is a good one. I had an issue running...

Thanks that works!

I didn't copy my bulk insert code over correct. My Row Terminator needed to look like this:

WITH (FIELDTERMINATOR = ''","'', ROWTERMINATOR = '''')'

All is fine now!!

YIKES I'm lame!

Why not do this, makes it simple?

Set up a table in my database called "DatabaseNamed" with a field "MyDatabase" (I put the database name there I want...

I should add, I really don't want to pass the parameter from the application. Basically I'm thinking when I need to point this elesewhere, just edit a statement in...

This is usually pretty obvious but could be overlooked.  I was on a friends SQL machine and noticed SQL was not configured to take advantage of a memory upgrade. 

Thanks, very creative ans simple to understand.

I was setting the default as zero, so it would be zero.

Actually these account numbers have alphas in

them.  I didn't realize there could be a case

in a sort, cool.

This code below does not work, but this is

what I'm after.  Thanks again!!

SELECT...