SQL Server Concatenate Row Values using T-SQL

Some time we need to show concatenated row values in the SQL Select Statements. Lets say, if we have Customers, Orders and Order details. Incase, if we have to list out all Products that each customer ordered in a single column. Here is the snippet. DECLARE @OrderDetails TABLE( [OrderDetailsID] INT NOT NULL, [OrderID] INT NOT NULL,…

1

SharePoint 2010 Administration service failed to start

After updating some windows updates in SharePoint 2010 machine, it stopped SharePoint 2010 Administration Service. I have tried to start the service, got the below error  Windows could not start the SharePoint 2010 Administration service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion. I…

0

SharePoint Error : The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started.

This error “The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator.” appears with various possible ways. I have tried googling and everybody has given a solution to provide permission to Managed Metadata Service Application. But, this didn’t fix…

33

SharePoint Start Workflow : Error The security validation for this page is invalid.

Whenever we start the workflow programmatically using SPWorkflowManager.StartWorkflow(), it throws security validation exception. Since we run with elevated previleges, the way to fix is to call SPUtility.ValidateFormDigest(). I am assuming you will get the ListItem by using GetSPListItem().   var item = GetSPListItem() if (item != null)                        {                            SPWeb web = item.Web;                            SPWorkflowManager workflowManager =…

0

Open SharePoint Url in dialog using Jquery UI dialog

Some time we need to open the SharePoint pages from other technologies like PHP or other web technologies. We can use Jquery UI top open the dialog page. The samples in jquery UI http://jqueryui.com/dialog/ does’t give any sample on how to open a URL in the dialog. The below sample works for opening the URL…

0

SharePoint Check the user is member of audience Programmatically

Audiences in SharePoint Server 2010 are groupings of users that can be used to target content on a SharePoint Server Web site. SharePoint Server 2010 allows targeting to the list-item level or to the list level. Groupings are determined by membership in Microsoft Exchange Server distribution lists, membership in SharePoint groups, or rules that are…

0

Add/Remove SharePoint Workflows thru PowerShell

You can add/remove workflows to the list or library by navigating to List Settings -> Workflow Settings -> Add a workflow List Settings -> Workflow Settings -> Remove a workflow If you want to perform the same operation using PowerShell script, here is the script to add a workflow to a list Script to Add…

2

Enable Powershell ISE from Windows Server 2008 R2

PowerShell ISE (Integrated Scripting Environment) gets installed by default with Windows 7  or Windows Server 2008 R2 but doesn’t show in the start menu. There are two ways to enable PowerShell ISE.   Using PowerShell Open Powershell Window Execute following cmdlets. Import-Module ServerManager Add-WindowsFeature PowerShell-ISE   Using Server Explorer Open the Server Explorer Navigate to the…

5

SharePoint 2010 Custom Timer Job – Send an Email

1. Open Visual Studio 2010 and goto FILE -> New Project -> Empty SharePoint Project. 2. Select SharePoint 2010 under Installed Templates under left Navigation. 3. Select Deploy as Farm Solution Option and replace http://<<ServerName>>/ with proper URL of the SharePoint site. 4. Right Click on the Project and Create a New Item 5. Select…

24