ALTER PROCEDURE [dbo].[USP_GetPickerNameList]
@SearchStr varchar(50)
AS
BEGIN
SET @SearchStr = RTRIM(@SearchStr) + '%'
SELECT DISTINCT TOP(10)
p.cpickerid
,p.cpickername
,p.cpickeridtype
,p.cid
,p.cidissuingstate
,p.pickerid_PK
,p.pickeridtype_FK
,p.idissuingstate_FK
,c.ccusname
,c.cusid_PK
,c.dbirthday
,f.caddress1
FROM pickers p
INNER JOIN pickergroups
ON p.pickerid_PK = pickergroups.pickerid_FK
INNER JOIN customer c
ON c.pickergroupid_FK = pickergroups.pickergroupid_PK
LEFT OUTER JOIN family f on c.familyID_FK = f.familyID_PK
LEFT OUTER JOIN rx r on c.cusId_PK = r.cusId_FK
WHERE RTRIM(LTRIM(p.cpickername)) LIKE @SearchStr
OR RTRIM(LTRIM(c.ccusname)) LIKE @SearchStr
OR RTRIM(LTRIM(c.ccusfirstname)) LIKE @SearchStr
OR RTRIM(LTRIM(c.ccuslastname)) LIKE @SearchStr
OR RTRIM(LTRIM(r.rxno_PK)) LIKE @SearchStr
ORDER BY p.cpickername
END
Recently I was fetching a problem that I need to run a PowerShell script that will change TFS user Display name and SID. I was trying to run that script from C# that was not working due to TFS security update and TLS certificate. Using this code block I resolve the Issue. var newProcessInfo = new System.Diagnostics.ProcessStartInfo(); newProcessInfo.FileName = @"C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe"; newProcessInfo.Verb = "runas"; // Define Run as administrator newProcessInfo.Arguments = script; //Define your powershell script newProcessInfo.UseShellExecute = false; newProcessInfo.RedirectStandardOutput = true; // This will enable to read Powershell run output newProcessInfo.RedirectStandardError = true; Process proces = System.Diagnostics.Process.Start(newProcessInfo); proces.WaitForExit(); // I want to read the output string from powershell window StringBuilder output = new StringBuilder(); output.Append("Started"); while (!proces.St
Comments
Post a Comment