Sunday, 18 September 2011

Delete duplicate rows

Posted by Sanjeet Kumar Satpathy at 12:15 Labels: 0 comments

SET ROWCOUNT 1
delete emp from emp a where (select count(*) from emp b where a.name=b.name) >1
WHILE @@rowcount > 0
delete emp from emp a where (select count(*) from emp b where a.name=b.name) >1
SET ROWCOUNT 0

or


DELETE
FROM MyTable
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY DuplicateColumn1, DuplicateColumn2, DuplicateColumn3)

or



WITH empTable as
(
SELECT ROW_NUMBER() Over(PARTITION BY EmpName,Position ORDER BY EmpName) As RowNumber,* FROM emp
)
DELETE FROM  empTable  where RowNumber >1
SELECT * FROM emp order by Id asc

Display row by Radio button selected change

Posted by Sanjeet Kumar Satpathy at 12:11 Labels: 0 comments

function DisplayRowonRbl()
{     
     var trDesignation= document.getElementById('<%=trDesignation.ClientID%>');
     var tblDepartment= document.getElementById('<%=tblDepartment.ClientID%>');
      var s=document.getElementById('<%=rbnDepartment.ClientID%>');
      var s1=s.getElementsByTagName('input');
      for (var i = 0; i < s1.length; i++)
      {
          if (s1[i].checked && s1[i].value=='Others')
          {
                trDesignation.style.display = '';
                tblDepartment.style.display = 'none';
           }
           else
           {
                  tblDepartment.style.display = '';
                  trDesignation.style.display = 'none';
                 }
            }
   }

Call the above method on the selected change properties of radiobutton.

Friday, 9 September 2011

Open a new window in pop up with print option

Posted by Sanjeet Kumar Satpathy at 23:05 Labels: 0 comments

Call the below function in the OnClientClick of the button.

<script language="javascript">
function Clickheretoprint()
{
  var disp_setting="toolbar=yes,location=no,directories=yes,menubar=yes,";
      disp_setting+="scrollbars=yes,width=650, height=600, left=100, top=25";
  var content_vlue = document.getElementById("print_content").innerHTML;
 
  var docprint=window.open("","",disp_setting);
   docprint.document.open();
   docprint.document.write('<html><head><title>Home Page</title>');
   docprint.document.write('</head><body onLoad="self.print()"><center>');        
   docprint.document.write(content_vlue);        
   docprint.document.write('</center></body></html>');
   docprint.document.close();
   docprint.focus();
}
</script>

Friday, 19 August 2011

Non Clustered indexes per tabel

Posted by Sanjeet Kumar Satpathy at 21:32 Labels: 0 comments

In Sql Server 2008 32 Bit addition ,following are the limit for Non Cluster Index and Cluster Index

Clustered indexes per table: 1

None clustered per table: 999

Nested sub queries: 32

Nested trigger levels: 32

Parameters per stored procedure: 2100

Parameters per user-defined function: 210
Subscribe to: Posts (Atom)