Re: ordering an int column

The relevant table structure is
col 1 -type datetime
col 2 -type int

In Enterprise manager, I've created a two column clustered index
with col 1 as the first column of the index in desc order
and with col 2 as the second column of the index in asc order

When I open the data, for a common date, it orders the data
1,10,100,2,20,200 etc.
Rick

.

Relevant Pages

  • Re: Cursors... whats the alternative?
    ... Exit Sub ... Dim oCmd As Command, param As Parameter ...
    (microsoft.public.sqlserver.programming)
  • Re: try...catch execution issue
    ... declare @ii_LinkedServerID int = 1 ... declare @ii_LinkedServerID int = null ... CAST(0x00009C5D00904037 AS DateTime), N'dcaz\couchj', CAST(0x00009C6100ADA6DB ... This procedure is used to insert/update a ServerOption to ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Server Functions
    ... CREATE FUNCTION FN_IMS_RX_ITEMS (@DateTimeOfExtract DATETIME, ... > @DataSupplyGroup INT) ... > DispensedPIP INT, ... > LEFT OUTER JOIN ...
    (microsoft.public.sqlserver.programming)
  • Re: Scanning hard drive
    ... "Bela Istok" wrote in message ... public DateTime LastAccess; ... public int ParentFolderRowID; ... public bool ScanFolder(string folder, int folderID, ref double psize1, ref double psize2, ref double psize3) ...
    (microsoft.public.dotnet.languages.csharp)
  • Rewrite Query for tuning.
    ... The Query returns rows. ... CONSTRAINT PRIMARY KEY CLUSTERED ...
    (microsoft.public.sqlserver.programming)
Loading