Sergiy (5/5/2015)

---

Nevin,

Let's get rid of the nonsense.

Here is a real life NZ number:

Micrisoft New Zealand

09-362 5800

To call it from abroad you need to dial

{you country international access code} 64 9...

So now the story has changed from the initial

When you enter a phone number it must be split to the logical parts according to the rules of the country it's...

The where clause is figuring out if the remainder when you divide a number by 2 is equal to 1. % is known as the modulo operator.

As a result,...

Sergiy (5/1/2015)

---

So, we have 2 options:

1)...

I don't dispute that the phone identifies it, but it is the calling function that parses it. It is not stored that way.

Are you executing as 32 bit or 64 bit?

Are you executing right from the catalog or from an agent task or from a query?

Sergiy (4/28/2015)

---

Nevyn (4/28/2015)

---

Or more appropriately it is analogous to storing phone numbers. Usually the formatting is stripped out before storing, but I don't think I've ever seen one stored...

Can you post the XML of the execute SQL task with anything sensitive omitted/renamed?

Ah, the seperators. Did not notice that.

Well then that one gets back to the argument Lynn and Scott were having about ZIP codes and other postal codes.

Or more...

Good point.

But the point being argued was whether you could put a MAC address in a string and have it handle uniqueness properly, and you clearly can, you just...

Do you see a variable that ends up holding the date that gets added in?

Sergiy (4/27/2015)

---

MAC address - is it a string?

By all means - NO!

Compare E8:AB:... and e8-ab-...

These are completely different strings, but they present the same MAC address.

Just another example of an...

I have done something similar in the past. It can get tricky depending on the roles that different logins have though.

Here is what my restore looks like.

I have a...

The answer is going to be row_number partitioning by a datepart of month.

I'd have given you a finished answer, except:

1) You didn't give us a sample in a consumable manner...