So, the table is "tblJob" in the first query (in the OBJECT_ID function-call), but it's "tblWorkOrder" in the second query. Is that intentional?

Thanks! 🙂

The really funny part is, there was a noticable increase in people assuming my...

Luis Cazares (9/12/2012)

---

Wouldn't that be cheating?

Because that way I can...

I'm not accustomed to quotes around the stat name. Try it without those?

Edit: Never mind. Just tried it and it worked.

Are you sure you don't have a typo...

Here's what I came up with. Does the same thing the same way, just another way to write it:

WITH Numbers

...

And of course, we overlapped post-timing.

I just set up this test harness:

CREATE TABLE dbo.tbl (ID INT, A BIT, B BIT, C BIT);

GO

ALTER TABLE dbo.tbl ADD CONSTRAINT DF_tbl_A DEFAULT(0) FOR A;

ALTER TABLE dbo.tbl ADD CONSTRAINT DF_tbl_B...

Have you checked to make sure there are no triggers being fired by the updates, or anything like that?

I'd have to see the table definition (create script) before I could...

Is the column returned by the query ASCII or UniCode (char or nchar)? I think I've seen that cause this error before.

It depends on what they mean by "numbers with no math".

Storage-wise, character data is more expensive. TinyInt can store numbers 0-255 in a single byte of data, but 1...

Lynn Pettis (9/11/2012)

---

GSquared (9/11/2012)

---

Lynn Pettis (9/11/2012)

---

Here is a bit of code that returns what you are looking for:

declare @TestDate date = '2012-09-11';

with SevenRows(n) as (select row_number() over (order by (select...

RBarryYoung (9/11/2012)

---

GSquared (9/11/2012)

---

SSIS has an FTP object that can be used to automatically download the files. Won't work if it's FTPS, but will for FTP. Will that work...

Lynn Pettis (9/11/2012)

---

Here is a bit of code that returns what you are looking for:

declare @TestDate date = '2012-09-11';

with SevenRows(n) as (select row_number() over (order by (select null)) - 1...

SSIS has an FTP object that can be used to automatically download the files. Won't work if it's FTPS, but will for FTP. Will that work for you?...

A and B are equivalent under the hood. Your friend is correct that they work the same way. You can usually see that if you look at the...