The problem is that your date is not really a date. Is a numeric value that will be implicitly converted to a date to extract the year, month and day....

Simply use CONVERT( datetime, TheData) or CAST( TheData AS datetime).

Reference: https://msdn.microsoft.com/en-us/library/ms187928.aspx

FYI, datetime is not stored in any format. The formats are for display and the same value can be shown...

Have you read this article?

https://www.mssqltips.com/sqlservertip/2875/how-to-allow-ad-hoc-updates-in-sql-server-system-catalogs/

Or you can go the other way around. :hehe:

SELECT *

FROM @JOIN_TABLE JT

INNER JOIN @TEST_PK PK

ON ...

Lynn Pettis (8/14/2015)

---

True, but not every RDBMS implements them either. What good is a standard...

g.britton (8/14/2015)

---

I just wish it wasn't called a "Tally" table. I don't tally things, I count them. fwiw I usually call my "tally" table "N" to reflect it's relation...

Lynn Pettis (8/14/2015)

---

g.britton (8/14/2015)

---

to get enough numbers to...

Well, the point is that...

Ed Wagner (8/14/2015)

---

crookj (8/14/2015)

---

BL0B_EATER (8/14/2015)

---

Ed Wagner (8/14/2015)

---

SQLRNNR (8/13/2015)

---

Ed Wagner (8/13/2015)

---

DonlSimpson (8/12/2015)

---

SQLRNNR (8/12/2015)

---

Luis Cazares (8/12/2015)

---

WayneS (8/12/2015)

---

Ed Wagner (8/12/2015)

---

Ed Wagner (8/12/2015)

---

SQLRNNR (8/12/2015)

---

whereisSQL? (8/12/2015)

---

Ed Wagner (8/12/2015)

---

Eirikur Eiriksson (8/12/2015)

---

Ed Wagner (8/12/2015)

---

Steve Jones - SSC...

Small correction, they're not there for backwards compatibility, but for SQL Standard compatibility.

I agree with everything that Sean said. You need an UPDATE and probably a SELECT. That's when stored procedures come in handy, as you only need to execute one line...

Lynn Pettis (8/13/2015)

---

For the cheaper fares and more flexibility looks like I should fly in and out of DIA instead of COS.

Another question, should I book now or still wait...

I don't have an Oracle database to test against it, but it seems that you can insert and delete rows from Dual if you have Admin rights.

The fun part is...

I realized that I have a lot of free time at work when I'm in the Top Members section for the last 30 days, thinking on writing a new article...

Fill factor is not really defined by the amount of data in the table but on the rate of data modifications.

To generate some tests, I did the following:

IF OBJECT_ID( 'STATE_COUNTY_CODES')...