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)

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)

select top 1 ... order by order_date desc

Try changing:

+ 'Use ?

to

+ 'Use [?]

Several presenters at conferences do. They either have it set up as a dual-boot, or run it under a VM. However, it CANNOT be installed on the Mac OS -...