Search results for query: *

I have a little authentication window come up as soon as you start the program but then when a user enters their username and password (correctly; it is checked against database) I need it to set a few variables (variables must be public and kept until application closes) and pass them to the...

I need to assign a data value from a dataset/dataadapter to a variable, or can I check if dataset returned any values?

I have 2 tables in the SQL 2000 database, Customers and CustomerAddress. The reason is because one customer can have multiple physical locations. I am building an ASP app that automates sales order process. Anyway... I have a single form that has to create a new customer record but Company...

I need to generate a unique number besides the autoincrement ID field that will be a unique alphanumeric order number, maybe even in sequence to look better say... ABCD0001 format

need some help to figure out how to display existing data for a particular record in Form fields and if changed in the field I need to click update button which will update the changed fields in the database, or maybe all because the ones that weren't changed gonna stay the sane anyway. what's...

I setup a 2003 server and have a workstation right beside it. Web server and workstation both on 192.168.2.0 network that's connected to a router and then to internet. The server is only letting through port 80. For security reasons. I don't wanna access it from my workstation through this IP...

I am doing an update procedure where I am running the first update and then the second update statement only needs to update the records modified by the previous one. So I wanna specify in the where clause that it needs to update only the records where the LastUpdate Time and Date is within the...

I am using the code below to update about 5000 customer records to a new customer number format. Example: ABC001, ABC002, ABD001, ABD002 and so on... first 3 are chars of 3 first chars of the customer name and last 3 is incrementing number. The works great if I were to update all customer...

I am building a web site where I want to create a couple forms that will communicate with an access database. Basically it will submit the values and write them into a table. Also I wanna be able to search the database through the webb and display results. Any suggestions? PS. website is...

I need to create a criteria using LIKE or CASE or whatever that will identify only records with format ABC123. Where ABC is any 3 chars and 123 is any 3 numbers. I tried lots of different ways with LIKE however can't come up with right one. Most time I don't have any results at all.

I have a recordset of about 5500 customers, they have their own unique customer numbers (it is not the autoincrement primary key field) which don't follow any convention at the moment. Management came up with new convention for the number. Six characters, first 3 are first 3 customer name chars...

I have a table from Sales team of their prospects of about 2000 records since 2003. fact is about 100 of those became customers. I need to compare the prospect table to the customer table in the database and as accurately as possible identify who became a customer. Now the problem is, that the...

I have lots of machines to be upgraded with new HDDs. Timing is critical. Production/hospital environment. Original hard drives contain about 40 partitions each (dunno why). I need a program besides ghost or driveimage, that will clone those HDDs very fast and efficient. Recommendations? I...

My manager left for a week. And we have a older AS400 system with the old database but some users sometimes use it. Anyway , they came to me and said that some of them cannot print from that old AS400 database. I believe there is a Windows NT machine acting as a print server for the AS400...

I will be doing a domain rename procedure in a production environment tonight, however I could only simulate a regular domain rename scenario prior to that and it worked fine. However my DC is running SQL and it is also clustered. I am not sure what to expect from the cluster in this situation...

I want to do this cert. But I am not sure where to find schools with corporate training in Toronto, Canada. Anyone used Learnkey CDs for passing exams? Where to find exam specific books for this cert?

I am just starting to write stored procedures and I wrote one that is fairly complex (I think). I query the sysobjects and syscolums tables and then I input results into a temp table and then I have to update some fields in all selected tables based on certain criteria. Anyway my question is...

Say if I do a "select top 1 id, name from table" just to get one record, how can I asign the values retrieved from that query to variables @id and @name in a SQL 2000 stored procedure?

What documents would one put together to present to management before making a network topology/structure change? I put together diagrams of before and after topology and detailed blow up versions of segments. I'm basicaly moving around VLANs and adding some, and also switch hierarchy changes...