Sean Lange (8/11/2015)

---

Alvin Ramard (8/11/2015)

---

Sean Lange (8/11/2015)

---

Alvin Ramard (8/11/2015)

---

Sean Lange (8/11/2015)

---

OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with...

Welsh Corgi (8/11/2015)

---

I striped the script down and it works.

It lacks Transaction, try, catch etc.

It also lacks the WHILE Loop and the commit size.

DECLARE @ArchiveDate DateTime

SET @ArchiveDate = '2002-01-01'...

Sean Lange (8/11/2015)

---

Alvin Ramard (8/11/2015)

---

Sean Lange (8/11/2015)

---

OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50....

And...

Ed Wagner (8/11/2015)

---

Sean Lange (8/11/2015)

---

Ed Wagner (8/11/2015)

---

The silver spoons need to be ordered again. Better get at least a case.

Here's a quote I don't think I've every seen before:

Unfortunately...

Take a look at this. It may not be exactly what you need, but it's a start.

CREATE TABLE #test

(

createdon datetime,

kms_quoteorder varchar(15)

)

INSERT INTO #test VALUES ('2015-06-10 14:03:04.000',NULL)

INSERT INTO #test VALUES...

Sean Lange (8/11/2015)

---

Ed Wagner (8/11/2015)

---

The silver spoons need to be ordered again. Better get at least a case.

Here's a quote I don't think I've every seen before:

Unfortunately I get...

This is a very messy query to right. If only the Rev # had a leading zero when necessary, then this would be simple.

Would also be much easier,...

Ed Wagner (8/11/2015)

---

The silver spoons need to be ordered again. Better get at least a case.

Here's a quote I don't think I've every seen before:

Unfortunately I get your code...

What's the maximum number of digits that the number after REV can be? Will it always be an integer?

lcarrethers (8/10/2015)

---

The NULL is a real NULL

and I'm expecting the max kms_quoteorder

so if there are no /REV then I should only see the number.

The /REV stands for Revision. ...

If you plan to use SSIS for more than just the basic stuff then you must take the time to learn how to use SSIS.

Break down your problem into it's...

GilaMonster (8/10/2015)

---

You can do it, but it is not a good idea. It's liable to cause you problems down the line. Just write one proc for insert, one for update,...

Sean Lange (8/10/2015)

---

SQLRNNR (8/10/2015)

---

At least until...

Overcomplicated this thread has become. Weak was the force.