Viewing 15 posts - 46 through 60 (of 62 total)
Yes - and I just tried using the UNC instead, and it worked! (someone suggested it). I wonder how I didn't think of this myself... But it works now,...
January 16, 2009 at 1:51 pm
I must not be getting something - I understand that you can't access the variables unless you put them in as readonly - what do you do if you need...
October 8, 2008 at 1:57 pm
Interestin! I never heard of that before. My boss will hear about it Monday...
Thanks!
September 27, 2008 at 8:38 pm
I know what you mean by string patterns, but what is regex?
September 25, 2008 at 6:24 pm
That is what I was suspecting, too... I guess I will have to do this in VB, process one line at a time.
Thanks you very much for your opinion!
Marius
September 25, 2008 at 10:37 am
Lynn,
It's not all the "distinct" records I need to return, it is all records with a duplicate SSN that I am interested in. I tried the query, and it returns...
August 25, 2008 at 11:12 am
Perry,
It looks like this is it!! It is working...
can you recommend a book/ website/ anything else I could use to learn the more complex TSQL from? I do...
August 25, 2008 at 10:12 am
I will try this out Monday and I will let you know how it works. Many thanks!!!
August 23, 2008 at 9:41 am
I can't publish real data here, for obvious reasons. I don't think multiple names makes the difference. This is what I am getting:
Duck ...
August 22, 2008 at 6:57 pm
Well, here's the full code:
SELECT [daily].[dbo].[CIS_Acct_Name].[Short_Last_Name],
[daily].[dbo].[CIS_Acct_Name].[Short_First_Name],
[daily].[dbo].[CIS_Acct_Name].[Middle_Initial],
[daily].[dbo].[CIS_Acct_Name].[Tax_ID_Number]
FROM [daily].[dbo].[CIS_Acct_Name]
...
August 22, 2008 at 2:46 pm
Same result, but not quite: I actually have the duplicates now, and I can just delete those. I think it should work, I will try it out Monday.
Many...
August 22, 2008 at 2:36 pm
Same thing... I'm getting everything, duplicates and non-duplicates.
August 22, 2008 at 2:23 pm
Thanks, but I am still getting the duplicates on all 3 fields. In your table, you put:
NSERT INTO Person
SELECT 'Donald', 'Duck', 'SSN-001'
UNION ALL
SELECT 'Donald', 'Duck', 'SSN-002'
UNION ALL
SELECT 'Mickey', 'Mouse',...
August 22, 2008 at 1:16 pm
yes, that is exactly what I am looking for... someone trying to use 2 (or more) different SSN's...
Current:
LastName FirstName ...
August 22, 2008 at 10:40 am
That doesn't work - there are no duplicates in that table because of the "group".. well, I'm lost again...
August 22, 2008 at 10:27 am
Viewing 15 posts - 46 through 60 (of 62 total)