There may be a...

Jeff Moden (5/24/2008)

---

Heh! C'mon... I don't wear the hat in public... and...

Jeff Moden (5/23/2008)

---

Oh heck no... those are two 8 hour days... gotta earn a living and a book isn't likely to be a great source of income... HEH! If...

jsheldon (5/23/2008)

---

The staging area is the table it is going to...bad ERP desgin what can I say.

So my raw source goes to project_jrnl_load_trans and then the process moves it to...

You're welcome!

Mauri:

%

Yes - that's right. That's the Modulo operator.

14 % 8 = 6

One small note. For better or worse, Microsoft allows the modulo result using the same sign as...

ALZDBA (5/22/2008)

---

I've also interpreted thesqlgurus comment as non-personal, but a pointing to a practise that arises more and more.

Companies should learn sqlserver is way more than an enhancement of msaccess...

thomas.lemesurier (5/23/2008)

---

Hi and thanks to both of you for your replies. I have seen the 'auto refactoring' thing before and was under the impression that it didn't change the meaning...

The query editor sometimes refactors things in a way that "makes sense" to it. From the looks of it - both statements are logically the same, so I don't...

Jeff Moden (5/23/2008)

---

Heh... just imagine me writing a book... 11 pages every 2 days... it would take an eon for me to write one. I don't know how some...

Sabina Yasmin (5/23/2008)

---

I tried to delete rows from a table with inner join with another table based on keys. But I am unable to do that. Here what am I...

1. Define them as outputs in the script component. After adding the script component, right, go into Edit, then inputs and outputs, and add the output names you want....

It does - just keep in...

Jeff Moden (5/22/2008)

---

Sorry... didn't mean to get you excited. 🙂

"Flag" a post, in this case, meant that I save the URL for the post in my "Things to follow up...

The point of OUTPUT is to capture the results from an INSERT/UPDATE/DELETE statement and use...