Search results

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...
- JustAnAverageGuy
- Post #4
- Apr 9, 2013
- Forum: Programming
J
Newegg: Klipsch HD 500 5.1 system for $200 FS

Wallet forgive me...
- JustAnAverageGuy
- Post #3
- Aug 11, 2012
- Forum: Hot Deals and Giveaways
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
- JustAnAverageGuy
- Post #23
- Jul 29, 2012
- Forum: Programming
J
Easiest Program Language for Applications?

I'd say C#/WPF or Java would be the easiest depending on the platform.
- JustAnAverageGuy
- Post #2
- Jul 25, 2012
- Forum: Programming
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)=...
- JustAnAverageGuy
- Post #5
- Jul 24, 2012
- Forum: Programming
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(); }
- JustAnAverageGuy
- Post #3
- Jul 13, 2012
- Forum: Programming
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"...
- JustAnAverageGuy
- Post #4
- Jul 3, 2012
- Forum: Programming
J
Any desktop boards that allow 'Optimus'-like gpu handling?

Virtu?
- JustAnAverageGuy
- Post #2
- Jun 20, 2012
- Forum: Motherboards
J
Crucial 256 ssd $179.99 Egg with code

Had to bite on this one.
- JustAnAverageGuy
- Post #11
- Jun 16, 2012
- Forum: Hot Deals and Giveaways
J
ASRock L2.03 & L2.04 BIOS

yes
- JustAnAverageGuy
- Post #56
- Jun 3, 2012
- Forum: Motherboards
J
Need integers kept as '01' instead of '1'

LPAD(Number, 2, '0')
- JustAnAverageGuy
- Post #2
- Jun 2, 2012
- Forum: Programming
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.
- JustAnAverageGuy
- Post #5
- May 17, 2012
- Forum: Operating Systems
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.
- JustAnAverageGuy
- Post #6
- May 9, 2012
- Forum: Windows
J
ASRock L2.03 & L2.04 BIOS

Currently yes. No problems so far though...
- JustAnAverageGuy
- Post #24
- Apr 26, 2012
- Forum: Motherboards
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...
- JustAnAverageGuy
- Post #18
- Apr 24, 2012
- Forum: Motherboards
J
ASRock L2.03 & L2.04 BIOS

You should be able to. I was able to flash 2.03 with a sandy bridge.
- JustAnAverageGuy
- Post #15
- Apr 24, 2012
- Forum: Motherboards
J
ASRock L2.03 & L2.04 BIOS

The bios face lift was definitely nice. Just flashed both my Extreme3G3 and my M4's firmware. No ill effects... yet.
- JustAnAverageGuy
- Post #2
- Apr 19, 2012
- Forum: Motherboards
J
How to email out a website to people twice a week?

Probably easy enough to create an SQL job for it. Make a table that has a list of users receiving the email and a day on which they'd like to receive it. Then just have a page that modifies that table as necessary. Procedure: EmailAddresses[] = GetListOfRecipients() (SELECT Email from...
- JustAnAverageGuy
- Post #3
- Apr 15, 2012
- Forum: Programming
J
Fractal Design Arc Midi $69 with Free Shipping / Newegg

Awesome case. Love mine.
- JustAnAverageGuy
- Post #4
- Apr 12, 2012
- Forum: Hot Deals and Giveaways
J
how to scrub websites?

Print Screen?
- JustAnAverageGuy
- Post #10
- Apr 12, 2012
- Forum: Programming
J
Gen3 Motherboards and a PCI-E 2.1 card help.

It's still physically a PCIe x16 slot. It would just only run at PCI x4 speeds. Useful if you have a Tri-SLI/crossfire setup.
- JustAnAverageGuy
- Post #6
- Apr 10, 2012
- Forum: Motherboards
J
Gen3 Motherboards and a PCI-E 2.1 card help.

No. In your example, the Gen3 motherboards will have 3 PCIe x16 slots. Two of them will be Gen3, the x4 slot will be Gen2. You can put Gen2 video cards in Gen3 slots.
- JustAnAverageGuy
- Post #2
- Apr 9, 2012
- Forum: Motherboards
J
dynamic SQL query in a VB.net app

Perhaps not the most efficient way, but the way I typically handle this is to have the SQL server return all the values regardless and only display the ones the user chooses to see. Much easier to maintain as well.
- JustAnAverageGuy
- Post #2
- Mar 30, 2012
- Forum: Programming
J
ASRock Z68 Extreme3 Gen3 Mobo or any other Recommendations?

Been happily using mine since October. No complaints! Solid at 4.6.
- JustAnAverageGuy
- Post #10
- Mar 25, 2012
- Forum: Motherboards
J
Counting sequential duplicates (T-SQL)

Nice! Works great! Had been throwing my head against the desk all day yesterday on this one.
- JustAnAverageGuy
- Post #8
- Mar 8, 2012
- Forum: Programming
J
Counting sequential duplicates (T-SQL)

