VisualSVN

Proudly drinking the finest Maryland craft beer. Visiting Maryland for business? First round is on me!

My sister started crossfit with her personal trainer, one of the most effective workouts I have seen so far. She is down 40 lbs over the last 6 months and is now very fit. Then again, its like all workouts, you get out what you put into it.

Proudly drinking the finest Maryland craft beer. Visiting Maryland for business? First round is on me!

I develop software for a brewery, so I do a lot of 16 ounce curls to keep in shape!

Proudly drinking the finest Maryland craft beer. Visiting Maryland for business? First round is on me!

Your kidding right? I have seen that code a million times written by other developers.

Proudly drinking the finest Maryland craft beer. Visiting Maryland for business? First round is on me!

http://www.duclaw.com

Proudly drinking the finest Maryland craft beer. Visiting Maryland for business? First round is on me!

Most .net is the same between the two really, the following is shorter in vb Select Case number Case 0 'do something Case 1 'do something Case 2 'do something Case 3 'do something End Select I prefer the case insensitivity in vb, strSomething and strsomething should NOT be different, it is not obvious enough when your flying through the code that someone else wrote. And obvious errors are the easiest to discover. See: http://www.joelonsoftware.com/articles/Wrong.html[^]

Proudly drinking the finest Maryland craft beer. Visiting Maryland for business? First round is on me!

Agreed, I enjoy thinking on my feet and stretching my legs out. I don't have a facny whiteboard (I wish) but mine does cover my entire wall.

Proudly drinking the finest Maryland craft beer. Visiting Maryland for business? First round is on me!

+1 Whiteboard. Then digital camera pic. If I need to include it in my documentation, then I will redraw in Visio, but only for pieces that ABSOLUTELY NEED to be modeled to be understood. Flowcharts are useful in some scenarios, never for all.

Proudly drinking the finest Maryland craft beer. Visiting Maryland for business? First round is on me!

Most of the comments so far recommend not "firing" the customer, but frankly, if you can't support them you are basically telling them the same thing. If you fire them, you tell them to go away, if you tell them you can't support them, your telling them to go away (assuming they wont upgrade).

Proudly drinking the finest Maryland craft beer. Visiting Maryland for business? First round is on me!

Thank you, that works quite well. The query runs around ~2 seconds, this table should be weeded out in the next 6 months during a refactor so I'm not too worried about performance yet. Again, thanks.

First, apologies for hijacking this thread... What kind of table layout do you use for the Audit tables? Right now, we have some old legacy apps that are being rewritten and we are going to be adding auditing to them via triggers. Is there a good / standard practice format for the tables?

I have a table called CostAverage which stores the average value of an item and the date that it was calculated on. Each item has its cost average calculated on different days, and only when changes are made to the item. Since the OnDate could be anything, and the table retains the history, I am looking for a way to get the most recent cost average for each item in the table. Here is a snapshot of the table: CostAverage PK CostAverageID FK UserItemID CostAverage OnDate At first glance, I threw down something like this: SELECT UserItemID, CostAverage, MAX(OnDate) FROM CostAverage GROUP BY UserItemID, CostAverage Since the CostAverage is always different, that of course returns nearly the entire table. I can't really use an aggregate on the CostAverage since I need the most recent. Does anyone have a suggestion? I am sure that I wrote a similar query once in the past, but I can't seem to find it (or remember it)

IF your lucky 20, if your in the states typically 14, unless your local pub has the good glasses that allow a full 16 with 2 inches of head. :-D

Thanks for the excellent explanation. I understand there are certain precautions to using a foreach, sometimes it can create overhead from an enumerator. Is there an easy way to know the difference?

Waoula, Check the connection type your report uses internally when you designed it. Crystal likes to flake out when using certain connections. Try using the OLE DB (ADO) connection as a datasource when designing the report. Easiest way to change the datasource internally is by using the Set Datasource Location function, otherwise you will have to recreate some of the report. Let me know if that helps at all.

On the memory side of things, is it better to use the second example versus the first one, or does it not really matter in the end? How is memory allocated in the two situations? Will the first one create a ton of objects that get cleaned up after they drop out of scope? Will this affect memory and garbage collection?

For i As Integer = 0 To costTable.Rows.Count - 1
Dim row As DataRow = costTable.Rows(i)
'use the data in the row
Next

Dim row As DataRow = Nothing
For i As Integer = 0 To costTable.Rows.Count - 1
row = costTable.Rows(i)
'use the data in the row
Next

modified on Saturday, August 23, 2008 2:08 PM

Paul Conrad wrote:

Is it possible to make any changes to that or are you stuck with it?

There are 8 locations connecting to a central site, VPN over the net. A better way to do it would be SQL replication, but the locations can't support a server of their own, at least not right now.

I think there is a webservice call for that one...

Frankly, I wouldn't be suprised to find this in the documentation somewhere: http://en.wikipedia.org/wiki/Image:English_mass_units_graph.svg[^]

I use VisualSVN, the server is free and is subversion based. TortouiseSVN is the good for the client side and is free as well. VisualSVN provides a low cost Visual Studio plug in that runs on top of TortuoiseSVN that I think is well worth it.