One way to do this is, given your example tables:
SELECT number FROM A
WHERE number NOT IN (SELECT number FROM b)
Of course this implies that b is always a subset of a.
I have a few automated programs on a workstation which exhibited the same behavior after I applied the Outlook E-mail Security Update which wawalter refers to. Basically, I re-installed Outlook, effectively removing the update, and the programs have worked fine ever since. Since we have...
Connecting to a database can be a pain. I don't know if you just didn't show it or not, but remember, since the backslash is an escape character, you need to either precede your whole statement with an @, or add another \, so either:
(@"Data Source=PIPE2PAT-CIV8A2\GRETZKY...
^
OR...
Don't know if this is still an issue or not, but I had the exact same questin as you, but I didn't like the answers you got. After you create the parameter, you simply create the Selec Expert in Crystal (icon with cogs). Double click the field under Report Fields that you created the parameter...
This will probably be a quick answer, but since I'm a Linux newbie, I haven't found the solution yet.
My Suse 7.0 came with Apache. I installed a later version, 1.3.22, and it seemed to install OK in the /usr/local/apache directory.
The problem is that when I try to run either httpd or...
You can define how information is passed to SQL when you define the connection. For example, if you are using Access for a front end, click File, Connection then option 2 defines how your users connect to the database. SQL will automatically retrieve the NT login info, so you won't have to...
There is only 1 network, but I was hoping that I would still be able to block certain host ID's. I did try blocking my own address as a test, using the following
access-list 5 deny 10.1.1.50
access-list 5 permit any
and applying this to the oubound serial interface, but I was not prevented...
I have tried unsuccessfully to add an access-list which denies ip for a group of people. Technically our network is 10.1.0.0 255.255.0.0, although all our hosts are using 10.1.1.0 only. I thought that if I put all individuals who I want to block access on 10.1.5.0, I should be able use to use...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.