Forum Replies Created

Viewing 15 posts - 46 through 60 (of 62 total)

  • RE: execute process task

    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,...

  • RE: Variable issue in script component

    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...

  • RE: parsing example

    Interestin! I never heard of that before. My boss will hear about it Monday...

    Thanks!

  • RE: parsing example

    I know what you mean by string patterns, but what is regex?

  • RE: parsing example

    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

  • RE: finding duplicates... help needed

    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...

  • RE: finding duplicates... help needed

    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...

  • RE: finding duplicates... help needed

    I will try this out Monday and I will let you know how it works. Many thanks!!!

  • RE: finding duplicates... help needed

    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 ...

  • RE: finding duplicates... help needed

    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]

    ...

  • RE: finding duplicates... help needed

    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...

  • RE: finding duplicates... help needed

    Same thing... I'm getting everything, duplicates and non-duplicates.

  • RE: finding duplicates... help needed

    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',...

  • RE: finding duplicates... help needed

    yes, that is exactly what I am looking for... someone trying to use 2 (or more) different SSN's...

    Current:

    LastName FirstName ...

  • RE: finding duplicates... help needed

    That doesn't work - there are no duplicates in that table because of the "group".. well, I'm lost again...

Viewing 15 posts - 46 through 60 (of 62 total)