Viewing 15 posts - 2,431 through 2,445 (of 5,678 total)
Mvs2k11 (10/25/2011)
Let me know if i m not clear..
You're not, and you're being very vague with your responses:
Column.
Also, you mention 10 partitions, and when asked for a sample of your...
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 25, 2011 at 12:31 pm
jared-709193 (10/25/2011)
WardyWonderland (10/25/2011)
bitbucket-25253 (10/25/2011)
Read this article by Jeff Moden, and its sample T-SQL .. it may be the answer to your question
Many thanks guys.
I have started reading the article...
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 25, 2011 at 12:20 pm
Damn good question, thanks. I'm also glad it was as long as it was, it took me a few re-reads to realize where you were trying to take this...
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 25, 2011 at 12:17 pm
Heh Tom, I'm with you.
I still run a Sprint Treo (Palm OS). It's amazing. It makes phone calls and gets my email. When I actually kept 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 25, 2011 at 12:07 pm
Kramaswamy, my biggest concern with the nested choices are if you have something like:
aaaaaaaa93aaaaaa.
3 gets picked up first. You'd have to test for all possibilities and pick the lowest...
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 25, 2011 at 12:01 pm
Got a semicolon in the comment?
EDIT: Nevermind, just proved to myself that couldn't be the issue.
Otherwise, from this basic explanation, no. We'd have to see the offending comment/syntax.
Though, to...
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 24, 2011 at 8:18 pm
Might be a local market boost. I haven't noticed anything significant in the markets I watch.
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 24, 2011 at 8:16 pm
nfpacct (10/24/2011)
The desired output are the rows that have an * (asterisk). As it contains the latest date.Thanks you
Ah, that helped. Try this:
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
October 24, 2011 at 5:08 pm
Jeff Moden (10/24/2011)
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 24, 2011 at 5:01 pm
So you're looking for the last record by vendor?
Something like this would work:
select
drv.vendor, ca.dateofValue
FROM
(SELECT DISTINCT vendor FROM Tbl) AS drv
CROSS APPLY
(SELECT TOP 1 Vendor, DateOfValue
FROM Tbl
WHERE Vendor = drv.Vendor
ORDER 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
October 24, 2011 at 4:55 pm
Evil Kraig F (10/24/2011)
venoym (10/24/2011)
I think what it's analyzing is on the whole find all pairs that match DataKey and have opposite Types. Any "orphan" or "single" DataKey is...
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 24, 2011 at 1:26 pm
venoym (10/24/2011)
Kraig,I think what it's analyzing is on the whole find all pairs that match DataKey and have opposite Types. Any "orphan" or "single" DataKey is "Not a dup".
Then...
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 24, 2011 at 1:13 pm
Venom, you're using the same theory I am but your method won't deal with generic TransCodes, you'd have to code for each one. I'm assuming this sample is restricted...
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 24, 2011 at 1:06 pm
L' Eomot Inversé (10/24/2011)
Evil Kraig F's signature (10/24/2011)
This space for Rent.- Payment will only be accepted in non-mobile Electrons.
The wonderful thing about non-mobile electrons is that you know their...
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 24, 2011 at 12:07 pm
Yeesh, what is this, attack of the copy/pasters?
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 24, 2011 at 11:03 am
Viewing 15 posts - 2,431 through 2,445 (of 5,678 total)