Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 112
Search took 0.01 seconds.
Search: Posts Made By: U.N.C.L.E.
Forum: SQL Server 2008 April 7th, 2015, 01:27 PM
Replies: 1
Views: 1,159
Posted By U.N.C.L.E.
DTS Package Equivalent

I've been using SQL Server 2000 for some time now, using a DTS package to import larges amounts of data on a monthly basis...

Believe it or not, the only thing that kept me from upgrading to...
Forum: SQL Server 2008 August 20th, 2009, 08:11 PM
Replies: 0
Views: 942
Posted By U.N.C.L.E.
SSMS Query Editor

I use SSMS Query files (.sql) to manage many aspects of a SQL database. Usually, I select portions of the script and click the Execute button to run the selected SQL code.

My problem is...
Forum: SQL Server 2000 August 20th, 2008, 09:45 AM
Replies: 13
Views: 1,996
Posted By U.N.C.L.E.
Excellent! Thank you for your input/help! I...

Excellent! Thank you for your input/help!

I did make a slight addition to the GROUP BY clause of the sub query to get it to work properly in Management Studio and Query Analyzer:
...
Forum: SQL Server 2000 August 19th, 2008, 03:55 PM
Replies: 13
Views: 1,996
Posted By U.N.C.L.E.
You are correct, of course. My next step was...

You are correct, of course.

My next step was going to be to try using SHAPE to return one dimensional list of non-paired and left-side paired (even TYPE) with sub recordset for the right-side pair...
Forum: SQL Server 2000 August 19th, 2008, 02:46 PM
Replies: 13
Views: 1,996
Posted By U.N.C.L.E.
I certainly appreciate your input. But, SELECT...

I certainly appreciate your input. But, SELECT part FROM data
ORDER BY LEFT(part,5), RIGHT(part,3) results in random ordering:

e.g. AC1006120 sometimes comes before AC1000142...

I've been...
Forum: SQL Server 2000 August 19th, 2008, 12:43 PM
Replies: 13
Views: 1,996
Posted By U.N.C.L.E.
ORDER BY Help

I would like some help regarding ORDER BY clause for a SQL Server 2000 database.

First 2 chars is a MFG code, next 4 chars is a TYPE and the last 3 digits is a SERIES number. Assume MFG and TYPE...
Forum: Access VBA October 11th, 2007, 11:42 AM
Replies: 3
Views: 9,487
Posted By U.N.C.L.E.
Thanks for the info.... I was able to...

Thanks for the info....

I was able to disable the Shift key on startup using:

CurrentProject.Properties.ADD "AllowBypassKey", False

To enable Shift key:

CurrentProject.Properties.Remove...
Forum: Access VBA October 5th, 2007, 01:53 PM
Replies: 3
Views: 9,487
Posted By U.N.C.L.E.
AllowBypassKey for Access Project

I have created an Access Project file connected to SQL Server.

I want to disable the AllowBypassKey property for the project but the CreateProperty() method of the CurrentDb object does not seem...
Forum: SQL Server ASP January 4th, 2007, 09:53 PM
Replies: 2
Views: 3,587
Posted By U.N.C.L.E.
Determine next autonumber field value

Is there a way to determine the next autonumber field without actually adding a record and executing .Update using ADO?

I am using a table to store successful form data copied from a temporary...
Forum: Classic ASP Professional November 20th, 2006, 07:29 PM
Replies: 5
Views: 1,689
Posted By U.N.C.L.E.
Let's assume the code works fine... which it...

Let's assume the code works fine... which it does in an Access Project file. I'm simply trying to port the code to ASP.
Forum: Classic ASP Professional November 20th, 2006, 05:03 PM
Replies: 5
Views: 1,689
Posted By U.N.C.L.E.
ASP Error: I'm wondering if there is a...

ASP Error:



I'm wondering if there is a problem with the cursor?

Code snippet that opens recordset:

Set db = Server.CreateObject("ADODB.Connection")
Set rs =...
Forum: Classic ASP Professional November 19th, 2006, 02:26 PM
Replies: 5
Views: 1,689
Posted By U.N.C.L.E.
Reference ADO Recordset Field after CommitTrans

I seem to getting an error when referencing a field within a recordset after performing a CommitTrans. Following ASP code snippet illustrates this:


With RS
DB.BeginTrans

'Do some...
Forum: SQL Language June 6th, 2006, 03:55 PM
Replies: 3
Views: 1,012
Posted By U.N.C.L.E.
I am aware of the reason for the error... ...

