Hampton Roads (SE Virginia) Rotary Club
#7677
Rotary Freak
iTrader: (1)
Join Date: Mar 2004
Location: Grafton ,Va
Posts: 2,063
Likes: 0
Received 0 Likes
on
0 Posts
Yeah, I like the Intermediate road race seat as well. I think the Kirkey is built a little better than the similiar Ultrachield, but I think you can't go bad either way.
The rib supports on aluminum seats are designed to flex some and decelerate slowly. It is not a bad design and works pretty well. If you remember right I broke my ribs at AIK the first time I went there. I also have allergies that were in bloom when I broke my ribs. So you can imagine the pain that the sneezing was putting me through. It was a shot of pain that litterally would make me blackout occasionally.
The rib supports on aluminum seats are designed to flex some and decelerate slowly. It is not a bad design and works pretty well. If you remember right I broke my ribs at AIK the first time I went there. I also have allergies that were in bloom when I broke my ribs. So you can imagine the pain that the sneezing was putting me through. It was a shot of pain that litterally would make me blackout occasionally.
Va
#7678
Junior Member
Join Date: Aug 2006
Location: Kent island md
Posts: 24
Likes: 0
Received 0 Likes
on
0 Posts
GOT SCREWED BAD by a local member
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 ******
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 ******
#7680
Senior Member
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
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
#7681
Rotary Freak
iTrader: (1)
Join Date: Oct 2003
Location: Hampton, Va
Posts: 2,506
Likes: 0
Received 0 Likes
on
0 Posts
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
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
#7682
Rotary Freak
iTrader: (1)
Join Date: Mar 2004
Location: Grafton ,Va
Posts: 2,063
Likes: 0
Received 0 Likes
on
0 Posts
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 ******
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 ******
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
#7684
No es bueno.
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
#7686
Total Rotary Domination!
iTrader: (17)
House Renovation is a pain in the ****!!
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
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
#7691
Rotary Freak
iTrader: (1)
Join Date: Mar 2004
Location: Grafton ,Va
Posts: 2,063
Likes: 0
Received 0 Likes
on
0 Posts
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
Maybe next time
#7693
Rotary Freak
iTrader: (1)
Join Date: Oct 2003
Location: Hampton, Va
Posts: 2,506
Likes: 0
Received 0 Likes
on
0 Posts
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!
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!
#7696
Happy Squirter
Join Date: Feb 2004
Location: Lyman, SC
Posts: 263
Likes: 0
Received 0 Likes
on
0 Posts
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.
Last edited by dbgeek; 06-24-07 at 08:54 AM.
#7698
Happy Squirter
Join Date: Feb 2004
Location: Lyman, SC
Posts: 263
Likes: 0
Received 0 Likes
on
0 Posts
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
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
#7699
Rotary Freak
iTrader: (1)
Join Date: Oct 2003
Location: Hampton, Va
Posts: 2,506
Likes: 0
Received 0 Likes
on
0 Posts
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
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
#7700
Rotary Freak
iTrader: (1)
Join Date: Mar 2004
Location: Grafton ,Va
Posts: 2,063
Likes: 0
Received 0 Likes
on
0 Posts
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
Thanks