blogs.conchango.com

September 2006 - Posts

• Creating unique random number generator for SQL Server.

  I have worked on a project that required a random number, which had to be created within a certain range and be unique within the table that it’s going to be stored in. The uniqueness of the number only needed to apply to numbers that were marked Read More... Posted 14 September 2006 17:32 by steve.wright | 0 Comments Filed under: SQL Server

• Dynamic SQL Server ordering without using dynamic SQL.

  For my current project I have a stored procedure that needs to sort data by 1 of 3 columns depending upon the option chosen by the user from the application. This is only the dynamic part of the stored procedure, which also happens to be very complicated, Read More... Posted 14 September 2006 15:55 by steve.wright | 0 Comments Filed under: SQL Server 2005

• Reporting Services Report Viewer using SQL Authentication

  I have written some code, which will create a report and deploys it to a report server. However the connection string for the report has to use SQL Authentication. My code which builds the reports uses the same approach that Microsoft does to SQL Authentication Read More... Posted 14 September 2006 15:46 by steve.wright | 1 Comments Filed under: SQL Server, Reporting Services 2005, .Net 2.0