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
View Complete Post
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"
Name="StartCoordinate" Overwrite="TRUE" />
<Field Type="Number" DisplayName="End Coordinate" Required="TRUE" EnforceUniqueValues="FALSE" Indexed="FALSE"
Name="EndCoordinate" Overwrite="TRUE" />
Then added these to a new content type I
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.
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 oneanyone has any background about how to do that or there is any web services that provide this functionality Thanks in advance
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
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?
How can I find all routines (sp, fn) exec granted to a specific user in a given database ?
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:
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
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.
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
at Microsoft.SharePoint.SPContentTypeCollection.Delete(SPContentTypeId id)
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
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. 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.
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.