Viewing 15 posts - 5,581 through 5,595 (of 7,164 total)
Jeff Moden (7/9/2011)
opc.three (7/9/2011)
The entire set of code with The Dixie Flatline solution modified to work with the concrete test tables:
I have to ask... is there a reason why you...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 10, 2011 at 6:37 am
The Dixie Flatline (7/8/2011)
This solution might be a little less CPU intensive because the only string manipulation is done with ISNULL or CASE tests.
The trick is to...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 9, 2011 at 2:27 pm
Which Method did you try? From the article:
Method 2
This method applies to the following scenarios:
You transfer logins and passwords from SQL Server 7.0 to SQL Server 2005.
You transfer logins and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 9, 2011 at 2:00 pm
SQLkiwi (7/8/2011)
tfifield (7/8/2011)
Is there a link to Paul's CROSS APPLY method for UNPIVOT? I'd love to see it.Let me link to someone else's blog for a change...http://bradsruminations.blogspot.com/2010/02/spotlight-on-unpivot-part-1.html
Hilarious :laugh:
You know,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 2:35 pm
SQLkiwi (7/8/2011)
opc.three (7/8/2011)
Would you mind grabbing the whole chunk of code from my last post and posting the results from running it on your machine?
16-core test machine:
---------------------------------------------------------------------------
build temp tables
---------------------------------------------------------------------------
String manipulation...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 1:04 pm
Jeff Moden (7/8/2011)
opc.three (7/8/2011)
Edit 7/8/2011 7:20 Mtn: corrected property of Jeff's rendition, it "cannot be ordered by column name"Any bets? 😉
Oh no (secures wallet), don't get me wrong, not saying...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 12:53 pm
Long term I definitely want to remove the local variable swapping I just added. I'm still in the process of learning the data in the tables in question and what...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 12:43 pm
SQLkiwi (7/8/2011)
opc.three (7/8/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 12:05 pm
I love this site 😀
SQLkiwi (7/8/2011)
It strikes me that the elapsed time of the tests is limited by the time it takes to display the results -
That's why I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 11:47 am
Did you use SSIS by any chance?
See if the method under section titled "A complete resolution to transfer logins and passwords between different versions of SQL Server" works out better...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 11:12 am
Nevyn (7/8/2011)
I did misunderstand. I thought you were talking about duplicates in terms of records, not hobbies. Duplicate hobbies are allowed.
Do you want to show 4 nulls if there is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 10:37 am
mikes84 (7/8/2011)
...truncated quotes of quotes, etc....
I did misunderstand. I thought you were talking about duplicates in terms of records, not hobbies. Duplicate hobbies are allowed.
Thanks for confirming. If you said...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 10:24 am
opc.three (7/8/2011)
mikes84 (7/8/2011)
Regarding these two requirements mikes84:
1) Do you want duplicates shown in the results?
2) Does order matter?
Using our two tables hobby1 and hobby2 here is an example that should...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 9:57 am
The Dixie Flatline (7/8/2011)
What does your execution plan for the query show? Could you post it here please?
Ditto on the execution plan. I too am curious.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 9:51 am
I think you went in the wrong direction...you want to bring these into the GROUP BY:
ISNULL(mersum.subisonum, 0),
ISNULL(mersum.repnum, 0)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 9:46 am
Viewing 15 posts - 5,581 through 5,595 (of 7,164 total)