NEWID() is guaranteed to be unique within the database.

This gives two hints. Date and Time is involved and so is the Database name.

Others are (by rumour) MAC address, bios information...

We have to wait for OP to return with results.

And about NEWID() as random generator? We have had several tests (incluing me, Jeff and Michael) to see if ABS(CHECKSUM(NEWID())) generated...

DATETIME is a FLOAT? Since when?

I thought DATETIME was a 64-bit binary integer value, where the lowest four bytes is the data portion, and the higher 4 bytes is the...

Yes, when I used ODBC 256 characters was the default max length of returning strings.

Changing to the newer OLEDB solved that problem.

Well, the sample data was ordered so I thought this was the case in production environment.

Now OP finally seems to have released all information necessary.

-- Prepare sample data

DECLARE    @Sample TABLE (RowID INT IDENTITY(1,1), col1 int, col2 int)

INSERT     @Sample

SELECT     1, 1 UNION...

This is a view I often use

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

And the wonder of Google cache!

The magic of post editing...

select  bookingsource,

  bookingtype,

  operatingunit,

  avg(dailyrate) as average

from  (

   select bookingsource,

    bookingtype,

    operatingunit,

    row_number() over (partition by bookingsource, bookingtype, operatingunit order by dailyrate) as sort_asc,

    row_number() over (partition by bookingsource, bookingtype, operatingunit order by dailyrate desc) as sort_desc,

    dailyrate

   from testmedian2

 &nbsp

DECLARE

@TCOUNT INT,

@BARCODE VARCHAR(100),

@NEWBARCODE VARCHAR(100)

BEGIN

DECLARE CFB CURSOR FOR

SELECT BARCODE FROM FOLDERSBOX ORDER BY RECORDID FOR UPDATE OF BARCODE;

OPEN CFB

FETCH FROM CFB INTO @BARCODE

WHILE @@FETCH_STATUS = 0

BEGIN

EXEC [dbo].[SPGetNextSequence] @TABLENAME = N'FOLDERSBOX',...

Running Carr's suggestion reveals that the movies are always the same for every genre.

Why? Because there is a clustered index on MovieID. That means that TOP 1 always return the...

Also asked here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=87234

I don't think you can reseed table variables.

CREATE

table #table (primary_key INT IDENTITY(1

SELECT     d.TopicID,

           d.LastPosterID,

           d.PostDate

FROM       (

                      SELECT     TopicID,

                                 LastPosterID,

                                 PostDate,

          ...