Dynamic Pivot Results to a Temp TableSET @cols = STUFF((SELECT distinct ',' + QUOTENAME(QT.QUESTION_DESC) FROM #QUES_TEMP QT GROUP BY QT.QUESTION_DESC FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)') ,1,1,'') set @query = 'SELECT EVAL_ID, AuditType, ' + @cols + '...

 $(document).ready($(function () { $('#searchFacility').button().on("click", function () { //showUrlInDialog('/Home/FacilitySearch'); $("#modalSearch").load('/Home/FacilitySearch').dialog({ autoOpen: false, modal: true, close: function (event, ui) { $("#modalSearch").empty().dialog('destroy'); ...

 1. https://stackoverflow.com/2. https://www.c-sharpcorner.com/3.https://www.datensen.com/4. https://coderbyte.com/5. https://www.codewars.com/6. https://www.codingame.com/7. https://geektastic.com/8. https://www.hackerrank.com/9. https://leetcode.com/10. https://www.tutorialspoint.com/11. https://www.w...

 Multiple like search In SQL ServerExample :SELECT Tbla.* FROM Tbla INNER JOIN Tblb ON Tblb.col1 Like '%'+Tbla.Col2+'%'Help Link : https://stackoverflow.com/questions/1865353/combining-like-and-in-for-sql-serverUse Practical In Work SELECT  FX.* FROM( SELECT OBD.orderRowNo,OBD.OrderBookingID,OBD.OrderDetailBodyID,OBD.FabricDia,OBD.FabricGSM,OBD.KnittingOrderQty,OBD.DyeingOrderQty,FabricFormID,ColorID,OBD.FabricTypeID,OBD.YarnTypeID,OBD.MeasureUnitID,OBD.GarmentsColorFROM tblOrderBookingDetailBody...

 Enable TCP/IP in SQL Server ConfigurationWhen two or more SQL Servers are connected across network they do all communication using TCP/IP. The default port of SQL Server installation is 1433. This port can be changed through SQL Server Configuration Manager. TCP/IP should be enabled for SQL Server to be connected.Go to All Programs >> Microsoft...

 Resolving breakpoint will not be hit error waysWe will start with simple solution, try to clean your solution and then re-build. For this, simply open your "Solution Explorer", select your "Solution" and right click on it, Select "Clean Solution", once solution is cleaned, which will delete all the compiled and temporary files associated with a solution,...

 https://stackoverflow.com/questions/14000572/better-way-to-select-all-columns-from-first-table-and-only-one-column-from-seconSELECT tb1.*, tb2.x FROM tableA tb1 INNER JOIN tableB tb2 ON tb1.a = tb...

 select convert(varchar, getdate(), 1) mm/dd/yy 12/30/06select convert(varchar, getdate(), 2) yy.mm.dd 06.12.30select convert(varchar, getdate(), 3) dd/mm/yy 30/12/06select convert(varchar, getdate(), 4) dd.mm.yy 30.12.06select convert(varchar, getdate(), 5) dd-mm-yy 30-12-06select convert(varchar, getdate(), 6) dd-Mon-yy 30 Dec 06select convert(varchar,...

Example::::SELECT GreyReceiveTypeName,FROM TBL...XYZ CASE GreyReceiveTypeName WHEN 'Bulk' THEN 'Bulk' WHEN 'Sample' THEN 'Sample' WHEN 'Order Related Sample' THEN 'Sample' WHEN 'Others Sample' THEN 'Sample' WHEN 'RETURN' THEN 'RETURN' WHEN 'Replacement' THEN 'Replacement' WHEN 'Coller Cuff' THEN 'Coller Cuff' WHEN 'Coller Cuff' THEN 'Short Qty'WHEN...

  var ItemList = [];    function GetSecurity_RosterShiftDetails() {                var obj = {                       RosteID: $('#dlRoster').val(),            EmployeeID: $('#txtEmployeeID').val(),   ...

 https://www.jqueryscript.net/demo/duplicate-remove-rows-patuta/<div>    <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>    <script type="text/javascript">        $(function () {            $('#btnTransfer').on('click',...

 <style>tr.group { border-top: 1px solid black; }</style><script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script><table id="tb" style="border-collapse:collapse;" cellpadding="5" width="500px">    <thead>        <tr>         ...