.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

find duplicate specific fields

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

hi all, i'm a sql beginner, here is my problem..

i have a table A with ID, date, typeID, etc

i know i can group by ID, but then i want to find the duplicate date and typeID


please help

View Complete Post

More Related Resource Links

I have added new fields to a table in SQLserver, why could not find these new fields in Analysis Ser

I have added new fields to a table in SQLserver, why could not find these new fields in Analysis Services database source view?  My version is 2005.

How do you add duplicate fields to a SSRS custom report and receive differtent output values.

I have built a custom report in SSRS 2008 using fields for supplier and customer.   I have added a Parent Row Group using the Supplier field for the group expression and used the Customer Details as my child details group. This returns a list of all customers for each supplier.   (Supplier | = Customer details ( Name, Dob etc.)   How would I add an additional Supplier field to the customer details returning only values for other Suppliers used by a customer, not the value of the Supplier listed in the Parent Group?

Duplicate records find in table

  Hi ALL, I want to find the dynamically check the primary key values and remove the duplicate records.. please suggest it.   Regards Ram

How to find specific nested object type in Gridview

Dears, I have a gridview with a nested placeholder in each rows. I nested some checkboxes in each placeholders in each rows dynamically, so their ServerIDs are not the same (I dont want to use nested gridview). at the end in a button event I want to count checked checkboxes in gridview while I can not use findcontrol() method in each rows to find checkboxes due to their different ServerIDs. How can I do this?

How to submit my form to Sharepoint Library as well as Sharepoint List with specific Fields only.

Hello ,   I have a Infopath form that contain 50 of fields. i want to submit those form into sharepoint library as well as Sharepoint Custom List(Specific Fields). Please suggest best practice to develop such a functionality.   Thank you.

how to duplicate fields on form data source?

I have many fields with similar names and same type. Is there any easy to copy and paste and then change field names? thanks,

Duplicate Fields during list creation from content types and site columns


I am trying to create a List in Sharepoint 2010 using Site Columns and Content Types. It results in creating duplicate fields in the list for the Site Columns used. Here is the details description of what I was doing.

I have created two site columns 


<Field Type="Number" DisplayName="Start Coordinate" Required="TRUE" EnforceUniqueValues="FALSE" Indexed="FALSE"
Group="QMS" ID="{A3F2D108-11B5-4B49-9633-338D27227E12}"
Name="StartCoordinate" Overwrite="TRUE" />

<Field Type="Number" DisplayName="End Coordinate" Required="TRUE" EnforceUniqueValues="FALSE" Indexed="FALSE"
Group="QMS" ID="{06B927BB-C354-4A0A-AE88-9C14E55EAB27}"
Name="EndCoordinate" Overwrite="TRUE" />

Then added these to a new content type I

Custom search to document library to find specific document



I have a document library with having multiple folders approx 100 (001 to 100) , each folder is having multiple document ,Every folder in that document library contains 50000 documents , Document library has some fileds like Fname, Lname,Document Type [Look up field] having value(Genral,Average,Advance) . now the problem is to search these documents with using custom search as per requirement

the user wants a webpart where it has 2 textbox [FName and LName] and a dropdown [Document type] and a button , using this the user can enter the first name , last name and selecting document type from the dropdown and finally clicking the search button filters the document library. 

my problem is with that how the value of this search criteria can be passed to the Document library.How these webpart can be connected with custom search or do we have any other way to search.




How do find what query is being executed on specific session ID?



I have a SP which writes to a table all processes which are being executed when application decides to stop waiting for results of the query. It works very well but problem is that it does not dump all SPIDs but only some of them which are being executing for a long time. Common pattern that a lot of SPIDs will be blocked by single SPID which will not be part of the output which is being generated. How do I dump all SPIDs and what they are doing along with SP below?


 'blk object' = t1.resource_associated_entity_id,

 (SELECT SUBSTRING(text, t3.statement_start_offset/2 + 1,
 		(CASE WHEN t3.statement_end_offset = -1 
 			THEN LEN(CONVERT(nvarchar(

how to add search for available domain name and find information about specific one ?


Hello All , 

i have a task to add search for available domains and also to find some information about specific one

anyone has any background about how to do that or there is any web services that provide this functionality 

Thanks in advance

HowTo find a specific version of an assembly in the GAC?


I need to find a way of determining if a certain assembly version is present in the GAC and so far the only way I've found of doing this is by running gacutil /l AssemblyName and then parsing the output of that and check the 'Version' values.

Does anyone have a better solution?

Find all stored procedures/functions granted to a specific user


SQL 2005.

How can I find all routines (sp, fn) exec granted to a specific user in a given database ?

Thanks !!

How to Find a specific sentence in a table that contains only words?


Hello dear grurus,

I don´t know if my question did, somehow, explain itself... if not, let me brake it down:

I have a table like this:

ID         WORDS

1          change color red

2          open door

3          find terms


now, I would like to search for an ID giving this search string: "Whould you like to change the color to red, please?"

please notice I have given a sentence containing 3 keywords found in row 1 for the table above... I know this, but how do I make t-sql to know this? 


Thank you so much for the help guys!

PS: please let me know if im not clear enough.

Is there anyway to find what is using a specific content type?


I have two site content types that I no longer need.  I have changed the pages that were using these content types, to another content type and also changed the page layouts that were using these.

Each time I go to remove the content types, I get an error message which reads "The content type is in use.   at Microsoft.SharePoint.SPContentTypeCollection.DeleteFromWeb(SPContentTypeId id, String strName)
   at Microsoft.SharePoint.SPContentTypeCollection.Delete(SPContentTypeId id)
   at Microsoft.SharePoint.SPContentType.Delete()
   at Microsoft.SharePoint.ApplicationPages.ManageContentTypePage.DeleteContentType()
   at Microsoft.SharePoint.ApplicationPages.ManageContentTypePage.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Is there any way to find out what is using this content type?  I'm absolutely sure that I've changed or deleted everything that was using these content types but can't work out wha

Find duplicate files




Is it possible to use sharepoint for the finding duplicates files? I need to identify all duplicate files at our network shared drives.


How can I find from a single query that a user has which permission on a specific table


Hi All,

How can I find from a single query that a user  has which permission on a specific table. I have a Table named "Property_Address" and a User "ABC" doing update on this table. How can I revoke permissions on this table from this user and how can I find which permissions this user have on Property_Address Table.

Any help would be appreciate.

find a specific character by regular expression


Hi everyone,

I am using RegularExpressionValidator in my form and I want to check if the textbox value contains the '@' character in that or not.

what should be the ValidationExpression?

Any help will be appreciated.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend