Please see this thread for what is required from you

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Will this do

select * from #temp order by case when isnumeric(response)=1 then convert(integer,response) else 99999999999 end,response

Hard to say exactly ,could be multiple factors involved , not least the amount of data sent to the client. post the SQLPlans.

Also, are you having unrealistic expectations of what can be achieved?

What would be an acceptable time-scale for the execution?

How can are you away from that now ?

What...

Also datediff counts boundaries, not calendars

try this

select datediff(yy,'31dec2009','01jan2010')

scziege (7/20/2009)

---

My Problem is that my base table has 130 Million codes

and I have to check if the created 100 Million codes a unique

against my 130 Millions codes and itself.

Therefore...

He's subtracting the hours and minutes from the present to 'floor' it ie get the midnight datetime of today.

It better achieved by 'DATEDIFF(DAY,0,@Date)', that accounts for second and milliseconds...

When you read statements like

http://www.sqlservercentral.com/Forums/Topic755603-9-1.aspx

Is it just me who internally screams , UNDERSTAND WHAT YOU...

Its just simple maths!

If you have the id's 1 thru 10 and you want to update them to 11 thru 20 you just add 10 to the id , yes?

If...

From what you've said:

Update scoretable

set score_id = score_id- 28323

where score_id between 28324 and 32768

will do what you need...

I...

From the example you've given, it would look like using MAX would suit you needs.

However from the description you seem to need more and need to filter on rownumber()

heres an...

Please see this link[/url] on how to post performance issues...

Are all your statistics upto date ?

The actual row counts differ vastly from the estimates.

Heres all you need to know about dates in Sqlserver

http://www.karaszi.com/SQLServer/info_datetime.asp

Tara (7/17/2009)

---

as i said most of the time we only do SELECTS on the databases...