Perhaps this?

CREATE TABLE #Numbers (ID int, Number int)

INSERT INTO #Numbers

VALUES (1,20),(2,11),(3,20),(4,8),(5,11),(6,4)

SELECT number, COUNT(*) AS NumberCount

FROM #Numbers

GROUP BY Number

ORDER BY NumberCount desc, MIN(ID) asc

DROP TABLE #Numbers

Cheers!

It could be the issue Luis pointed out, or it could be something else, like your data not matching what we're guessing it looks like.

If you could provide a sample...

Something like this?

CREATE TABLE#alpha_numerics(alpha_numeric VARCHAR(30))

INSERT INTO#alpha_numerics

VALUES ('234'),

('23f5'),

('7689'),

('Hey!'),

('58-Fr')

SELECT*

FROM#alpha_numerics

WHEREalpha_numericNOT LIKE '%[^0-9]%'

DROP TABLE#alpha_numerics

Cheers!

I assume FeedName is the name of a column in Alert.Export_Files.

Check out the cautionary notes here: https://technet.microsoft.com/en-us/library/ms178050(v=sql.105).aspx

This is a common source of confusion, and an excellent reason to explicitly...

Those dates in my earlier query weren't binary.

Since you didn't say what data types any of the columns were and your sample data only showed dates (no times), I created...

Your adaptation of the query to your actual data must have changed it, then, because the query I provided does not behave that way with your sample data.

You'll have to...

The SELECT I have in there is code to do it without a temp table.

I create a temporary table and populate it with your sample data so it is in...

Perhaps something like this?

CREATE TABLE #Temp (code CHAR(2), code_status CHAR(20), code_date DATE);

INSERT INTO #Temp

VALUES

('AA','Infringed', '20150101'),

('AA','Not Infringed', '20150102'),

('BB','Infringed', '20150105'),

('BB','Not Infringed', '20150105'),

('CC','Infringed', '20150110'),

('CC','Not Infringed', '20150101'),

('CC','Not Infringed', '20150110');

SELECT code FROM #Temp

GROUP BY...

Perhaps this?

SELECT*

FROMdbo.abc_sort

ORDER BYCASE

WHEN IDNUMBER = 2 THEN ID1

ELSE ID2

END,

name ASC

--IDNUMBER DESC also works for the secondary sort in the sample data

;

The logic seems strange to me, but...

yakko_Warner (12/2/2015)

Where somedatetimefield >=...

Try the DBCC PAGE using dump style 3 instead of 0, 1,or 2. I think that's the catch.

Cheers!

Thanks! 

Remember, to SQL Server, the queries are not the same. Without the IF, the query is asking for the actual count of rows from the view that meet the WHERE...

As pointed out in the article I posted, beginning in SQL Server 2005, the optimizer converts IF (SELECT COUNT...)>0 to an EXISTS under the covers, so I would expect...

In addition to what Sean said, the execution plans for the queries would be good to have as well.

Beginning in SQL Server 2005, the optimizer converts IF (SELECT COUNT...)>0 to...

The INNER JOINs to both aliased versions of #TEST are joining on equality with the TestID from #Patient, which means each row will have the same Test (either Potassium or...