Sytze
You need two select statements with a union like this
Select . Union (Select .)
The first select will refer to pemp and the second select refers to pempex
Paul
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
On Thu, May 3, 2012, at 08:34 PM, Ken Dibble wrote:
We're gonna get to the end of Moore's law and find that instead of using
computing power to solve really complex and important problems, we've
wasted it all on making transparent windows and wavy ribbons and pretty
pictures dance
Sytze,
Don't forget to make the Union a union all statement if you wish to get all
records from the two selects, even though there may be duplicates.
By itself union ignores duplicate records.
Dave
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Hello Christof and Dave,
Thanks for the info, that helps a lot.
I think I have a solution working now.
Thanks,
Kent
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Christof Wollenhaupt
Sent: Thursday, May 03, 2012 11:44 AM
To:
El 02/05/12 12:50, Kurt Wendt escribió:
Or - maybe we can start connecting directly up to Brains! Maybe we can
start experimenting w/Pete's - since he is so worried about The End
being Near!!!
Ptt
Sorry, it fried.
___
Post Messages
Or you might use
select pcode as Code, NVL(pemp.name, pempex.name) as 'name';
, NVL(pemp.gross, pempex.gross) as 'gross' etc... ;
from palldets ;
left join pemp ;
on palldets.pcode=pemp.code ;
left join pempex ;
on palldets.pcode=pempex.code ;
where cycle=mycycle ;
order
El 01/05/12 23:17, Michael Madigan escribió:
That's because you killed them all
Geoff, if you killed so many aboriginals. Couldn't you have also killed
Mickey and closet Petey?
From: geoff data...@adam.com.au
To: 'ProFox Email List' profox@leafe.com
El 02/05/12 21:06, Michael Madigan escribió:
Now all of our Indians are wealthy casino owners.
True, the whole 4 of them.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of
El 03/05/12 13:18, Michael Madigan escribió:
For some reason America puts a high value on what deadbeats and losers think.
If that were true then you'd be in Congress.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
Hi, all. Last week, I installed SQL Server 2012 Express on a 64-bit Windows
7 machine, and tried to import some VFP data into it. I selected the
Import Data (32-bit) utility and picked the Fox OLE DB provider, only to
have the app promptly hang and go bye-bye, without even letting me select a
Is there a SQL equivalent function for replacing characters like we have
in the STRTRAN/CHRTRAN functions?
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16
Hi Mike,
It's Replace()
SELECT REPLACE('The quick brown fox', ' ', '_')
= The_quick_brown_fox
Paul
On 4 May 2012 15:53, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Is there a SQL equivalent function for replacing characters like we have
in the
Replace()
Dave
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of
MB Software Solutions, LLC
Sent: 04 May 2012 15:53
To: ProFox Email List
Subject: [NF] SQL equivalent for STRTRAN/CHRTRAN ?
Is there a SQL equivalent function for replacing
and use Charindex() to search for an expression in another expression like
AT()
Dave
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of
MB Software Solutions, LLC
Sent: 04 May 2012 15:53
To: ProFox Email List
Subject: [NF] SQL
Possible. My framework used subclassing some 3 - 4 levels deep.
However, I build all regularly, so if this was the cause, the
compiler wasn't picking it up.
On Wed, May 2, 2012 at 3:28 PM, Tracy Pearson tr...@powerchurch.com wrote:
Lew Schwartz wrote on 2012-05-02:
Yep. I've never been able to
...and I forgot also Patindex() to search for a string in another string
remember positions relative to 0 not 1!
Dave
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of
Dave Crozier
Sent: 04 May 2012 16:32
To: ProFox Email List
Garrett,
Role your own, that way you can do the field conversions you really want
yourself. I gor bitten by the default conversions in 2008 R2 and as far as I am
aware they haven't changed in 2012.
Dave
-Original Message-
From: profox-boun...@leafe.com
I have similar problems in 2010R2. When I exported the VFP table to other
formats (CSV, XLS,.. etc.) I had to deal with the bizarre field conversions SQL
wanted to do... Woof!
So now I just write VFP code to do it instead of using the SQL utility.
Problem solved.
YMMV, but that's what
On 5/4/2012 11:33 AM, Dave Crozier wrote:
...and I forgot also Patindex() to search for a string in another string
remember positions relative to 0 not 1!
Dave
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of
Dave Crozier
I developed two forms for that purpose:
One reads the VFP database and creates each table, with its
indexes,default values and constraints into a SQL Server database. The
other one passes all the information from each DBF table into the
corresponding SQL Server table.
I first change things
produce quality business applications without the need to write any
programming code at allproduce quality business applications without the
need to write any programming code at all.
Read more about Lianja Features http://www.lianja.com/features by
www.lianja.com http://www.lianja.comproduce
http://www.foxnews.com/politics/2012/05/04/alleged-prostitute-in-secret-service-scandal-calls-agents-fools/
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16
Sounds like he's in a some serious deep shit.
http://www.foxnews.com/us/2012/04/30/aide-wife-john-edwards-knew-about-money/?intcmp=obnetwork
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
El 04/05/12 14:49, Michael Madigan escribió:
Ask General Custer what he thinks of that statement.
I would have loved to help Sitting Bull
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
El 04/05/12 17:16, MB Software Solutions, LLC escribió:
http://www.foxnews.com/politics/2012/05/04/alleged-prostitute-in-secret-service-scandal-calls-agents-fools/
Well the SS have their bad reputation since Germany/Poland/Russia in the
30's and 40's.
MB Software Solutions, LLC wrote:
Sounds like he's in a some serious deep shit.
http://www.foxnews.com/us/2012/04/30/aide-wife-john-edwards-knew-about-money/?intcmp=obnetwork
Hi Michael,
They are trying to intimidate him into a plea. He actually violated no
more laws than the First
They'll use the same hired killer that they used on Vince Foster and Andrew
Brietbart
- Original Message -
From: MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com
To: ProFox Email List profox@leafe.com
Cc:
Sent: Friday, May 4, 2012 4:16 PM
Subject: [OT] She'll be
These people all make me sick, Edwards, Young, Mrs Young, the campaign workers,
the news media that covered for him, and Elizabeth Edwards, they're all scum.
- Original Message -
From: MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com
To: ProFox Email List
Michael Madigan wrote:
These people all make me sick, Edwards, Young, Mrs Young, the
campaign workers, the news media that covered for him, and Elizabeth
Edwards, they're all scum.
Hi Michael,
What did Elizabeth do to be scum? Die of cancer?
--
Regards,
Pete
http://pete-theisen.com/
She knew he was having an affair but kept quiet so she could be first lady. In
addition to that, she used a Get Well Elizabeth website to harvest email and
home addresses to solicit campaign contributions. There's a place for John
reserverd right next to her in Hell.
- Original
We're gonna get to the end of Moore's law and find that instead of using
computing power to solve really complex and important problems, we've
wasted it all on making transparent windows and wavy ribbons and pretty
pictures dance around on our screens.
That stuff is only froth -
31 matches
Mail list logo