Viewing 15 posts - 5,596 through 5,610 (of 7,164 total)
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 8:55 am
tommyh (7/8/2011)
Okay so lets say we have a result looking like 1, "Tennis", Null,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 7, 2011 at 10:56 pm
mister.magoo (7/7/2011)
mikes84 (7/6/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 7, 2011 at 2:15 pm
I'd love to hear from the OP again 🙂 Are you out there mikes84?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 7, 2011 at 12:15 pm
I just went for a generic POC...the concept should still apply. I am super-curious now about your comment regarding select * vs. a named column list. Please provide DDL, DML...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 7, 2011 at 12:07 pm
lgoolsby 86333 (7/7/2011)
opc.three (7/7/2011)
What's wrong with comparing it to the result of the function call you used to populate PERIOD?
CONVERT(VARCHAR(6), tableB.INV_SER_DTs, 112)
This is exactly what I was trying but having...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 7, 2011 at 12:01 pm
Viewing 15 posts - 5,596 through 5,610 (of 7,164 total)