Skip to main content

T-SQL single parameter will perform like search on multiple table column



 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  


Comments

Popular posts from this blog

C# run powershell script as administrator

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

mvc razor textboxfor change event change another textboxfor value

Based on value of Weight, Rate , CNF & AWB it will change the value of Freight , TTLCNF anfd TTLFright . Freight= Weight*Rate; TTLCNF  = Weight*CNF; TTLFright=  Freight+ TTLCNF  + AWB; @Html.TextBoxFor(model => model.Weight, new { onChange="return GetWight(this);"}) @Html.TextBoxFor(model => model.Rate, new { onChange="return GetWight(this);"})/Kg @Html.TextBoxFor(model => model.Freight, new {disabled = "disabled" , @readonly = "readonly" ,onChange="return GetTTLFright(this);"}) @Html.TextBoxFor(model => model.CNFPK, new { onChange="return GetCNFPK(this);"}) @Html.TextBoxFor(model => model.TTLCNF, new {disabled = "disabled" , @readonly = "readonly",onChange="return GetTTLFright(this);" }) @Html.TextBoxFor(model => model.AWB, new { onChange="return GetTTLFright(this);"}) and script <script> function GetW

ASP.NET MVC razor SAP Crystal report

Crete a new project: Add a aspx Master Page Create a new folder Reports and 2 sub folder crystal & crystalviewer Now add a web form page in crystalviewer  folder. Add the master page namespace in your web form page. MasterPageFile ="~/Views/Shared/ReportSite.Master" Replace your web form by this code < asp : Content ID ="Content1" ContentPlaceHolderID ="ContentPlaceHolder1" runat ="server">      </ asp : Content > Now go to design mode of your web form drag & drop the crystal report viewer in your web form. After that your page will be look look like this. Replace the code: < CR : CrystalReportViewer ID ="EmployeeList" runat ="server"   HasCrystalLogo ="False"     AutoDataBind ="True"   Height ="50px"   EnableParameterPrompt ="false" EnableDatabaseLogonPrompt