dbgeek

ROFL

I went in for a physical about 3 days after cracking the rib. The good ole hernia test went like this:

doc: cough
me: no
doc: huh?

VaGambler

iTrader: (1)

Oh hell no , there is no way I wouldgo through that , ahahhah at least no that Im old and fat .

Va

pistonkiller

well i havent been on here for awhile with work and building my baby well over the winter i was on a quest to build a tll beast with the best stuff i could get . so i looked on here for a motor and i found one that really striked my interest from a member rotaryconcepts007 aka sean works at a lube shop in williams berg. had a freshly built bp motor wit all new seals new this that and the other talked a real good one .drove 5 hrs to williamsberg va to see the motor i started and ran fine. went home slept on it came back the next week to buy it got it home then we started the project garrett t70 turbo, hks 50 mm wastegate, 4 1600 cc injectors. 2 wallboro fuel pumps lines, kg parts fuel rails , apexi power fc with adaptor harness from banzi-racing great product by the way. after months of building this beast and about ten grand in parts i start her up success major hard on lol then the problem occurs 2 days before the dyno visit to pfs supercars (great guys) major oil leak in the rear housing **** the dyno is 2 days away temp fix it with silicon. wait till next day to see if it worked sweet it did drove around the block making 2 psi of boost needs dyno tuned no leaks sweet major hard on. go home call it a day . next day starts up fine let her warm up for break in since io was told there were ony 1 thousand miles on it no leaks eaither dyno tomarrow . well here is where the **** hits the fan dyno day start her up drive it to the end of the block to put her on the trailer cause there is no room to turn around on our street get to the trailer it stalls out on its own ok i thought ill just get the trailer open and she will be fine nope she dont wanna start **** what happened get it in the garage check the plugs maybe the got fouled out nope they are fine flodded maybe crank it over with no plugs in the bottom **** compression sounds funny hmm check it sure enough 65 psi front 80 rear mother ****** i got the shaft tear the motor down everything was used seals springs the whole thing was garbage rear iron was cracked i 3 spots near the oil filter damn all that money for a ******* paper weight housings were flaking like a mo fo so needless to say that ****** sean aka rotaryconcepts007 is a ******* liar i paid for a fuclking piece of **** you got me but if you read this little boy i believe you said to me that you hate scammers and that bad karma is a mother ****** well guess what you fucked me bad now its time for you to pay


ROTARYCONCEPTS007 is a ******* LIAR and a thief dont trust him works at a lube shoppe in williams berg va

remember buddy bad karma is a mother ******

yuichiror

iTrader: (1)

Wow, that's two against Sean...

RichRotorhead

Nah, just go to Pep Boys or any other Auto Part Store and tell them that you want spring spacers. They'll ask you how much of a lift you need, and they'll sqaure you away.

I leraned this trick years ago when my driver side suspension would sag so much that my fenders would constantly rub my tires. Man was I relieved, after I installed them.

Good Luck.

-Rich

yuichiror

iTrader: (1)

LOL, that's assuming I have spring compressors and a clue on how to do suspension work.

VaGambler

iTrader: (1)

Hey bud , sorry you did not ask this board earlier, but you got totaly screwed by this guy . He did not have 1000 miles on that engine but more like 50 . Randy told him not to run it , but it was Shaun's motor ( with a ton of help from everyone in our little group. He got it fired up in a drive way , drove it a few blocks , took it to the track ( Langley) and got his *** handed to him by everyone ( trucks , I think even a yugo. haha ) I posted my case to this forum a while back and was disapointed to the response . No one but me and one or 2 others called him out !!! He has just reciently told me to" get over it no one really cares ". I will leave it at this . If my fellow RX 7 members associate with this thief , you have lost all my respect . I have never done another person wrong in any way ( that I know of ) not to mention a fellow RX 7 member . I hear he has been going to Langley, but running!!!! WEAK ***!!!!!!!! I will have the last say on this one .

Sorry "Rotary Concepts 007 " screwded you too . But this fool has no clue what he is doing . Feel free to Pm me if you need any legal recourse .

Good luck

Va

FJDRX7

iTrader: (32)

since when you start drinking Heineken????? wasup with the Milwakee's Best ??? and thats a daaamm good beer there, lol

ProjectR13B

iTrader: (1)

so, i was thinking "you know what would be cool, a 13bt AE86 drift car" then i was thinking " you know what would be cool, finishing my current projects" and for my final thoughts are "RX-7s are the cheapest and most costly cars i've ever owned. pay nothing for one, then do nothing but dump money into it." haha don't know why i felt the need to share that with you guys, but i think we all have mutual feelings about this subject haha

Rotaryhaven

iTrader: (17)

I have to be too drunk and poor for Milwaukee's Best. Rather drink Nyquil than that.

Rotaryhaven

iTrader: (17)