I am aware of the reason for the error...

What I would like to end up with is a table with all unique MFG, MAKE, MODEL combinations.

This can be done in ACCESS by appending to a empty table and...
Forum: SQL Language June 6th, 2006, 12:24 PM
Replies: 3
Views: 1,012
Posted By U.N.C.L.E.
insert into

I would like to insert into table1 all the unique MFG,MAKE,MODEL fields from the union of 3 other tables.

table1 has MFG,MAKE,MODEL set as the primary key.

So I use INSERT INTO and UNION...
Forum: SQL Language June 5th, 2006, 02:11 PM
Replies: 8
Views: 1,204
Posted By U.N.C.L.E.
After further digging... table2 had multiple...

After further digging...

table2 had multiple entries for some of the MFG codes.

Thanks for the help.
Forum: SQL Language June 5th, 2006, 01:52 PM
Replies: 8
Views: 1,204
Posted By U.N.C.L.E.
I am using SQL Server Management Studio (2005)...

I am using SQL Server Management Studio (2005) connecting to SQL Server 2000.

The code has been editorialized to change only the table names.

table1 contains multiple entries with the MFG code...
Forum: SQL Language June 5th, 2006, 01:13 PM
Replies: 8
Views: 1,204
Posted By U.N.C.L.E.
Yes, in my situation table1 contains 6503 rows,...

Yes, in my situation table1 contains 6503 rows, the query is returning 22706 rows...

I should add, table2 can contain MFG codes that are not in table1.


Update:
I just tried the following SQL...
Forum: SQL Language June 5th, 2006, 12:48 PM
Replies: 8
Views: 1,204
Posted By U.N.C.L.E.
JOIN operation

I have 2 tables. Say table1 has 100 rows.

Table1 has a field 'MFG' which is a 2 char code.

I want to replace the 2 char code with a lookup value from table2 which may or may not include all 2...
Forum: Access April 5th, 2006, 03:45 PM
Replies: 0
Views: 1,580
Posted By U.N.C.L.E.
Append query (ADP) only appends first 10000 rows

Created an INSERT INTO stored proc in an Access Project (MS SQL) which appends rows from one table to another.

Access by default only displays the first 10000 rows of a SQL table. I set the...
Forum: Access February 8th, 2006, 05:33 AM
Replies: 2
Views: 740
Posted By U.N.C.L.E.
The SQL to join (INNER JOIN) the two related...

The SQL to join (INNER JOIN) the two related tables is:

SELECT STUDENTS.SID, STUDENTS.SNAME, STUDENTS.EMAIL, STUDENTS.PWD, STUDENTS.PID, PROGRAM.PNAME
FROM STUDENTS INNER JOIN PROGRAM ON...
Forum: Access VBA February 3rd, 2006, 06:55 PM
Replies: 0
Views: 2,533
Posted By U.N.C.L.E.
Automate import (fixed width)

I am attempting to automate the import of a text file (fixed with fields). I have created a fixed width import specification using the "Advanced" button on the import wizard form and saved it.
...
Forum: SQL Server 2000 December 9th, 2004, 08:03 PM
Replies: 1
Views: 850
Posted By U.N.C.L.E.
SQL Update question

Using Access 2003 as an interface to large SQL 2000 table containing million+ records.

I've added a new column that is a bit with a default value of 1. Unfortunately, SQL Server initializes the...
Forum: SQL Server ASP September 7th, 2004, 09:35 PM
Replies: 1
Views: 2,567
Posted By U.N.C.L.E.
Sounds like you're using an Access ADP file... ...

Sounds like you're using an Access ADP file...

If so, open your query in design view, right-click | properties | View tab. Uncheck checkbox next to TOP...

Then save query.
Forum: Classic ASP Databases August 25th, 2004, 12:39 AM
Replies: 8
Views: 2,800
Posted By U.N.C.L.E.
Looks like you are using an Access Project...

Looks like you are using an Access Project file??? If that is the case, [ProjectStatusReport]![Week] most likely references an open report called ProjectStatusReport and a control on that report...
Forum: Excel VBA July 24th, 2004, 01:32 PM
Replies: 1
Views: 1,078
Posted By U.N.C.L.E.
You're hurting performance because you are...

You're hurting performance because you are selecting each cell in turn... Try something like this:

'Application.ScreenUpdating = False
For I = 1 To 30...
Showing results 1 to 25 of 112

 


All times are GMT -4. The time now is 08:04 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.