Jimbofoxman (4/26/2013)
Created a new view and pasted this in, everything seems fine, the table view and links show up, columns and aliases fill in. When I save I get these errorsss;Invalid Column Name 'ArbCosts'
Invalid Column Name 'VehCosts'
I tried changing the name to see if it was something weird with that name, but it still gave me the same errors.
Sorry, just to new to SQL to know what's going on.
It's looking for these:
Round((([ArbCosts]+[VehCost]+
Which you set down below, which doesn't work because you can't use a column name defined at the same level.
Copy and paste those functions that define those fields everywhere you use their names and it'll clean itself up. It'll be MESSY, but it will work. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA