Jack Corbett (1/26/2012)

---

Okay, Jason don't report me. Just found this in an SP:

IF 1 = 1 -- Placeholder in case there is an actual conditional on this...

Koen Verbeeck (1/26/2012)

---

GSquared (1/26/2012)

---

It's not an IMEX issue. Those cause NULLs instead of text/numeric data, depending on which one it thinks the column is based on a 4-row sample....

Honestly, you're going to have to go with two (or more steps). Do a Merge into the UsersAuth table using a join between your staging table and the Users...

SQLRNNR (1/26/2012)

---

GSquared (1/26/2012)

---

Brandie Tarvin (1/26/2012)

---

Well, that explains a few things.

Humor for the day. I just gave a speech at our workplace communications club based on a blog...

It's not an IMEX issue. Those cause NULLs instead of text/numeric data, depending on which one it thinks the column is based on a 4-row sample. They don't...

The only way I can think of to divert an insert from one place to another would be to do the Merge command on a View that queries both tables,...

There's another problem with the stored procedure definition in the first post. "Return" in procs can only work with integer values. It can't return strings, but it's defined...

Brandie Tarvin (1/26/2012)

---

Well, that explains a few things.

Humor for the day. I just gave a speech at our workplace communications club based on a blog post I...

Encrypt your input parameters using the same encryption method as you data. Compare the encrypted parameter value to the encrypted column value in your Where clause. That should...

Okay.

Here's one way that might make this more efficient:

IF OBJECT_ID(N'tempdb..#raw') IS NOT NULL

DROP TABLE #raw ;

CREATE TABLE #raw

([tableID] [int] NOT NULL,

...

The lack of a proper dev environment is the real problem, most likely.

Lots of companies, perhaps most, have policies in place that only the DBA has access to production database...

Stefan Krzywicki (1/25/2012)

---

Evil Kraig F (1/25/2012)

---

SQL Kiwi (1/25/2012)

---

Steve Jones - SSC Editor (1/25/2012)

---

SQL Kiwi (1/25/2012)

---

If we had ever met in...

jcrawf02 (1/25/2012)

---

Steve Jones - SSC Editor (1/25/2012)

---

SQL Kiwi (1/24/2012)

---

I tried snowboarding once (in a supervised inside environment[/url]) and that was enough to...

Okay.

8950 isn't a valid Zip code, but I get the idea of what you're saying.

Are there potentially fields with numeric data in them that might mimic a Zip code, but...

Judging by the business rule, one cancellation matches up to one and only one regular transaction, and a regular transaction can have zero or one cancellations, but not more than...