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...

CELKO (4/22/2015)

---

How exactly does one compute a check digit on a string-only characters? I don't believe that MC or VISA are spending hundreds of millions of extra dollars on storage...

Orlando Colamatteo (4/22/2015)

---

ScottPletcher (4/22/2015)

---

Orlando Colamatteo (4/22/2015)

---

ScottPletcher (4/22/2015)

---

Orlando Colamatteo (4/22/2015)

---

I'll second the point: definitely store your dates and times in a column of type DATETIME. If you make that a non-negotiable...