24. juli 2001 - 11:00Der er
19 kommentarer og 1 løsning
Query to complex ???
når jeg vil køre nedenstående SQL given den fejl. Kan jeg forenkle udtrykket evt. via VBA..
SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"2\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"3\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"5\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"7\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"12\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"13\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"14\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"15\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"16\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"17\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"19\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"21\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"22\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"23\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"24\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"25\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"26\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"27\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"28\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"29\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"31\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"32\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"33\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"34\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"35\" union SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"37\" UNION SELECT TOP 10 * FROM [gr all down] WHERE [branch nr]=\"38\";
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
I can see what your after and I agree with alkrojn \"det ser lidt redet ud\", but it works, it gives you what you want. You could have ýour Branch nr in a table, this would simplify things if others were necessary. Then in Code you could loop through all of those in the table and insert them into a temp tabel. It would look smarter, and I think you may gain performance, because joins (UNION) are going to slow things down...
LENS> Det skal ihvertfald ikke være et OR statement, da jeg jo ønsker både 2 AND 3... AND duer bare ikke da der jo ikke både står 2 og 3 i samme felt....
TERRY> kan du forklare dig lidt nærmere...evt med flere point...
Well I can see you only have about 300 or so, so it would be unreasonable to take them all. So how about 50, if you think its too much then less, and too few, then more!
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.