comp.databases.pick
  Home FAQ Contact Sign in
comp.databases.pick only
 
Advanced search
September 2008
motuwethfrsasuw
1234567 36
891011121314 37
15161718192021 38
22232425262728 39
2930      40
2008
 Jan   Feb   Mar   Apr 
 May   Jun   Jul   Aug 
 Sep   Oct   Nov   Dec 
2008 2007 2006  
total
comp.databases.pick Profile…
RELATED GROUPS

POPULAR GROUPS

more...

 Up
  More SQL Hell         


Author: Kevin Powick
Date: Sep 6, 2008 14:22

I needed some information from a client's MS SQL Server database.
Below is the query their programmer sent me to get what I needed. It
worked, but....OMG is SQL awful stuff.

select
(select u.userFullNameLastFirst from users u where u.userCode =
l.userCode) as UserName,
l.logTotalSeconds as UserTimeSeconds,
a.OrderNumber as OrderNumber,
(select CustomerName from Customer where...
Show full article (1.90Kb)
4 Comments
  Help Convert File         


Author: SFBoater
Date: Sep 4, 2008 22:56

I have files that I *think* are a really old version of universe...

I tried writting a parser but have been having trouble finding any
real documentation on the file format...

I think I can see the record marker as 0xFF and the FIELD seperators
as 0xFE with multivalue and sub markers 0xFD and 0xFC

I do not get a consistenet number of fields per record and other
oddities.

Any help or point me in the right direction... I clearly have no idea
how to do anything pick, but I am a pretty good engineer so a simple
file format defintion would solve a lot of my issues. I see more than
a few unprintalbe bytes so I think that they are trying to tell me
something but I cant seem to figure it out...

All the files start with a similar Hex sequence: 0a 01 ef ac

Can anyone help?
17 Comments
  test         


Author: alpingtonwright
Date: Sep 3, 2008 18:31

uk.legal, us.legal, uk.politics.misc, alt.alt.alt.alt.alt
no comments
  hey lets all smash our televisions up         


Author: alpingtonwright
Date: Sep 3, 2008 17:48

television is evil and indoctrinating evil political device
1 Comment
  he works here not         


Author: alpingtonwright
Date: Sep 3, 2008 17:44

brent used to work for:

http://www.prague-tribune.cz/2004/1/img/p5_6.jpg

now he works for:

http://www.catellaproperty.com/

hey im a witch and all the property deals hes doing now for catella
group are cursed cursed by me

pitiful liberalism

crush that insect

i want to inform people who he is

he killed a girl in a frenzied attack
no comments
  killer on the run working in property         


Author: alpingtonwright
Date: Sep 3, 2008 17:38

working for http://www.catellaproperty.com/

now

i forgot it

heres andrew brent in the company before

http://www.prague-tribune.cz/2004/1/img/p5_6.jpg

he killed a shopgirl in a "frenzied attack"

From the Lancashire Evening Telegraph, first published Thursday 28th
Dec 1995.

THE man who murdered shop assistant Janet Cheetham in December 1981,
is wanted for questioning by police officers investigating the murder
of schoolgirl Louise Sellars.

Andrew Brent, 30, escaped from the prison service on June 17 of this
year while on day release from Sudbury Open Prison in Derbyshire.

St Helens police carried out house-to-house inquiries in St Helens and
Knowsley when news of Brent's escape was released and they believe
that the fugitive, who speaks several different languages, could have
fled abroad.
Show full article (2.42Kb)
no comments
  killer on the run working in property         


Author: alpingtonwright
Date: Sep 3, 2008 17:37

working for http://www.catellaproperty.com/

now

i forgot it

heres andrew brent in the company before

http://www.prague-tribune.cz/2004/1/img/p5_6.jpg

he killed a shopgirl in a "frenzied attack"

From the Lancashire Evening Telegraph, first published Thursday 28th
Dec 1995.

THE man who murdered shop assistant Janet Cheetham in December 1981,
is wanted for questioning by police officers investigating the murder
of schoolgirl Louise Sellars.

Andrew Brent, 30, escaped from the prison service on June 17 of this
year while on day release from Sudbury Open Prison in Derbyshire.

St Helens police carried out house-to-house inquiries in St Helens and
Knowsley when news of Brent's escape was released and they believe
that the fugitive, who speaks several different languages, could have
fled abroad.
Show full article (2.42Kb)
no comments
  you sick psychotic idiot andrew brent known as andrew brent-smith in europe         


Author: alpingtonwright
Date: Sep 3, 2008 17:34

andrew brent woo hoo : http://www.prague-tribune.cz/2004/1/img/p5_6.jpg

everything you said

the normal children had to deal with you for 5 years? you clawed your
way out of that shit you tried to lie your out of it all the time you
had your cronies you always owned the tennis ball in the game

how does it look now how does it look now you idiot

andrew brent : janet cheetham

you murdered a shopgirl

humans beware
no comments
  you followed me once to the bus stop         


Author: Tronic
Date: Sep 3, 2008 17:27

you threatened me all you could do i was getting bigger than you did
you know i won a fight with swain?

so
no comments
  ANDREW BRENT         


Author: Tronic
Date: Sep 3, 2008 16:40

http://www.prague-tribune.cz/2004/1/img/p5_6.jpg

the man on the left is andrew brent

now called andrew brent-smith

the people on the right of him don't know who he is
his employers don't know who he is

a few property deals in the czech republic

major buildings

he hit the front cover of the daily mail one time he was photographed
running he was a trainee football referee

worked for a couple of funky eastern european property companies

changed name "andrew brent" "andrew brent-smith"

yer

a brutal dimiscule murderer

there are killers in our midst some of them are in eastern europe
working for successive property companies

they don't know who he is
the people in the photograph don't know who he is

liberalist europe
Show full article (1.09Kb)
no comments
1 2 3 4 5 6 7 8 9