Viewing 15 posts - 5,581 through 5,595 (of 7,168 total)
anitia (7/9/2011)
July 10, 2011 at 6:53 am
Thanks for posting back, happy you got it sorted 🙂
July 10, 2011 at 6:41 am
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...
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...
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...
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,...
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...
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...
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...
July 8, 2011 at 12:43 pm
SQLkiwi (7/8/2011)
opc.three (7/8/2011)
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...
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...
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...
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...
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...
July 8, 2011 at 9:57 am
Viewing 15 posts - 5,581 through 5,595 (of 7,168 total)