I recently had to create a report that needed adjacent columns of serial numbers much like columns in a Word document. I pored over several advices but in the end discretely defining the number of serial numbers per column worked out best. I used the code below to get a row number and list them…

  SELECT Order_Master.ORDNUM_10, CM.NAME_23, CM.COMNT1_23, CM.COMNT2_23, CM.UDFREF_23FROM Order_Master INNER JOINSO_Master SMon LEFT(CUSORD_10,8) = SM.ORDNUM_27inner join Customer_Master CM on SM.CUSTID_27 = CM.CUSTID_23WHERE – Add anything here that you need to select the proper record set.

    @echo =========  SQL Server Ports  ===================@echo Enabling SQLServer default instance port 1433netsh firewall set portopening TCP 1433 “SQLServer” @echo Enabling Dedicated Admin Connection port 1434netsh firewall set portopening TCP 1434 “SQL Admin Connection” @echo Enabling conventional SQL Server Service Broker port 4022  netsh firewall set portopening TCP 4022 “SQL Service Broker” @echo Enabling…