-- Prepare sample data

DECLARE @Sample TABLE (Dept INT, Time INT)

INSERT     @Sample

SELECT     8, 907 UNION ALL

SELECT     8,...

Thanks!

update FSA_EXPORT_TEMP WITH (ROWLOCK, INDEX(<index name here&gt)

set trading_partner = 'XXX'

where reporting_date = @reporting_date

and fsa_le = @fsa_le

and transfer_le like '%%X'

and sp_id =@sp_id

ORDER BY

--TopLevel Sort

CASE

WHEN @SortBy = 'SaleDate' THEN convert(varchar(10),TradeDate,102)

WHEN @SortBy = 'AccountName' THEN AccountName

WHEN @SortBy = 'Symbol' THEN Ticker

WHEN @SortBy = 'SecDesc' THEN Description

WHEN @SortBy IS NULL THEN Description

ELSE NULL

END...

Median per dept?

Didn't you see the technique I used with row_number() function...?

-- Prepare sample data

CREATE TABLE #Movies

(

MovieID INT IDENTITY PRIMARY...

With the test data posted above, what is the expected result?

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=22242

Last post be me is about SQL Server 2005.

Start with the code above and go from there and use DYNAMIC SQL to automate this process.

How are you else going to check that some of the films you are going to show, not already has been shown?

SELECT CASE WHEN COUNT(DISTINCT Col1) = COUNT(Col1) THEN 'All unique' ELSE 'Some duplicates' END

FROM Table1

Hmmm..

ISNUMERIC('$1') = 1

ISNUMERIC('1E5') = 1

ISNUMERIC('1D0') = 1

ISNUMERIC('$1.8') = 1

Ingen fara och lycka till.

Är det något mera så "post sample data and expected output" så det blir lättare för oss att förstå vad du är ute efter.

Are you talking about PAGING?

You want 10 records at a time (one fo each type) on a "page"?

When you click "next" you want next 10 records (all again of different...

-- Prepare sample data

DECLARE          @Events TABLE (StationID INT, EventDateTime DATETIME, EventTypeID INT, Version INT)

INSERT           @Events