Recent content by Eluros

Thanks, Ken; that sounds like something worth pursuing. Appreciate the insight!

Hey, all, Let's say I have some locally hosted/downloaded JSON data like the following: user: { "firstName": "John", "lastName": "Smith", "age": 25, "address": { "streetAddress": "21 2nd Street", "city": "New York", "state"...

Thanks for the responses. I didn't realize that the order of operations required inner joins to be evaluated before outer joins. Appreciate the responses!

Greetings, I'm a bit surprised that these two queries give different results: SELECT a.number, a.name , b.* FROM Atable a LEFT OUTER JOIN Btable b JOIN Ctable c ON c.number = b.number ON b.number = a.number ORDER BY a.number; SELECT a.number, a.name , b.* FROM Atable a LEFT...

Well, this is certainly getting outside my prior knowledge (and part of why I'm asking-- hoping to learn some good stuff), it seems like it can tell the difference in other occasions. http://msdn.microsoft.com/en-us/library/ms178091(v=sql.105).aspx It says, including RAND, "The following...

Sure; there are several ways around it, I just think it's a silly problem in the first place. Doesn't it seem bizarre that a function that will always return the same value can't be called in a UDF? Just sounds arbitrary.

Greetings, Okay, for you fellow SQL geeks: SQL (or, at least, Microsoft/T-SQL) does not allow you to use rand() in a user-defined function, at least as of 2008 R2. It's non-deterministic, I get it, no problem. Here's the thing, though: if I pass a seed, such as rand(123456), it's no...

Never thought of it this way, but it makes sense. Good point; you've made your case and got me convinced. Thanks again!

Thanks, Eagle! We'll use the Schedule C for my wife. In terms of complicated... well, this year my wife has the income coming in and out for her writing/contract work, and I've been getting more heavily involved in microlending (via Prosper). The paperwork they give isn't very helpful, and...

EagleKeeper (et al), You're fantastic. I've looked through a lot of this thread, and it's really helpful. Thanks so much. :-) I have a specific question (which I'd love an answer to) and a general question (which'd be nice, but no pressure if it's outside the guidelines of the thread)...

I ended up seeing the ONKYO HT-S7409 on sale for $400 (which is about the cost of the receiver by itself, much less the whole 5.1 package) at Newegg: http://www.newegg.com/Product/Produc...20191&Tpk=7409 They've already bumped the price up to $500, unfortunately. I'll let you guys know how...

Greetings, For Christmas this year, my wife and I are splurging (yes, I know-- money is tight) and upgrading from our TV's internal speakers to some sort of surround sound setup. We have around $300 to play with. We're not very picky-- don't need wireless speakers/subwoofer, smartphone...

So, I was able to figure out the core problem: I was concatenating a series of values, one of which could have potentially been null. As I should have prepared for, value + null == null. I added a coalesce to replace any null values with empty strings and everything works as it should. Should...

I'm at home now-- I actually posted near the end of the day-- but I'll have a sanitized version tomorrow, hopefully. Thanks.

Greetings, So, for work, I have two queries, A and B. When run by itself, A returns 1 row (with 1 varchar column) and B returns 1984 rows (with 1 varchar column). Neither A nor B, by themselves, return any null results. However, when I run the following: A UNION ALL B 17 of the...