|
V. wrote: walk in a straight line
that's what I always do just to prove to my friends that I'm not drunk.
And I always succeed.
Don't mind those people who say you're not HOT. At least you know you're COOL.
I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
|
|
|
|
|
V. wrote: to walk in a straight line
I am only able to do that when I am drunk.
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
Seeing as how he died 20 years ago yesterday;
Quote: They changed that drunk driving sh*t. The attitude is just too harsh for me. Way too harsh. You remember ten years ago if you got pulled over the cop came up to your car and said 'son, you been drinking?' Yeah. 'Oh, sorry to bother you. Don't want to bring your buzz down any. Get on outta here and have yourself some fun. Drink one for us. [laughs] We'll be joinin' ya right after duty. Okay bye-bye. Get back in the car Tommy it's just a drunk man behind the wheel of an automobile, that's all.' You remember that? Now you are the murderer. Remember the time when you'd go 'Why don't you go catch murderers?' YOU are the f***in' murderer. And they're gunna nail ya man. That got that field sobriety test. Guaranteed. They start off slow, I love it. Walk a straight line. Well sh*t, I've been so drunk I've peed in my own pants, but I could skip a f***in' straight line. Touch your nose. Dude, I could shoot thorazine into my heart and still find my f***in' nose. Never understood that one at all (wraps arm around head and touches nose). Are people out there who cannot find their nose? It's right there never will it move I don't care how f***in' drunk I am. I could have no arms and still find my f***in' nose (bends over and raises foot up to nose). But then the kicker: say the alphabet backwards. Well sh*t, ya got me. I'm not drunk but I'm obviously too stupid to be driving god dammit. Somebody can actually do this? What kind of sobriety test is this? They're makin' this sh*t up as they go. They're havin' fun with ya. You're jumpin' through hoops for these guys. They're going 'Sh*t do a flip. Come here son and put your dick in our exhaust pipe, do it right now.' Sh*t I never heard of this one, (mimics taking off pants) but these are officers they know what they're doing. God damn that's hot. Sh*t how long have they been chasing us? F***. Man, they're just havin' fun with ya. This has nothing to do with a sobriety test, you're auditioning for your freedom, you think. They humiliate you for their own amusement then they pop you. So I say f*** it. 'Walk a straight line, touch your nose.' F*** it I'm drunk. I might puke if I start movin' around a lot. How 'bout this officer how 'bout you carry me to the back of your car, think I'll start my eighteen hour nap right now buddy. You ever seen vomit go through that mesh screen between the front and back seat of their cars? Oh yeah, you're going to rue the day you pulled me over buddy. I've been eating bar olives for three days straight. I don't think it's going to go with your crispy blues. Wouldn't that be great to be too drunk to bust? 'Screw it let 'em go. Boy he did a nice flip though didn't he? Touchin' his nose the whole way around.' Touch your nose. Every f***in' time. Never will I miss my nose.
Some men are born mediocre, some men achieve mediocrity, and some men have mediocrity thrust upon them.
|
|
|
|
|
To establish probable cause for the traffic stop. Once the officer proves behind a reasonable persons doubt that you are intoxicated then they compel you to take the test as a reasonable suspicion of being drunk.
That, and have you ever seen super troopers? These guys get bored and just want to see what the people will come up with. Have you seen the video of the guy attempting a backflip and face planting?
|
|
|
|
|
Yeah....go through all the gyrations of proving you're completely in control of all your faculties...but get busted anyway because the law says you're not in control. :p
But, for your entertainment.[^]
|
|
|
|
|
Yeah I just finished debugging and writing my most complicated SQL script ever!
Though is only 300 lines long it has:
- create user defined table type
- used it in the stored proc defined below as argument
- use WHILE with BREAK and CONTINUE
- use IF
- create @Memory Tables
- use CTE
- use UNION
- use CASE in select, where and having
- use inner and outer join
- use group by, having, sum,
Yeah!
It's for an advanced dynamic user search (arbitrary number of arbitrary criteria and or/and condition on an arbitrary complicated tree of joined data table) (arbitrary here means user defined!)
|
|
|
|
|
Ravi Khoda
|
|
|
|
|
Ta!
|
|
|
|
|
Super Lloyd wrote: - create user defined table type
- used it in the stored proc defined below as argument
- use WHILE with BREAK and CONTINUE
- use IF
- create @MemoryTables
- use CTE
- use UNION
- use CASE in select, where and having
- use inner and outer join
- use group by, having, sum,
Now do it in LINQ.
|
|
|
|
|
|
This is one nasty query that see no LINQ statement ever!
Althoug, to be fair I thought of it! but.. no...
|
|
|
|
|
Super Lloyd wrote: This is one nasty query that see no LINQ statement ever!
I was just wondering if it would be more readable as the LINQ folks claim.
I used SQL for many years before going over to LINQ but that is just a personal decision. They both work.
|
|
|
|
|
Amongst other thing I don't quite think it is possible. I do a join with a user defined table type, which would be a join between an IList and an IQueryable. Not supported by LINQ
Further I doubt I can make it all happen in just one db call..
|
|
|
|
|
Super Lloyd wrote: Amongst other thing I don't quite think it is possible. I do a join with a user defined table type, which would be a join between an IList and an IQueryable. Not supported by LINQ
Shame on you.
|
|
|
|
|
But yeah I like both!
I prefer LINQ 95% of the time, but I jump happily at SQL for the remaining nasty bits! ^_^
|
|
|
|
|
Super Lloyd wrote: I jump happily at SQL for the remaining nasty bits!
Nasty it is.
|
|
|
|
|
You forgot to squeeze a GOTO into the mix...in mine below, I was working with batch deletion due to space constraints and variable daily record commits and didn't want any human intervention.
Developing Automated Data Purge Solution[^]
|
|
|
|
|
Well... I like goto all the more for the fierce resistance and steamy debate it creates...
But I am afraid it will be a too costly battle over where I am now!
|
|
|
|
|
Don't mind those people who say you're not HOT. At least you know you're COOL.
I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
|
|
|
|
|
it ain't advanced with out a
DELETE FROM table statement
|
|
|
|
|
Can you post the code so we can see it?
|
|
|
|
|
back home now!!
I might put it on weird and wonderful tomorrow!?!
|
|
|
|
|
OK make sure to notify me then.
|
|
|
|
|
Oke doke!!
|
|
|
|
|
BTW give you an idea in pseudo C#, I search for RTF by looking at all the below fields
RTF
int ID
string Name
AnswerSet Answer
AnswerSet
DateTime LastModified
string ModifiedBy
List<Answer>
Answer
int questionID
AnswerType type
string vString
decimal vNum
Date vDate
bool vBool
List<Option> vOptions
Option
int ID
string Name
now the user can build with a simple UI a list of criteria which looks like that
Criteria
int groupID
bool isGroupAndOrOr
CriteriaType cType
int? questionID
int? wellKnowID
object value
|
|
|
|