Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pace
Constraint Violating Yak Guru
264 Posts |
 Posted - 2007-05-31 : 05:31:43
|
Hello experts, Im struggling with the following query, is there any chance you can help me get it formatted right so that I can run it? I think it is just the bottom four lines that are of interest.Thanks for your time, PaceScreen; "Impossible is Nothing"  |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-05-31 : 05:35:41
|
| You might have more luck posting this in the MS Access forum.Mark |
 |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2007-05-31 : 05:38:14
|
| Yes I know what you mean, however this is just an app using linked sql server 2000 tables"Impossible is Nothing" |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-05-31 : 06:01:45
|
| Yeah, but it's clearly an Access query as it's using ampersands for concatenation, the Iif function for conditional logic, referring to Access objects, such as forms, etc! I suspect that a lot of people on the forum will lack the patience to wade through this, which is why I suggested that you might have more luck in the Access forum. To my mind, it looks like a good candidate to rewrite as a stored proc, if possible, thereby shifting the processing onto the server. |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2007-05-31 : 11:07:10
|
indeed... though I believe in putting the client back into client server. And I do apologise, I wasnt trying to insult your intelligence, I just dont see much traffic in the access forum... plus, I hate access with a passion, I just cant work out the order of precedence for my parenthesese here  "Impossible is Nothing" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-31 : 11:37:13
|
| Take out the parenthesise in the FROM statement (there are two of them) and see if that helps.Kristen |
|
|
|
|
|
|
|
|
help with long query - inc screen shot