CELKO (4/24/2015)

---

Of course there is, since you can cast the number to a string any time you want, although you'd never need to compute a check digit that's already...

You could also do searches for similar jobs and see what their job descriptions look like. After all, one of the greatest documents in history, the "Declaration of Independence",...

CELKO (4/23/2015)

Getting back to check digits, the encoding has to be in a string because the weights are assigned by position. There is no concept of a position in an...

CELKO (4/23/2015)

---

The ISBN is atomic; it...

I believe the code needs slight corrections to prevent a match on part of the code value rather than whole value, as demonstrated below:

CREATE TABLE #ids(id int, codes varchar(30))

CREATE TABLE...

CELKO (4/23/2015)

---

ISBN is displayed with dashes for human convenience, but it's actually composed of elements .. again, under the rules for 1NF, each of those should be stored...

Bill Talada (4/23/2015)

---

ScottPletcher (4/23/2015)

---

Stripping out delimiters should never eliminate information from the data. If you need to, you can set a tinyint code that reflects the meaning of the...

Lynn Pettis (4/23/2015)

---

ScottPletcher (4/23/2015)

---

Stripping out delimiters should never eliminate information from the data. If you need to, you can set a tinyint code that reflects the meaning of the...

Stripping out delimiters should never eliminate information from the data. If you need to, you can set a tinyint code that reflects the meaning of the delimiters. I'm...

If you remove the "AND jh.step_id =0" you can see the steps that have completed.

But "step 0" can't be posted until the whole job completes, since that is the job...

The step is not posted in sysjobhistory until it completes. If the job is still running, you will get the previous job.

If you need to get only the last...

DOUBLE DOH! I just noticed I left of the step# check in the code; please add this to the WHERE clause:

AND jh.step_id = 0

That code is checking for the...

ZZartin (4/23/2015)

---

ScottPletcher (4/23/2015)

---

Lynn Pettis (4/23/2015)

---

ScottPletcher (4/23/2015)

---

Lynn Pettis (4/23/2015)

---

CELKO (4/22/2015)

---

Please read any book on basic data modelling and look...

Lynn Pettis (4/23/2015)

---

ScottPletcher (4/23/2015)

---

Lynn Pettis (4/23/2015)

---

CELKO (4/22/2015)

---

Please read any book on basic data modelling and look at the...

Lynn Pettis (4/23/2015)

---

CELKO (4/22/2015)

---

Please read any book on basic data modelling and look at the chapters on scales...