Is it better to do this with SQL or C# ?

I have the table running in memory via C# and the initial load takes 52 seconds, then each count, as...

Kevin,

You are correct!

I am not sure on the best way to do this.

Based on the Microsoft Outlook scenario, i assume you would need one SP for each of...

Thanks

Thanks

I was trying to provide something simple as a 'proof of concept'. Here is all the code. Thanks

USE [Testing]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- ============================================= ...

So the 'Row Number Order By' statements are not enough?

Is there a way to fix this either in the query, or by inserting a nanosecond time loop in the data?

Thanks

Based on research and the lack of response, i guess it can't be done in SQL.

Let's try C#.

Rvadim,

CONVERT(char(8), posteddate, 112) + companydid

That seemed to work 🙂

Many Thanks !

I will keep doing some testing.

Guys,

I would like the data sorted based on a derived field which is created by 'posteddate + companydid' in either asc or desc order.

Doing so with posteddate , companydid does...

USE [NewTable]

GO

DECLARE@return_value int

EXEC@return_value = [dbo].[zzNewTable2]

@fromRec = 0,

@toRec = 9,

@OrderType = N'asc',

@OrderBy = N'posteddate'

SELECT'Return Value' = @return_value

GO

To run the SP.

USE [NewTable]

GO

/****** Object: Table [dbo].[NewTable2] Script Date: 4/12/2014 10:13:52 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[NewTable2](

[ID] [int] NOT NULL,

[CompanyDID] [varchar](20) NULL,

[PostedDate] [datetime] NULL,

...

PostedDate Field – datatype - Datetime

2014-04-10 00:00:00.000

2014-03-10 00:00:00.000

2014-02-10 00:00:00.000

2014-01-10 00:00:00.000

2013-12-10 00:00:00.000

2013-11-10 00:00:00.000

2013-10-10 00:00:00.000

2013-09-10 00:00:00.000

2013-08-10 00:00:00.000

2013-07-10 00:00:00.000

CompanyDID Field – varchar(20) – Datatype

FHN4297773M82WK6J14

FHN4297773M82WK6J14

F8D33G78FQVXYHWV67X

F8A0FY6ZSBV7RPS9SVJ

FHT2JB6FTZFW61ZCDNW

F8C1MZ6RS45GV1YYNBB

FHR7NT6GGKHCVBT63SR

F8H77J70FFB41YYGRSS

F7G7JJ77NVMSHQ4FCTZ

FHN2T072MQFGWW5ZBR6

i want to order the data based on...

I even tried this

"Syntax: PARSE ( string_value AS data_type [ USING culture ] )"

SELECT top 10 PARSE(companydid as int) from cb

without success.

What i want to do is change...

What datatype is @OrderType? Assuming it's a VARCHAR - correct.

I changed the PostedDate datatype back to DateTime, and decided to try to convert the DID string to an int.

Companydid is...

Thanks !