I have sql table with three columns Cparent_alias ,Custom_alias,C_descript I wont to update the name in C_descript column BUT before I need to check if the name
already exist or not.
View Complete Post
How I can write this query ?
I have value = 1000
I wont to get all value from table [MHGROUP].CUSTOM2
from column CPARENT_ALIAS
all values which beginning with num 1000.
cmd2 = new
* FROM [MHGROUP].CUSTOM2 WHERE CPARENT_ALIAS ='" + value +
I have an OLE DB source in a data flow task. The connection is pointing to a SQL Server 2008 instance. My SQL works fine when I click the preview button. Now I need to make it parameterized by adding a question mark in my where clause.
After doing so & clicking the Parameters button, I get the error described in
this post . When I try to do what's described therein to correct the problem (click the "build query" button), I get the error "The PIVOT SQL construct or statement
is not supported."
I can't make this query an expression; it's simply too complex to maintain that way (besides, just pasting it into an expression builder window and trying to evaluate
as is doesn't work - can't evaluate).
So the question is, how do I parameterize a query? And why does SQL here work so radically differently from SQL in an execute SQL task?
We have created a custom workflow using SharePoint Designer. We are using one action “Collect Data from a User”. As you know, this action sends an email to a user with a link to a task form where user is supposed to accept or reject a request.
We are encountering following issues with this form:
Can someone please explain what is going on and how can we resolve the above issues?
I am using SSIS to query all servers for their disk space from a remote machine using the WMI Reader Task by providing the Administrator user credentials to access all servers. The package execution fails and I get the following error in the Execution Results pane:
[WMI Data Reader Task] Error: An error occurred with the following error message: "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))".
However, I do get the results for the Development and Staging servers but the Production servers come back with an Access Denied message. The user credentials for the Dev and Staging servers belong to the "Administrator" group whereas for the Production, the user belongs to the "Administrator" and the "User" group as well.
I am pretty much sure that it has something to do with access to running WMI queries on the servers but I could not find a forum that discussed this issue elsewhere. I even checked for the DCOM Security settings after a few searches led me to a post about "Connecting to WMI on a Remote Computer" on an msdn forum but they seem to be enabled for all environments.
My production database sits on a cluster, so does that make any difference? I have not used the WMI ta
I have to filter the MyTask according to "Assigned To" = "SharePoint Group" and "TaskStatus" = "InProgress", I have created the SPLinq.cs file using the SPMetal.exe for the particular webapplication but I am not able
to get the "TaskStatus" field in the linq MyTask Object, also have checked the SPLinq.cs file it's having the definition of "Assigned To" and "TaskStatus".
Please Help me how to do filter the MyTask according to "Assigned To" = "SharePoint Group" and "status" = "InProgress" by using Linq.
How I can write following SQL query using LINQ. There is no default constraint define for the ID column so we have explicitly pass the NEWID().
I want to replicate the products of a company to another company.
Insert Into ProductsSelect NEWID() AS ProductID, ProductName, CompanyID = @DestinationID, ProductCategoryID From Products Where CompanyID = @SourceID
Also once I get these result how can I use InsertAllOnSubmit to insert all the records at once without looping it.
We have some workflows which are been created already. The tasks are been assigned to users for their approval. Now, when the approver logs in it should display the Tasks List which are belonging to that particular user only. OR if the normal user logs inn,
it should display Tasks belonging to that User only. A web part should display this. Pls. note that I have to show the Tasks from both "Workflow Task" & "Task".
The Task list should come from across site collections of a Web Application.
Hence,The Scopen should be WebApplication.
How do I achieve the same? Need help ASAP.