Recent content by BillLumbergh

I'm joining 2 tables, A and B, as described below Table A title_id effective_fiscal_yr end_fiscal_yr Table B title_id fiscal_yr So Table A contains a year range, whereas table B contains specific years. So I want to set up joiner conditions as: a.title_id = b.title_id and...

Don't completely understand the second part of your where, but is this close? select * from documents where status = 'Under Construction' and version = (select max(version) from documents where status = 'Under Construction') and version > isnull((select max(version) from documents where status...

neilharris: I am doing it for the reasons specified by chiph. chiph: That's what I was thinking, it cannot be done. Thanks.

We've got a VB6 application that hits a MS SQL Server 2000 DB. We use command object to append query parameters. What I cannot figure out is how to use the command object paremeter append method when dealing with a SQL in() function. How do you use parameter.append when referring to a SQL...

Open a Query Analyzer session and execute: sp_help 'object_name' Think this will give you a list of info on the object, including all existing constraints.

I work on an application that uses MS SQL Server 2K. We have a need to periodically reference a linked server to gather some Oracle data inside SQL Server queries. My linked server knowledge is sketchy at best, and our DBA who manages these connections is not readily available to us...

Is there a Javascript function that simply checks to see if what I am referring to is an object on a web form? For example, the Javascript would be doing some client side validation of a web form that may or may not contain a checkbox. If the checkbox exists, I want to run some validation on...

I understand that they both cannot be used as credit toward MCAD/MCSD etc, I am just saying that if you are able to pass one, you could probably pass the other. May help in a resume situation where you passed C# but are submitting a resume to a company that develops in VB, something along those...

I used the Kalani text, a .Net environment on my home machine, and Transcenders to prepare. One thing I would add is that I think if you can pass 70-315, you can probably pass 70-305. It's just the VB version of the test, and if you have any knowledge of VB and you are able to pass the C#...

I used "MCAD/MCSD Training Guide (70-315): Developing and Implementing Web Applications with Visual C# and Visual Studio.NET" by Amit Kalani published by QUE for 70-315, which is just the C# version whereas 305 I think is VB version. Some of my coworkers used the "MCAD/MCSD Training Guide...

Why should you avoid using eval()? Just curious, I use it sometimes.

Is there some accepted benchmark that says if you are running a web server on a machine with x processors of y speed with z memory, it should be able to comfortably handle n users? We have a period of time each year where, due to deadlines and procrastinators, our site gets totally bombarded...

Hey man don't agonize over it. The tests are hard, and, in my opinion, I think alot of these tests, a person could fail and still really know the material pretty well, well enough to be a pretty good developer in the given technology. As for everyone in here seeming to do a good job of passing...

BoulderBum: I thought they didn't give scores anymore, just pass/fail. Is that not the case?

I'm thinking that the tooltips are not available on Office 2000. My work machine has Office XP but I've only got 2000 at home. I'm pretty sure I looked under Tools -> Options and didn't have that choice. Can anyone confirm? Thanks.