jacob sebastian (6/3/2010)

---

I think Matt has put forward a very interesting point. Not being an web developer, I did a Google search and found this thread which talks about a...

Mike - Melbourne (6/2/2010)

---

I'm going to agree with Andrew - my time is a sunk cost to the business. Purchasing some other tool, even though it may present a more...

The answer is to scan it BEFORE it gets to the DB. Once you have them in, you shouldn't scan the internal volume like has been mentioned before.

Just like...

Depends on how big things are, etc... That said - the time you end up save is how long it take to build BEFORE you start writing. Since this...

Here are some class handouts going over some examples of this exact scenario:

It's a big document, so scan for streamwriter:

http://www.google.com/url?sa=t&source=web&ct=res&cd=3&ved=0CBkQFjAC&url=http%3A%2F%2Fsharepoint.ssw.com.au%2FTraining%2FUTSSQL%2FDocuments%2F2010Feb%2F04%2F04_SQLCLR_Lab.doc&ei=CbgHTJKlEMT48AbW_ujGAQ&usg=AFQjCNFapDvEBV3lSWjIPe5XcpJBZWB3TQ

Jeff Moden (5/30/2010)

---

Matt Miller (#4) (5/30/2010)

---

I no longer have a functional version of DTS (my 2K server is history). That said (from memory, so bear with me):

-...

I no longer have a functional version of DTS (my 2K server is history). That said (from memory, so bear with me):

- First would be an ActiveX...

Even if SSIS isn't per se...

floating point is exactly that. It's not a "precise" data type, meaning it won't truncate when you round a float.

You're unsing the wrong data type if you wish...

no - the temp table is a copy, and holds the "correlation" between the old and the new. The join is there to imply tell SQL server which value...

I do have experience with CLR, but building up a huge variable first then trying to pass it to something to export isn't the right way to go. You...

Also - remember that CTE's only exist for one statement (it represents a temporary contruct being used and reused in a single statement). Even if that syntax were valid,...

The problem becomes a LOT simpler if you use a separate temp table to do the renumbering.

Select Id as oldID, Identity(int,1,1) as newID

into #TempTableA

from TableA

order by ID

update TableA

...

Try looking here:

http://www.sqlservercentral.com/Forums/Topic695508-338-1.aspx

Regex (regular expressions) are likely going to be your best bet to take this one if you have "junk" all over your input column. On short columns...

David Portas (5/19/2010)

---

Not sure if CC can...