Viewing 15 posts - 16 through 30 (of 5,678 total)
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 3, 2014 at 5:54 pm
craig.bobchin (12/3/2014)
Thanks that worked. How can I concatenate this with a date field. neither '&' nor '+' seem to work.
Append it before you turn it into a TIME field. ...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 3, 2014 at 5:53 pm
SELECT CONVERT( TIME, STUFF( RIGHT( '0000' + CONVERT( VARCHAR(5), '30'), 4), 3, 0, ':'))
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 3, 2014 at 5:26 pm
pchelptx (12/3/2014)
I am pretty new working with SSIS, I was not sure if this is the right place to post a question, If it is not please forgive beforehand.
Welcome, and...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 3, 2014 at 3:38 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 3, 2014 at 12:47 pm
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.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 24, 2014 at 6:30 pm
matt6749 (11/24/2014)
Thanks very much Craig. Your knowledge is very impressive. - Matt
Only until one of the big kids around here steps in and reminds me I'm a noob. 😉
-...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 24, 2014 at 5:26 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 24, 2014 at 4:54 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 24, 2014 at 4:36 pm
Jeff Moden (11/24/2014)
Eirikur Eiriksson (11/24/2014)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 24, 2014 at 4:17 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 24, 2014 at 4:10 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 24, 2014 at 4:06 pm
psc032802 (11/24/2014)
If so, then SSIS needs to be installed on the database server and also on...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 24, 2014 at 3:40 pm
Dansong00 (11/18/2014)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 19, 2014 at 2:28 pm
*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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 18, 2014 at 11:49 am
Viewing 15 posts - 16 through 30 (of 5,678 total)