A group would be any set of rows not interrupted by any other action. e.g. Time Action Minutes Group 0:00 Action A 2 1 0:01 Action A 1 1 0:02 Action B 2 2 0:03 Action B 1 2 0:04 Action C 2 3 0:05 Action C 1 3 0:06 Action B 2 4 0:07 Action B 1 4 0:08 Action A 4 5 0:09 Action A 3 5 0:10...
- JustAnAverageGuy
- Post #3
- Mar 7, 2012
- Forum: Programming
J
Counting sequential duplicates (T-SQL)

I have a table which lists the minutes for a day and the action being taken at that time. For reasons I'm not going to get into, it is in the general format Time Action ---- ------ 00:00 Action a 00:01 Action b 00:02 Action c ... 23:57 Action x 23:58 Action y 23:59 Action z...
- JustAnAverageGuy
- Thread
- Mar 7, 2012
- Replies: 8
- Forum: Programming
J
Stupid Question about Win 7 activation on new mobo

I transferred an student license to a new system just fine.
- JustAnAverageGuy
- Post #9
- Feb 28, 2012
- Forum: Operating Systems
J
Purpose of 2 or more optical drives?

Optical drives, fan controllers, sound card expansion slots, etc.
- JustAnAverageGuy
- Post #3
- Feb 21, 2012
- Forum: Computer Building
J
Power Protection UPS

No complaints against my APC unit. Has worked as advertised for about a year and a half now.
- JustAnAverageGuy
- Post #4
- Feb 11, 2012
- Forum: Computer Building
J
SATA cable question

It should have 4 SATA 3Gb/s ports. SATA 1.5, 3.0, and 6.0 are all compatible. unless you have a really high end SSD, 3.0 is sufficient for most drives.
- JustAnAverageGuy
- Post #3
- Feb 4, 2012
- Forum: Motherboards
J
Flash has been crashing my browser all day; switched to HTML5 player.

Bears repeating. The solution worked when I did it earlier this week. No problems since.
- JustAnAverageGuy
- Post #30
- Feb 2, 2012
- Forum: Windows
J
SAYONARA ABIT COMPUTER - Website will EOL end of this month so one last view!

Asrock, Asus, Gigabyte, MSI, and Intel are the only ones worth counting.
- JustAnAverageGuy
- Post #17
- Feb 1, 2012
- Forum: Motherboards
J
Beginner Java question

See correction. The reason you're getting the answer you are is due to the way certain values are stored. Even though you've declared them as doubles, you assigned them integer values. int / int= int (even if the result has decimals, they are truncated) int / double = double (result is...
- JustAnAverageGuy
- Post #2
- Jan 31, 2012
- Forum: Programming
J
New build, can I get a couple thoughts regarding it?

If you live near a MicroCenter, they typically run some pretty good deals on 2500k/Z68 motherboard combos. If you're spending money anyway, the motherboard isn't a bad place to plop a little extra down for. I can't speak for the 3D glasses or monitor. PSU and RAM were discussed...
- JustAnAverageGuy
- Post #7
- Jan 30, 2012
- Forum: Computer Building
J
New build, can I get a couple thoughts regarding it?

The memory controller in the 2500k is dual channel, not triple. I haven't had a problem with mine at all. Sitting pretty @ 4.6GHz. It was prime stable at 4.8GHz, but I lowered it a bit for daily use due to temperatures. Of course YMMV.
- JustAnAverageGuy
- Post #5
- Jan 30, 2012
- Forum: Computer Building
J
New build, can I get a couple thoughts regarding it?

Power supply is overkill. You'll want RAM is multiples of two, not three. Motherboard may be overkill, but it's a solid choice. If you don't need all the fancy features on the Asus, this one is pretty decent ASRock Z68 Extreme3 Gen3 This PSU is also more than you need, but it's $50 cheaper...
- JustAnAverageGuy
- Post #2
- Jan 30, 2012
- Forum: Computer Building
J
After installing WinXP, what's the fastest way to install all the Windows Updates?

SP3 is an all-inclusive update. It has everything that was released before it bundled in. Do the SP3 update first, then what's left should just be the new stuff that came out after it was released. It does, but you have to explicitly choose it due to it's potential size and that major...
- JustAnAverageGuy
- Post #2
- Jan 29, 2012
- Forum: Operating Systems
J
What special characters to allow in name field?

[a-z][A-Z]
- JustAnAverageGuy
- Post #2
- Jan 25, 2012
- Forum: Programming
J
Is there a best practice equivalent of interfaces in database design?

I would probably have both company and person in the same field 'AccountHolder' and have another field 'EntityType' to differentiate between them. Have a separate table for company data which references the primary key of the Accounts table.
- JustAnAverageGuy
- Post #4
- Jan 24, 2012
- Forum: Programming

RESOURCES

Top Bottom