Viewing 15 posts - 2,431 through 2,445 (of 5,685 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...
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...
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...
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...
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...
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...
October 24, 2011 at 8:18 pm
Might be a local market boost. I haven't noticed anything significant in the markets I watch.
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
...
October 24, 2011 at 5:08 pm
Jeff Moden (10/24/2011)
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...
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...
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...
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...
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...
October 24, 2011 at 12:07 pm
Yeesh, what is this, attack of the copy/pasters?
October 24, 2011 at 11:03 am
Viewing 15 posts - 2,431 through 2,445 (of 5,685 total)