Technically, the clock "advances" from 01:59:59.997 (however many decimal positions you want to use) to 01:00:00.000. 02:00 is only...

We're having an outage this weekend when we're upgrading to SQL 2008... I plan on using this time to do this.

Does this help you out?

declare @test-2 TABLE (RowID int IDENTITY PRIMARY KEY CLUSTERED,

...

Well, it looks to me like you are going to have to get your mapping by an aggregate query against the base table (or, if it is being pushed into...

From your first post:

So, purchase price (p.Price) minus sale price (s.Price).

It definitely seems to me that the "profit" would...

Well, you didn't give us any sample data (in comma-delimited format) to play with, so all I can do for you is to point you to this: Click here for...

From what I can gather, for each entry in t, you want to have a result of t.id, and the minimum t.id where t.col = inserted.col - correct?

In order to...

Is this what you're talking about?

-- declare and initialize variables

DECLARE @StartDate datetime,

@EndDate datetime;

-- get first of year three years ago

SET @StartDate =...

You didn't specify a few things that I'm assuming.

First, you want to split the string apart at the spaces.

Second, you only want items from the split that contain an underscore.

This...

Sounds like you need to use a Conditional Split

Jeff Moden (11/1/2010)

---

ps. (10/29/2010)

---

You have already gone through the places where i would have gone to search for that answer:-P. I would probably do what Kimberly says. like shrinking it...

Duplicate post. Please do not respond to this thread; please respond to this thread for all responses.

In a dual-boot situation.

Craig Farrell (11/1/2010)

---

There's a couple of different techniques and approaches to this and I don't want to give you an over-complicated one if unnecessary. You've posted in the 7.0/2k...

select top 1 ... order by order_date desc