Search results for query: *

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.

I'm doing some Excel stuff on my computer at home, which I never do, and I'm trying to do some financial calculations. On my work machine, when I type a function name into a cell and get to the "(" character, it pops up a list of the parameters it expects, sort of like as Alt text in...

I ended up getting this to work by adding the user ASPNET to SQL Server users list and giving him read/write access to Northwinds database. Then in the data wizard, I used SQL Server Authentication instead of NT. Still frustrated though by the fact that I could sporadically get it to work...

I am in the process of learning C#/.Net and am going through the QUE 70-315 Training Guide by Amit Kalani. The book is not necessarily relevant to my question but I am including it in case someone has also used the book. I am doing an exercise that builds a single-table data form (Step By Step...

tls9923: Thanks for your help. Did you give me the full link? It looks like some elements are missing from the querystring, and when I click it, it says requested web page is not available. Thanks.

I'm having an intermittent problem on my computer. Windows 2000 SP4 with IE 6 SP1, all critical updates and service packs up to date. Sometimes my browser indicates 0 bit cypher strength. I have downloaded and installed 128 bit some time ago. Some boots my browser indicates 128 bit and I can...