Viewing 15 posts - 5,596 through 5,610 (of 7,168 total)
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.
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)
July 8, 2011 at 9:46 am
Here is the code including the latest string manipulation approach from tommyh and a variation of the "Union All/Crosstab" approach I put together, both of which remove dups yet still...
July 8, 2011 at 9:30 am
Sorry for your troubles Craig...your avatar <edit>your old avatar anyway :-)</edit> is very fitting on this thread 😀
I have fought with missing or incorrect Linked Servers in non-prod environments and...
July 8, 2011 at 8:55 am
tommyh (7/8/2011)
Okay so lets say we have a result looking like 1, "Tennis", Null,...
July 8, 2011 at 7:23 am
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 answer...
July 8, 2011 at 6:52 am
I have some re-thinking to do and some more learning to do from your work Jeff...I had suspicions before but it is abundantly clear to me now just how bad...
July 8, 2011 at 12:11 am
ringovski (7/7/2011)
David Burrows (7/7/2011)
1. where in the code do I put the alias i need for the column names, eg. issue date as Invoice Date.
Just add the alias to the...
July 7, 2011 at 10:56 pm
mister.magoo (7/7/2011)
mikes84 (7/6/2011)
July 7, 2011 at 10:43 pm
Nevyn (7/7/2011)
Please someone tell me what I did wrong:
You had a typo in your solution (used hobby1 twice from the first table), but that wouldn't effect the performance.
<edit>I think I...
July 7, 2011 at 10:37 pm
Dang...it was sniffing! As soon as I added a set of local variables to the proc and set them to the value of the input parameters I started getting the...
July 7, 2011 at 4:40 pm
mikes84 (7/7/2011)
SELECT h1.id,
REVERSE(PARSENAME(REVERSE(REPLACE(RTRIM(
CASE WHEN h1.hobby1 IS NULL THEN '' ELSE h1.hobby1 + ' ' END +
CASE WHEN h1.hobby2 IS NULL THEN...
July 7, 2011 at 2:43 pm
mikes84, could you edit your post so the code has some line breaks in it? It's making the page reallllly wide.
July 7, 2011 at 2:16 pm
I upped the ante to see how each technique would really do when presented with more than 5 rows of data in each table and in the process I broke...
July 7, 2011 at 2:15 pm
I'd love to hear from the OP again 🙂 Are you out there mikes84?
July 7, 2011 at 12:15 pm
Viewing 15 posts - 5,596 through 5,610 (of 7,168 total)