We'll see if Lynn's new photo avatar helps him. Little green guy... lots of wrinkles... you know it's rare that you actually guess what someone looks like from talking...

He wrote an article on it actually. See the Running Totals link in my signature.

Ahh... and that one has a link to that "Performance and Integrity" thread. Of course, that particular issue is like 4 steps past this one in terms of WTF-itude.

It's not "one of those talks" if you win =).

Jeff Moden (1/21/2009)

---

Garadin (1/20/2009)

---

Michael Valentine Jones (1/20/2009)

---

In the end, does the reason why really matter?

We had a meeting where we objected to a project as complete waste time and money,...

I figured you did. That's why I didn't whip out any BOL links ;).

Decimal 8,2 means you have a total of 8 digits, not 8 to the left of the decimal point. Therefore, if you break a million (7 digits, you only...

Try running this query.

SELECT I.item_no,I.std_cost,I.loc, C.HBG_std_cost

FROM HBG.dbo.IMINVLOC_SQL I

LEFT JOIN FT.dbo.Std_Cost_Compare C ON I.item_no = C.item_no AND I.loc = C.HBG_loc

A bit easier to read than yours. You're getting fewer...

Michael Valentine Jones (1/20/2009)

---

In the end, does the reason why really matter?

We had a meeting where we objected to a project as complete waste time and money, and were trying...

Lynn Pettis (1/20/2009)

---

I thought about this, but the OP's post didn't indicate that the PK (int column) was defined as an identity column. With out that info,...

You cannot use SELECT INTO twice within a script even if you wrap it in an IF. You need to create your temp table first, then use INSERT INTO...

Probably should have clarified. That returns the last used identity value from your table and adds 1 to it. That may not be what you actually want. ...

SELECT IDENT_CURRENT('yourtablename')+1

We still use 2K in production. A lot of companies that have highly customized software packages built on earlier versions have a very hard time upgrading.

Yeah, definitely read that one too quick. Sorry for the bad answer Jon.