Viewing 15 posts - 5,191 through 5,205 (of 5,678 total)
You can use a subquery the same way you can the inline TVF. Well, mostly. At a guess we just need to thin your code down a bit.
Are...
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
October 28, 2010 at 3:30 pm
Yep, not sure of the question here, though.
That's a NOT IN statement you're using, so it's checking to see if the id exists. When it exists, it's not included.
So,...
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
October 28, 2010 at 3:26 pm
you might be able to do it via profiler, but two commands in another query window while your first one calls the proc will be much easier, to the point...
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
October 28, 2010 at 3:24 pm
Sorry for that mbender. Joe Celko's the highly trained tourettes guy you usually leave locked in a back office at work and feed steaks and requirement documents in through...
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
October 28, 2010 at 3:21 pm
Hm, with all the Star Wars avatars around here I'm going to have to dig up a few Star Trek ones.
I believe the Picard Facepalm will be the first 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
October 28, 2010 at 1:39 pm
Is it good practice to use temp tables in a view...
Quick Answer: You can't. Views are single statement activities.
You can use cte's to help keep code readable. You...
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
October 28, 2010 at 1:33 pm
At a guess, it's probably waiting for a lock. Check while you run the process (exec proc) from a query window and then monitor that spid in sysprocesses. ...
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
October 28, 2010 at 1:31 pm
Stefan Krzywicki (10/28/2010)
Brandie Tarvin (10/28/2010)
Non-sequitur.Someone put eyeballs in my candy dish.
Honestly, I'd say that's much preferable to someone putting candy in your eyeball dish (sockets).
BAH! I always enjoy a...
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
October 28, 2010 at 11:43 am
Check out the DelimitedSplit8k function here:
http://www.sqlservercentral.com/Forums/Topic943562-338-1.aspx#bm944589
It'll do exactly what you need.
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
October 28, 2010 at 11:13 am
Brandie Tarvin (10/28/2010)
GilaMonster (10/28/2010)
Brandie Tarvin (10/28/2010)
GilaMonster (10/28/2010)
Woot. Just got a mail fom my ISP. Bandwidth cap permanently increased by 1 GB, no additional charge. Excellent!
AWESOME! Time to start watching some...
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
October 28, 2010 at 11:05 am
Jay-45986 (10/28/2010)
I can actually see it getting fired off!
One problem though - it was only inserting the last record of the batch. So I did some googling, 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
October 28, 2010 at 10:47 am
Are you getting this error when you schedule the package via a job and were successful from BIDS/VisStudio, or are you getting this from Visual Studio directly before a deployment...
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
October 28, 2010 at 10:22 am
Wayne, they're looking for last data modify.
Which might work, if all the fields are in an index. But afaik (assuming we CAN find the last modified date) even the...
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
October 27, 2010 at 11:12 pm
Raunak Jhawar (10/27/2010)
Also, if a directory by name 20101027 (yyyymmdd) why not use the CreationTime property?
I didn't want to use creation time because runtimes may be a bit wild. ...
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
October 27, 2010 at 10:41 pm
There, found what I was looking for. Thank you for that url Raunak, was the missing link for me. 🙂
Final code (functional and tested):
...
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
October 27, 2010 at 10:21 pm
Viewing 15 posts - 5,191 through 5,205 (of 5,678 total)