Curious -- how large before you'd consider...

WayneS (4/13/2010)

---

If you really need this column in this position (there's really no reason to require this, but ...), then you will need to:

rename this table.

...

IMO, quite a lot...

I think Seth meant to say,

Select MAX(DATALENGTH(yourtextfield)) from yourtablename

The LEN function won't work on TEXT type fields. You need to use DATALENGTH.

How about a Windows command prompt / batch file / scheduler solution?

In Windows 2003/Vista and later, there is the FORFILES command that you can use to cycle through a group...

You...

Paul White NZ (4/7/2010)

---

If your table is relatively small, something like this is simplest:

DECLARE @test-2

TABLE (

ID ...

Questions #1, #2 and #4 are all outlined in BooksOnline and numerous blogs and articles.

Questions #3 and #5 are subjects for all kinds for interesting discussion. No hard and...

Database partitioning is only available on the Enterprise version of SQL Server -- is that what you're running?

I've heard this before so as far as a faster import. So just to clarify, dropping and recreating the index is a quicker process than reindexing the index that's...

You can't use native MS SQL Server tools to do selective backups - you back up the whole database or nothing. (OK, you can back up just the transaction logs,...

[Ignore this post -- how does one delete an accidental double post?]

The GUID may not help, except to insure that you have a unique ID for each record.

The Timestamp field is what you'd need.

Sounds like you're on the right track. Keep...

Great idea, Bhuvnesh, but that won't work when there are no Roman numerals at the end.

JOHN JONES will end up as John JONES.

But you could use your idea to strip...

I'd agree with Andrew. Getting consistent data into an ERP system can be a nightmare if you don't understand all the rules and their nuances.

What ERP system is it, if...

Oops, maybe I missed the point? You say you want to add the new criteria to the WHERE clause. Like this?

WHERE

(cc.ESPNPersonnelAssigned IS NOT NULL)

AND (ISNULL(cc.expDate, GETDATE()) >= GETDATE())

AND (ISNULL(@costCenters,'')='' or...