I have one SQL Query and it is working fine. Now, I want to access another table using One of the columns in this table.
How can I access that value and How to put that in the existing SQL Query
View Complete Post
I have a Content Query Webpart in SharePoint 2010 that I would like to surface Documents grouped by content type. I wish to show the edit form or view Properties link as part of the fields shown in the results. When the User clicks on this link, it
should take him to the edit form or view Properties page for the document.
I am able to open the site (SPS 2010) using Sharepoint Designer 2010. When I browse to the master page, I can check it out and when I try to edit, it gives me a message saying that it is trying to build the report. But nothing happens even if I wait for
I am trying to edit the master page so that I can change the top banner and to provide mouse-over text for the sites. I would really appreciate if anyone could provide any advice to get around this.
I am also curios about one thing. For some reason, I am unable to open the site using sharepoint designer if I try to open the site via http. But I am able to open the https site. Does it have to do anything with alternate access mappings?
I have a simple package that imports data from an excel file to a 2008 R2 database.
here is a sample of the excel file
54 Siobhan Kennedy Health
22 Peter OChahan Education
31 Ryan Harkins Finance
My table in the database looks like this:
CREATE TABLE [dbo].[Employee](
[EmployeeID] [int] NULL,
[FirstName] [nchar](50) NULL,
[LastName] [nchar](50) NULL,
[Department] [nchar](50) NULL)
I want to import the data into the database, splitting the name column into firstname and lastname using the SSIS package.
So far (on the data control tab) I have an 'Excel Source' Box and an 'OLE destination' Box.
I think i need to pick an option from the 'Data Flow Transformations' menu in the toolbox. Is this correct?
I am using content query web part for displaying data from list. when i export these webpart in notepad. and add some column name and type in CommonViewField parameter. it gives error while editing the content query web part. it was working fine
in MOSS2007. please let me know correct format if it changed.
I am using content query web part in sharepoint 2010 for displaying data from list. i exported it. and open in notepad edit mode and made, add some column name and type. i uploaded this web part. this is added . when i edit this web part in site. it gives
I am using content query web part in sharepoint 2010 for displaying data from list. i exported it. and open in notepad edit mode and made, add some column name and type. i uploaded this web part. this is added . when i edit this web part in site.
it gives error
I am currently designing a .Net 3.5 Windows Forms application and I would like to use a grid control similar to the one found when editing a Query in TFS :
Does anyone know what control this is and whether it's a standard tool available in Visual Studio? Basically I need a grid control which can host dropdowns and allows you to group rows together.
Any advice much appreciated
How to undo an edit mistake in SQL Server Management Studio Query Editor?
When edit a code in Query Editor, because of mistake, I lose part of the code. Now I want to undo the previous action. How to deal with it?