Recent content by JustAnAverageGuy

  1. J

    Help with T-SQL query

    Ancalagon44 Is correct. You're looking for a cross join. A SQL Server sample since source tables aren't available. ;WITH TenYears as ( SELECT top 10 YEAR(DATEADD(YEAR, -ROW_NUMBER() OVER (ORDER BY o.Object_id) + 1, GETDATE())) [Year] FROM sys.all_objects o ), TwoHundredNums as ( SELECT top...
  2. J

    What standard naming is best used for multiple word variables?

    I've tend to use lowerCaseFirstLetter private variable, UpperCaseFirstLetter function, and MEANINGFULLY_NAMED_CONSTANT
  3. J

    Easiest Program Language for Applications?

    I'd say C#/WPF or Java would be the easiest depending on the platform.
  4. J

    SQL Help: Calculating salary change for employees

    SELECT Start.EmployeeID, Start.Year, Start.Salary as SalaryBeginning, End.Year, End.Salary as SalaryEnding, End.Salary-Start.Salary as SalaryChange FROM Employees Start LEFT JOIN Employees End on Start.EmployeeID = End.EmployeeID and (Start.Year + 1)=...
  5. J

    Want to toggle content with a drop down without hitting a submit button.

    or, in ASP.NET <asp:DropdownList ID="ddlState" runat="server" AutoPostBack="true" OnSelectedIndexChanged="StateChanged" /> protected void StateChanged(object sender, EventArgs e) { LoadPrices(); }
  6. J

    C# inserting in to a DB...Need help

    SqlConnection sc = new SqlConnection("blahblahblah"); sc.Open(); SqlCommand insertCommand = new SqlCommand("INSERT into GetHoleCardRank (HoleCards, Rank, HandsPlayed, HandsWon) VALUES (@HoleCards, @Rank, @HandsPlayed, @HandsWon)", sc); insertCommand.Parameters.AddWithValue("HoleCards"...
  7. J

    Crucial 256 ssd $179.99 Egg with code

    Had to bite on this one.
  8. J

    Need integers kept as '01' instead of '1'

    LPAD(Number, 2, '0')
  9. J

    Win7 64 better than Win7 32 on 4Gb motherboard?

    Keep in mind that with 32-bit, that 4GB of addressable memory also includes your video card's memory, motherboard, etc. I'd recommend getting the 64-bit.
  10. J

    Paragon alignment question

    If the SSD isn't detected in the BIOS, no software tool in an operating system is going to fix your problem.
  11. J

    ASRock L2.03 & L2.04 BIOS

    Currently yes. No problems so far though...
  12. J

    ASRock L2.03 & L2.04 BIOS

    No. I didn't have any problems on my Extreme3 Gen3. Just flashed up to 2.04. I'll let you know if anything goes up in smoke...