SQL Alternatives? Please =)

Nov 6, 2006

Heya,

I was working on an sql problem and solved it:

SELECT planten.PLANTNAAM, planten.SOORT
FROM PLANTEN AS planten
WHERE (((planten.ART_CODE) Not In
(SELECT offertes.ART_CO FROM OFFERTES offertes, BESTELRG bestelrg, BESTEL bestel
WHERE offertes.ART_CO_LEV = bestelrg.ART_CO_LEV
AND bestel.Bestelnr=bestelrg.bestelnr
AND bestel.Lev_code=offertes.lev_code)));

However, I need find an alternative to NOT IN if one exists and isn't too long? if anybody can offer an alternative it would be appreciated :)

View Replies


ADVERTISEMENT

Alternatives To Now()

Jan 18, 2006

I have a query based around a persons sick start and return date. A report is based upon this and then this makes up a sub part of management information report that is linked through a formatted month. Part of my report is based around the following formula, this governs which MI report to include it in

repMonth: (IIf(IsNull([returndate]),Format(Now(),"mm/yy"),Format([returndate],"mm/yy")))

This states that if a person has not returned to work then give them a formatted version of now() so it can be linked to the main report. My problem is if i wanted to look at a previous months report and a person has still not returned to work they will have the now() date and thus not be included in a previous months report! Does this make sense, have i gone a really out of the way route to solve my problem and can anyone see a more effective way of carrying out this problem?
thanks in advance, sorry for confussion!

View 1 Replies View Related

Alternatives To GUID?

Jul 28, 2007

My company has satelite offices, which will be using database as well. For security and performance reasons, it is not feasible to have them connect to central server for a central back-end. (This may be different if we used a SQL backend, but migration takes time so that will need to wait).

My idea was I'd provide each satelite office their own local backend and have backend transmit the data to a central backend on a server which is fully replicated periodically while not in business. This would give the best balance between performance, security and network traffic.

But that creates the problem of possible conflicts between records' keys. I'm looking at GUID, and based on the amounts of records we usually do, I'm thinking GUID is a bit too excessive.

Maybe anyone can make suggestions if there's another way to prevent key conflict when the local backend and central backend synchronizes?

View 4 Replies View Related

How To Use IIF When More Than Two Alternatives Exist

Aug 24, 2006

Hi,
My database has 3 fields ID,Cust_Balance,Cust_Type.
I need to assign Cust_Type as 1,2,or 3 based on Cust_Balance amount.
If Cust_balance is lessthan 3 million then Cust_Type is 1,if between 3 and
10 million then type 2 and,more than 10 million as type 3.How do i accomplish this in Access ?Is IIf the right choice?:confused:

View 1 Replies View Related

Social Security Alternatives?

Jun 11, 2007

Hi,

I need a natural unique id for current and new enrollees, and I do not want to store social security numbers. If a new person enrolls, I need a way to know if they're already in our system.

I was wondering if a lookup table would work, where you switch a random autonumber for a social. If this will work, is it more secure than simply storing the socials?

Thank you!

View 2 Replies View Related

Queries :: Sum All Alternatives From Column That Equal Specified Value

Jun 27, 2014

I have a database with with 100s of values for a field. What I would like to be do is specify a value via a form and the query will return all options that equal the specified value.

so for example: Specified value = 150

Field 1 Field 2
------- -------

Name1 10
Name2 50
Name3 25
Name4 25
Name5 100
Name6 40
Name7 125
Name8 50

I'd like the query to return all possibilities that equal 150 so it should look like:

result 1 - name5 + name2
result 2 - Name5 + Name 8

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved