Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WILKIEB

    The located assembly's manifest definition does not match the assembly

    I am getting this on a Subscription in SharePoint. The subscription is for a SSRS report that was deployed to a SharePoint Report Center Library. It worked fine and then I made a change to the report in SSRS and redeployed the report. I did not make any changes or redeploy the Data Source. I...
  2. WILKIEB

    Temp table of replications with lowest identifier

    Yep, it worked. Thanks
  3. WILKIEB

    Temp table of replications with lowest identifier

    Nothing, I only want rows that are in the table more than once.
  4. WILKIEB

    Temp table of replications with lowest identifier

    I have a tables that has replicated rows. The only thing different is the FLD_ID. I need to select into a temp table the one with the lowest FLD_ID. The following gives me the replicated ones. Any help? SELECT *FROM folder_id WHERE EXISTS (SELECT NULL FROM folder_id b...
  5. WILKIEB

    Query dups in 1 table & update 2 other tables then delete dups

    I’m new to SQL, and as an old RPG’r I know how I would do it that way but need help here. I can identify the duplicates SELECT FIELDA, FIELDB, FLDR FROM TableA c WHERE c.FLDR <> ( SELECT MAX (FLDR ) FROM TableA WHERE FIELDA = c.FIELDA AND FIELDB = c.FIELDB) order by...

Part and Inventory Search

Back
Top