My house is getting ripped apart in the inside. I had both full baths upstairs redone, what a nightmare! Still a little more details like flooring and paint color are in the works.

My whole 1st floor is getting repainted. I had a wall knocked out also and blended the sheetrock.

New living room set and two more new bedroom sets. (My wife drives me crazy, like to change furniture out every 2 to 3 years)

Future construction:


Possible new siding or a good repaint on the exterior
New garage doors on house
New garage in the back, barn style, two story.
Concrete driveway from the back yard to tie in my current driveway.

No time to work on cars right now, too busy with the house

ProjectR13B

iTrader: (1)

this was one of the cleanest 7s there i think. mostly stock.

damn jerry, sounds like you have some projects ahead of you man haha.

VaGambler

iTrader: (1)

good looking cars ,

Thanks for the pics

yuichiror

iTrader: (1)

Who's commin' to Hooter's today?

Any one have any spare soleniods from the rats nest under the UIM? I think my Charge Relief soleniod has gone bad. Thanks!

jl1rx7

iTrader: (1)

I know I am, sorry dont have FD parts.

VaGambler

iTrader: (1)

Sorry I missed you guys yesterday , but I never made it to Hampton . I was suppose to go out to Wallace marinia for watch the winners of the Cobia tournament , and was going to stop by on my way home . But like I said , I never made it out .

Maybe next time

ProjectR13B

iTrader: (1)

sorry guys, i thought it was next saterday. haha. i was go karting in VA Beach, and I won =)

yuichiror

iTrader: (1)

Hey Cal, this is the sql I've come up with so far:

select count(w.procid) as ontime , '' as overdue, '' as soon, w.prtcpname from witem w
where w.state = 'I'
and w.prtcp in (select prtcp from usrgrpprtcp where usrgrpid = '0000000463')
group by w.prtcpname
union
select '' as ontime , count(w.procid) as overdue, '' as soon, w.prtcpname from witem w
where w.state = 'V'
and w.prtcp in (select prtcp from usrgrpprtcp where usrgrpid = '0000000463')
group by w.prtcpname
union
select '' as ontime , '' as overdue, count(w.procid) as soon, w.prtcpname from witem w
where w.state = 'I'
and w.prtcp in (select prtcp from usrgrpprtcp where usrgrpid = '0000000463')
and CONVERT( float, GETDATE()) + 3 > CONVERT( float, deadlinedtime)
group by w.prtcpname


Basically I want to create four columns: ontime, overdue, soon, and prtcpname. In the table, when an item is overdue, state = 'V', when an item is current state = 'I'. Otherwise I ignore entries where state not in ('V', 'I').

With the statement above I get a resultset like this:

ontime, overdue, soon, prtcpname
2, 0, 0, jody
4, 0, 0, yo
0, 4, 0, jody
0, 1, 0, yo
0, 0, 1, jody
0, 0, 1, yo

What I'm looking for is a result set like this:

ontime, overdue, soon, prtcpname
2, 4, 1, jody
4, 1, 1, yo


I've attached a zip file that contains spreadsheets with the structure and sample data of the tables I'm working with.

Thanks for taking a look!

ProjectR13B

iTrader: (1)

I managed to get my gauge cluster reinstalled in the FC today and the speedometer caple hooked back up. hopefully i can get the wiring for the tranny done soon, and my drive shaft on. then i just need new fluids and i think im good to get the FC on the street.

VaGambler

iTrader: (1)

hey bud if you need any help durring the day feel free to call . My work is slow right now and I have some free time durring the week .

Hope I can help you out

Va

dbgeek

yuichiror, the reason you are getting more results than you want is because you have 3 different select statements providing results, each grouped by the name. If there are 2 names, you'll get 6 results.

yuichiror

iTrader: (1)

Thanks! Like I said, I couldn't come up with a single query that would give me the resultset I wanted based on the 3 different conditions. Thanks again!

dbgeek

I got busy yesterday, so I'll see what I can do today. Is this a stored procedure? If so, we can build variables and populate them with the data, and finish by just displaying what you want. The problem with that is you need to deal with a recordset coming out.

It would help to know what is executing the query, and what the database type is - Access, SQL, Oracle, DB4?

Is this going to be built into an application or for information only? If being built in, I'd create a stored procedure that does this. If information only, I can make a SQL Query analyzer give the result you want.

My fiancee and I do this crap for a living

yuichiror

iTrader: (1)

Thanks dude! I'm writing this to create a report in MS SQL Reporting. I'd prefer a flat statement over a stored proc, but as long as I get the resultset I want, I guess it doesn't really matter. Right now I using it against a MS SQL server, but if there's any MSSQL specific code, I'll have to adjust it for Oracle later.

VaGambler

iTrader: (1)

does anyone know of a guy named Ed Markings he goes by 9sec7, he lives in Norlfolk . Just want to find out if this guy is good to his work or another snake in the grass like Shaun

Thanks