codingguy3000

codingguy3000 has asked 27 questions and find answers to 13 problems.

Stats

About

I am a SQL Server developer

codingguy3000 questions

In C# can you perform a Range Select within a Range Select?
In SQL Server can you find the first number in a string?
C# Combobox (winforms) how can I make the values appear as percentage
How can you tell if a Sql Server Stored Procedure returns records
Default column value based on the value of a different column
SQL Server Pivots... Can I show the last five orders for a series of order types
How can I include a class library into a (non MVC) ASP.net Razor website so that I don't have to use the using statement?
How do you take an XML file and insert its values into a database table using SSIS (SQL Server 2005)
In SSIS, when defining a fixed flat file length flat file connection, is there a way to programmatically define the columns?
SQL Server 2005 IsNumeric Not catching '0310D45'

codingguy3000 answers

how can join a query result set with an existing table?
How to make sure a row cannot be accidentally deleted in SQL Server?
Does Adding "TOP 1" to a sql statement increase performance signficantly?