You say you've been experimenting with Min/Max as well?

Here are two equivalent expressions

declare @MinDate datetime

Select @MinDate = Min([date])

from dimtime

Select top 1 @MinDate = [date]

from dimtime

order by [date]

Turn on the execution plan, and SET STATISTICS IO ON to see whats going on.

Is there a reason that the money or smallmoney datatypes aren't good enough for your purposes? Please correct me if I'm wrong, but the money datatypes are "fixed point" numbers...

Does your table list really change that often that you need to do this dynamically? It looks like you are trying to copy data from all tables that have a...

You can right click on a database in the 2005 management studio, go to reports, standard reports, then choose the Schema Changes History report. However, I'd love to know what...

I believe we changed the collation at the DB level. I just did a quick test where I had a table with a varchar PK, changed it to a case...

So is this a custom built system, or are you modifying an off the shelf product?

I'm making a few assumptions here:

1. You know how to identify "top level" items.

2....

Here's another SQL Server "quirk" I ran into when we were converting a DB2 database to SQL 2005. We made the collation case sensitive, because we were loading data, and...

I usually do the following:

Right Click on Query

Query Option | Text

Switch to comma delimited

change results window to text

run query

Right click in results window

save results as csv

Open in Excel

I've noticed this too, with much frustration. I think the reason is because behind the scenes, the new Enterprise Manager uses SMO to generate scripts. At any rate, are you...

That is because it is inside of your string. When you execute the dynamic SQL string it executes in a seperate context than your outside query, so if you want...

There is no "just date" data type in SQL Server. There are datetime, and smalldatetime, both of which store time portions. If you simply assign a value like '1/1/2007' to...

Can we see your case statement? Normally when we pivot, we include an aggregation along with a grouping to eliminate the values that were excluded in the case statement. I...

Look up the SET IDENTITY_INSERT statement in BOL

Jeff,

Thanks for the interesting challenge. I mentioned the PIVOT operator, because I had seen it in the docs as a cross tab operator. However, it is something relatively new, and...