Drop the ORDER BY, can't order subqueries.

Also, alias the subquery. IE:

SELECT *

FROM (

SELECT * FROM tblaz) AS drv

ORDER BY

drv.column1

EDIT: Also, you want SELECT TOP 100, not SELECT...

Append it before you turn it into a TIME field. ...

SELECT CONVERT( TIME, STUFF( RIGHT( '0000' + CONVERT( VARCHAR(5), '30'), 4), 3, 0, ':'))

Welcome, and...

LinkedIn, ORM Tools, and idiot managers convinced they're closer to the code and tools than I am.

There's a joke for these three plague topics somewhere... I need more caffeine, I...

No problem. If you get stuck after doing some experimentation just come on back and we'll help you with whatever specific point is causing you a headache.

Only until one of the big kids around here steps in and reminds me I'm a noob. 😉

-...

You clustered ZipCodes on Lat and Lon? You don't use a zipcode shortcut for city/state addressing I take it. Most of your access to that table is by...

So the basic idea of this is to find the # of applicable businesses within a radius from a zip code. Got it.

... <deletes a bunch of stuff>

Can we...

Jeff Moden (11/24/2014)

---

Eirikur Eiriksson (11/24/2014)

---

Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this topic on the XML forum...

Would have to see dbo.fnDistanceITVF to be able to determine if it would wrap in well.

In some ways, the bigger your underlying data sets the better the #tmp performs, not...

Most places I've worked at avoid drift by doing a development refresh from production (with necessary scrambling of identifiers/CC#s/etc, if necessary). At worst, a sprint is only a few...

psc032802 (11/24/2014)

---

What is the "machine in question"? The one the actual database is stored on?

If so, then SSIS needs to be installed on the database server and also on...

Dansong00 (11/18/2014)

---

Thanks for the awesome suggestion, i did the conditional split as suggested and all the records made it the original destination table, suggesting that there is no loc greater...

*stares at 3 pages of spammers*

Steve... can you convince the powers that be to put up a 'board of shame' or something on these spammers? Stick in there anything...