What pisses me off
- Thread starter FerretallicA
- Start date
Trying to consolidate various SQL queries into one... where's a 'computer questions' thread when I need it 
Hey Todd, you're a DBA right? I'm hoping your SQL chops are better than mine... reckon you could have a gander at my database dilemma and cast a pearl of your wisdom to this humble swine?
Celestial-Todd
The Incredible Bulk
Wish I could help dude but my SQL chops are shocking at the moment. I learnt quite alot of neat stuff but forgotten most of it through lack of use
whoneedstherapy
Merchant of the low end
thats something i need to look at getting upto speed on soon. Work is putting in a new system and even though i'm just the pricing gimp apparently im going to need to get upto speed on writing SQL extractions to pull all sorts of boring stats uke:
uke:
Falkor
J.B.C.M
I'm not too versed with SQL atm either, but can't you do your join like
purchases as p ON (p.members_id= m.memberid AND p.purchasedate < dateadd(m,1,m.signupdate)
purchases as p ON (p.members_id= m.memberid AND p.purchasedate < dateadd(m,1,m.signupdate)
If I do the join that way I'll then have to run two separate queries to get their total purchases and their eligible (ie- within one month) purchases. The idea is to consolidate the two queries into one. At the moment the catch I'm struggling with is trying to get the m.memberid from the main query's current interation into the subquery so I can use it to filter results there.
Falkor
J.B.C.M
No worries buddy, I've sorted it out now anyway. I must've been missing something simple last time because now it's working just by referencing m.memberid without having to specifically incorporate that table in the subquery.
Since you mention it though... I might have to pick your brain later about stored procedures
Is that the same thing as 'views' or something else?
Since you mention it though... I might have to pick your brain later about stored procedures
Is that the same thing as 'views' or something else?
Stormster
Somewhere Far Beyond
Getting a cold and gonna be feeling like shit tonite and for the next 6 days of work starting tommorow
Falkor
J.B.C.M
No worries buddy, I've sorted it out now anyway. I must've been missing something simple last time because now it's working just by referencing m.memberid without having to specifically incorporate that table in the subquery.
Since you mention it though... I might have to pick your brain later about stored procedures
Kinda yeah, Stored procedure is just the query etc is all stored on the server and you execute it.
Think of it as a function thats stored on the server, so you can have input variables etc and assign them. Then use them in the query or a number of queries and return the results.
They are very handy as they are seperate from the code itself, so you can edit them without editing the code
Emmz
God Of Forbidden Light
lol, Brendan, Ferrets a fucking brilliant guitarist, of course he would whoop your ass at Guitar Hero
Keeper of the Seven Cheese
Metallic Progressor
You'll probably win too. I make no claims to greatness. I don't even like the fucking game. I just saw Hangar 18 and YYZ and couldn't resist giving it a shot. That said... I'll still take you up on the challenge anyway
Emmz- it has a lot more to do with playing a lot of Dance Dance Revolution and Drummania than anything That thing was nothing like playing an actual guitar. It's more a test of hand-eye co-ordination than anything else.
Emmz- it has a lot more to do with playing a lot of Dance Dance Revolution and Drummania than anything
That thing was nothing like playing an actual guitar. It's more a test of hand-eye co-ordination than anything else.
Keeper of the Seven Cheese
Metallic Progressor
I used to attribute it to sight reading stuff from Guitar Pro then I realised I just pwn face at the shreds.
