In vague hopes of helping you out, I'll post a framework for using a cursor as I would in SQL Server. My suggestion is to research cursors in Sybase and go from there, but hopefully this will get you going in the right direction:
#dir is a temporary table, basically the syntax is DECLARE...
Are you using Microsoft SQL Server? The real fun there is that it doesn't support for loops; you need to duplicate the operation of a for loop using a cursor. Before I post an example of cursor use I'll wait to find out if you're using SQL Server, though :D
I work in Wisconsin and have recently been working on a biodiesel site that includes methanol and methoxide tanks. One set of regulations I've had to work with is from the Department of Commerce, which has a section in the Administrative Code called Chapter Comm 10: Flammable and Combustible...
Good point Mech151. We've worked very hard on writing documentation and instructions for using the in-house developed system as well as the code behind it. I try to go back frequently and add descriptive comments to the code and rewrite blocks in more efficient, easier to understand methods...
Well I love advanced math and programming but the math involved in solving this one may be over my head. I did, however, find a useful description on Wikipedia at http://en.wikipedia.org/wiki/Quartic_equation ...if you go about two thirds of the way down the page there is a section called...
This is definitely a struggle that many engineering firms go through. My company has been in business for over 80 years, obviously from a small start, to now having 12 offices in 4 states. We have a very talented web programmer that works on the public website and a very extensive intranet...
Very good point, this isn't just something that reads emails and makes random decisions though. It only saves messages from the focus groups, which are where the specilized questions are asked and answered at our company. An example would be that any email sent to the "Storm Water" internal...
I love Wikis but I don't think that they are the most practical application in an engineering firm. I'm an engineer and an experienced web programmer, and have been working on a lot of internal project management tools for my company, similar to what you're discussing here. We also have a web...
Could definitely use some more information on what you would like to use it for. I work for a large civil/environmental/architectural firm in Wisconsin and we use Eagle Point a lot, with a lot of success. State DOT requires MicroStation with Eagle Point, so our transportation department uses...
I'm pretty sure that this means Pond M020 is not discharging fast enough. It's building up water, and as that happens it goes back up the pipe and into Pond M019. When I get a message that an outlet is being submerged, I read it is the system is backing up to that level above the top of the...
Looks like I'm about a week late on this one but I thought I'd throw in my two cents. I work for a large engineering firm in Wisconsin that uses both AutoCAD and MicroStation. I have the unique position that in addition to being a licensed engineer I am also a computer programmer and have had...
