You can definitely keep point-in-time pricing in an SQL database. You'd just have a table with, for example, and item ID and a price and an effective date. ...

You're welcome.

Tom.Thomson (12/1/2010)

---

GilaMonster (12/1/2010)

---

You know there's a problem when...

In the last 2 weeks there have been three resignations at current client:

The senior developer (leaving only 2 permanent developers)

The Chief...

Brandie Tarvin (12/1/2010)

---

GSquared (12/1/2010)

---

Which reminds me. Jack, I work in Orlando now. Let me know if you want me to present anything to your group again this winter....

My resume is put together as a marketing...

You're welcome.

You'll have to have something that tells the code which tables are related to which other tables, and how. You could store that as an XML structure, or pass...

Okay. I get it. What you need then is a column added to the view (either directly added to the view or in a query that includes the...

As mentioned, there's data the system loses when you restart SQL Server. Nothing that matters too awefully much, but some of it does matter. Plan use, for example,...

You're welcome.

Lowell (11/30/2010)

---

she could install Enterprise edition again on the production server as a new instance, and not be out of compliance with the license, right?

if the server was beefy enough...

Tom.Thomson (11/30/2010)

---

When I see things like...

Or use "nullif(i.col,d.col) is not null",...

If you output the format as if it were a CSV (commas and quotes), and put an xls file extension on it, Excel will open it without complaining. I've...

I posted a possible real-world example as a reply in the original thread with the weird join. I think it would be a legit use of either query structure,...