No announcements
Found 2236907 threads
-
0 VotesMacro to add/remove pivot table fields?
Check once the field name.Answered | 7 Replies | 1392 Views | Created by ranopano - Thursday, September 15, 2016 6:17 PM | Last reply by Asadulla Javed - Tuesday, September 20, 2016 6:15 AM
-
4 Votes
Need to remove duplicate rows in sql server.
here is a small article that describes with example how you can achieve this ...Answered | 7 Replies | 12484 Views | Created by Amit_kala - Sunday, May 20, 2012 10:22 AM | Last reply by Amit_kala - Wednesday, March 20, 2013 3:17 PM -
0 Votes
Remove Duplicates in SSIS package
I can't eliminate in the source SQL (SQL Server) because that query has other fields which are needed for another file.Answered | 11 Replies | 5609 Views | Created by Spunny - Monday, February 5, 2018 9:13 PM | Last reply by Visakh16 - Saturday, February 10, 2018 6:03 AM -
0 Votes
Removing duplicate comments in Word VBA
comments removed", vbInformation End Sub Regards, Hans Vogelaar (http://www.eileenslounge.com)Answered | 2 Replies | 778 Views | Created by Morten Justin strand - Sunday, June 3, 2018 8:33 AM | Last reply by Edward8520 - Thursday, June 7, 2018 7:22 AM -
0 Votes
Removing Duplicates
I am using the merge in the big query and it doesnt allow duplicates. and I couldn't get round of it. so all i need is a subquery to pick only 1 address.Answered | 17 Replies | 1387 Views | Created by RVD's - Tuesday, May 21, 2013 9:59 AM | Last reply by RVD's - Tuesday, May 21, 2013 10:44 AM -
0 Votes
Removing duplicates
about 20 % data duplicated...Answered | 3 Replies | 5622 Views | Created by DB Team - Friday, November 20, 2009 8:57 AM | Last reply by richbrownesq - Friday, November 20, 2009 9:29 AM -
0 Votes
Reverse the macro removal procedure?
However, if you need to add a macro part into the document, you could make a template in Word and Open it in theAnswered | 3 Replies | 5952 Views | Created by DaveMSDN123 - Friday, May 21, 2010 8:12 PM | Last reply by Lu Zhang - Monday, May 31, 2010 6:30 AM -
3 Votes
Removing Duplicates
So i need to figure out how to remove the duplicate entry's from the string collection programatically so the user dosen't see the duplicates.Answered | 12 Replies | 7683 Views | Created by Steve82291 - Friday, April 23, 2010 7:09 AM | Last reply by John Anthony Oliver - Friday, April 23, 2010 5:28 PM -
1 Votes
ImportExportText in Macro doesn't put all the data in a field
Peter - I can't duplicate your problem on Access 2010.Answered | 3 Replies | 774 Views | Created by Peters pas - Friday, August 9, 2019 1:56 PM | Last reply by Bill Mosca, MS MVP 2006-2016 - Monday, August 12, 2019 2:51 PM -
0 Votes
Remove Duplicate without affecting Aggregate value in count fields
Looks like that you need to create a group for MemberID, right?Answered | 2 Replies | 3836 Views | Created by meemkay - Friday, July 3, 2009 9:42 AM | Last reply by Xiao-Min Tan – MSFT - Tuesday, July 7, 2009 7:09 AM -
0 Votes
duplicate field entries
If not, but are erroneously recording the same shipment twice than you will first need to remove the redundant extra rows so that you are left with one of each.Answered | 13 Replies | 2676 Views | Created by taking - Friday, April 6, 2012 7:47 PM | Last reply by taking - Tuesday, April 10, 2012 8:16 PM -
1 Votes
VBA to remove data macros
You can create an empty file and load it for all tables to remove the data macros like this: Public Sub delete_datamacros() Dim rec As Recordset ...Answered | 15 Replies | 2155 Views | Created by Bruce Hulsey - Friday, May 20, 2016 3:35 PM | Last reply by Peter N Roth, Author of Ten Commandments of VBA - Monday, November 18, 2019 6:30 PM -
0 Votes
Need help remove duplicate rows.
Hence its reflecting like duplicates.Answered | 5 Replies | 1077 Views | Created by NguyenBL - Monday, January 19, 2015 4:26 PM | Last reply by pituach - Friday, January 30, 2015 7:42 PM -
0 Votes
remove duplicate using ssis
Hi Dude, If Your Source is SQL then what is the need of having SSIS Transformation for removing Duplicates, you can directly write SQl Query to ...Answered | 3 Replies | 3648 Views | Created by tsql_new - Tuesday, February 26, 2013 7:24 PM | Last reply by Naveen Kumar K.R - Wednesday, February 27, 2013 9:42 AM -
0 Votes
Removing Duplicates
You need to put UNIQUE constraint on the Item code column...Answered | 5 Replies | 1362 Views | Created by MattT25 - Thursday, August 29, 2013 1:08 PM | Last reply by Harry Bal - Thursday, August 29, 2013 5:50 PM -
1 Votes
Removing duplicates
In the second one no need to create new table, but in the case of first one number of comparisions are less comparing with second one.Answered | 10 Replies | 4731 Views | Created by DB Team - Friday, November 20, 2009 8:57 AM | Last reply by Murty Addanki - Friday, November 20, 2009 10:48 AM -
0 Votes
Remove duplicates from totalling?
How should First know when an entry is a duplicate?Answered | 3 Replies | 7540 Views | Created by agjd - Thursday, July 1, 2010 12:54 PM | Last reply by Report Writer 'SSRS User' - Friday, July 2, 2010 1:34 PM -
6 Votes
How to remove duplicate rows
What is your SQL Server version and can you post your table creation script and which columns are considered duplicates and how you're determining which one of the duplicates to ...Answered | 8 Replies | 4771 Views | Created by Sam233 - Monday, March 1, 2010 2:25 PM | Last reply by Syed Shakeer Hussain - Monday, March 1, 2010 3:50 PM -
0 Votes
Removing duplicate in SSRS
hello not sure if there's any thing you can do with just an expression but you can modify your query to take care of this here is an example I quickly hacked up that likely isnt ...Answered | 3 Replies | 4227 Views | Created by rqwew - Wednesday, February 17, 2010 3:44 PM | Last reply by Nehemiah Willis - Wednesday, February 17, 2010 5:06 PM -
0 Votes
SSIS remove the duplicate records
Hello, If you join the tables in T-SQL, use distinct in your select to remove duplicates.Answered | 3 Replies | 5302 Views | Created by Rammohan Ammiti - Wednesday, May 5, 2010 1:48 PM | Last reply by Sudeep Raj - Wednesday, May 5, 2010 1:54 PM - Items 1 to 20 of 2236907 Next ›
No announcements
