I like the Red Gate intellisense more than the SSMS default, but I have to admit, they both get in the way as often as they help, till you get...

Interesting.

That means there's something going on in the application or its connection to the database.

SQL Server stores dates as decimal numbers. Left of the decimal is the number of...

Stefan Krzywicki (12/16/2010)

---

GSquared (12/16/2010)

---

Brandie Tarvin (12/16/2010)

---

So, I have this query that yesterday is working fine and quick when I left outer join three tables. But when I change them over...

I tend to use GetDate() because of habit, but I have to admit, Current_Timestamp is more expressive of what it does, more intuitive to a person who isn't already indoctrinated...

Format inputs in ISO style, and you won't have any problem with it.

Are dates being fed to the database as strings, or as date-time data? How does the application...

Does the table have some sort of "this rows was inserted at this time on this day" kind of column? Or at least an ID column for sequence?

Congrats to both of you!

I can't open Office documents from a non-secure source. Can you provide the table definitions and sample data as DDL statements and insert statements?

Brandie Tarvin (12/16/2010)

---

So, I have this query that yesterday is working fine and quick when I left outer join three tables. But when I change them over to inner joins...

Luke L (12/15/2010)

---

GSquared (12/15/2010)

---

Kit G (12/15/2010)

---

Lynn Pettis (12/15/2010)

---

I'm not in a position to test, but don't you get the same issue when using decimal(19,4) as you do when usinf money?

Now...

Glad you worked it out. Good job.

Why separate tables for each of the code types? Why not one table, with a column that indicates which type of code it is?

Also, why not a table for...

You're welcome.

You're welcome.

Have you tried changing the settings in Excel? That's where the actual formatting takes place.