Viewing 15 posts - 1 through 15 (of 40 total)
Thank you all for your support. I implemented Jacob's solution and it is doing exactly what I need it to do.
Jacob, I think your grouping approach is...
July 22, 2015 at 9:35 am
Thanks so much for the help!!! That worked perfectly. 🙂
January 21, 2012 at 8:15 am
I already have the data source on a text box. I would like to auto populate it from the Data Source Name. 🙁
July 19, 2011 at 1:42 pm
So how can I determine that based on the info you gave me? There is nothing in the #MySample table letting me know that row belongs to ZZ group
That is...
July 15, 2011 at 8:45 am
INSERT INTO #MySample VALUES (4, '
123456789 --match value 4
8943','Calan','Katin')
This record does not match because in the #MyAddress table it is NO 'A ...
July 15, 2011 at 7:58 am
I did, but per example, it should only return 3 records, and I get 4.
July 15, 2011 at 7:37 am
I have to ask, Craig... REVERSE is fairly expensive performance-wise. Why any REVERSE's to begin with?
Jeff, better suggestions? Thank you!
July 15, 2011 at 6:32 am
Maybe its me but the data supplied does not match ID is mainly a number and address code has the ab space issue...Are you wanting to join the first 9...
July 14, 2011 at 9:11 pm
Yes, I would not be able to modify the data on the source #MyAddress table. 🙁
However, I would like to implement a permanenet solution so I can always use it...
July 14, 2011 at 8:27 pm
Hi Dixie,
Yes, this is working, and thank you for the explanation.
It makes sence. I really appreciate your help on this one!
John
July 8, 2011 at 7:31 pm
Yes, I am thinking to work on one step at a time.
Right now, I am in urgent need to get 2 or more same instances of the Type...
July 8, 2011 at 1:20 pm
Okay... so we want to see any group with two or more types that have two or more rows per type.
Now tell us again how codes fit into that. I...
July 8, 2011 at 12:06 pm
ColdCoffe... almost there, but does not work for example GroupID 5.
CREATE TABLE #MyCodes
(
MyNo int,
GroupID varchar(100),
Code varchar(6),
MyType varchar (15)
)
INSERT INTO #MyCodes VALUES (1, 3, 10, 'Red')
INSERT INTO #MyCodes VALUES...
July 8, 2011 at 11:58 am
Good Point, yes I want to see GroupID 99 as well, because it has 2 or more sets of two ro more.
July 8, 2011 at 8:05 am
Thank you all for your help!
Yes, it is very confusing. But I got some clarifications.
Condition for the type should be two or more of the same type per groupID.
So,...
July 8, 2011 at 6:59 am
Viewing 15 posts - 1 through 15 (of 40 total)