Ah, looks like you're hitting a Teradata error of some sort. I'm not sure exactly how to get past that one, but if it's the temp table, the bit...

I might be misunderstanding what it is you're trying to do, but I'm guessing you're trying to hold the results of your OPENQUERY execution into a temp table so they...

Joe Garrick (8/15/2014)

---

I've often wondered if other fields have training at that level...

skeleton567 (8/15/2014)

---

Andrew Kernodle (8/15/2014)

---

skeleton567 (8/15/2014)

---

Joe Garrick (8/15/2014)

---

With long hours the norm, downward pressure on wages, most skills being all but useless once they're just a few years old, and more...

allanstarr023 (8/15/2014)

---

@LutzM

It works when i run it direct in the sql server however when i try integrating the sqlsrv function to make it work with my php code it...

skeleton567 (8/15/2014)

---

Joe Garrick (8/15/2014)

---

With long hours the norm, downward pressure on wages, most skills being all but useless once they're just a few years old, and more and more work...

I could be wrong, but I think that's PHP coding; the mysql_query(...) bit matches one of PHP's functions, which prepares and executes a MySQL query against a target server. ...

Ah, I see. Good to know it wasn't intended functionality, and that there's a fix out there. My company is on 2008 R2 SP1, and we're probably never...

Haha, and then there's the power of not knowing what title someone should get 😛

Where I'm at currently, management is very disconnected from the programming group, both in terms of...

D'oh, that was totally unintentional :-P. I guess I've absorbed the ability to subconsciously fire off bad programming puns after trawling these forums enough 😀

Oh, I see! I thought the problem might only come up in relatively niche circumstances with bits, but it looks like it's a lot more widespread than that. ...

Ah, gotcha. If you don't mind, post back here with what you find; I'm intrigued by the problem, trivial though it might be overall 😛

Hrm. I was thinking it might have something to do with the way bit-type columns are stored, too; since they can collectively register as one or two bytes depending...

Huh, I'm getting the same results when I run the query; I don't have Enterprise edition, so I can't compress data anyhow, but I get the -1 bytes message when...

Ah, there could be quite a bit of a reason to manually handle the statistics updates! Here's a Microsoft support article on the issue:

Article

Under the "Determining when AutoStat generation...