Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 75
Search took 0.01 seconds.
Search: Posts Made By: Ben
Forum: SQL Server 2000 September 28th, 2005, 06:58 AM
Replies: 1
Views: 638
Posted By Ben
Dang windows firewall

Dang windows firewall
Forum: SQL Server 2000 September 28th, 2005, 06:21 AM
Replies: 1
Views: 638
Posted By Ben
Registering SQL Server

Hello,

I'm registering different SQL Server Installations to my Enterprise Manager, it was working fine, however it's stopped auto detecting installations on the network. I've tryed osql -L which...
Forum: SQL Server 2000 February 8th, 2005, 09:22 AM
Replies: 3
Views: 2,067
Posted By Ben
Thanks for your reply. If you run Reporting...

Thanks for your reply.

If you run Reporting Services on the same server, do you have to create a named instance?
Forum: SQL Server 2000 February 7th, 2005, 01:05 PM
Replies: 3
Views: 2,067
Posted By Ben
Reporting Services

Can anyone let me know what the licensing requirements are for Reporting Services?

Do I have to purchase an additional copy of SQL Server or can it be installed on the current server - if so would...
Forum: Access VBA January 26th, 2005, 01:12 PM
Replies: 3
Views: 6,602
Posted By Ben
[?]Anyone any ideas [:0]:([:I]:)[:o)]

[?]Anyone any ideas [:0]:([:I]:)[:o)]
Forum: Access VBA January 26th, 2005, 09:50 AM
Replies: 3
Views: 6,602
Posted By Ben
Hi Mihai, Thanks for your reply. I've...

Hi Mihai,

Thanks for your reply.

I've already written the Select statement I need, however I'm unsure if it will work in an insert query as it is.

For example my query currently reads
...
Forum: Access VBA January 26th, 2005, 08:07 AM
Replies: 3
Views: 6,602
Posted By Ben
Insert ODBC Values into Table

I would like to insert the results of in an ODBC recordset into an Access Table.

Currently I cycle through each value and use "Insert Into.. Value...".

However I feel it would be much cleaner...
Forum: SQL Server 2000 January 20th, 2005, 06:41 AM
Replies: 3
Views: 1,612
Posted By Ben
If I understand your question correctly, i don't...

If I understand your question correctly, i don't believe it can be done in a SP.
However [As you probably realise] you could dynamically build the query in the application.

Example in VB:

Dim...
Forum: SQL Server 2000 January 20th, 2005, 06:34 AM
Replies: 5
Views: 557
Posted By Ben
Again thanks for your input. One other...

Again thanks for your input.

One other question regarding indexes:

If an index is built on 2 columns, when applying a condition to one of the columns do I have to reference other columns aswell...
Forum: SQL Server 2000 January 19th, 2005, 12:39 PM
Replies: 5
Views: 557
Posted By Ben
Thanks for your input Jaime The database...

Thanks for your input Jaime

The database supports a 3rd party application, I have a good understanding of the datacaptured, and I've taken a look over all the tables and have discovered the whole...
Forum: SQL Server 2000 January 19th, 2005, 10:23 AM
Replies: 5
Views: 557
Posted By Ben
Developing Queries On Existing DB

I've been asked to develop some queries on an existing database. The queries I've been asked to develop frequently reference a date column in their conditions however the date column isn't indexed. ...
Forum: SQL Server 2000 January 18th, 2005, 05:23 PM
Replies: 7
Views: 1,574
Posted By Ben
Isn't it OPENDATASOURCE thats not supported in...

Isn't it OPENDATASOURCE thats not supported in v7.0?
Forum: SQL Language January 14th, 2005, 11:16 AM
Replies: 1
Views: 1,712
Posted By Ben
The former is the new join style and compliant...

The former is the new join style and compliant with the ANSI SQL-92 standard, the latter is the old join style. There's no loss in performance in either style, the only benefit is the new join style...
Forum: SQL Language January 13th, 2005, 09:29 PM
Replies: 2
Views: 1,172
Posted By Ben
Rough Guidelines: For existing data run a...

Rough Guidelines:

For existing data run a query something like:
UPDATE Table1
SET Table1.Amount = Table1.Amount - Table2.Amount
FROM Table1 INNER JOIN Table2
ON Table1.PID = Table2.PID
AND...
Forum: SQL Language October 11th, 2004, 08:41 AM
Replies: 2
Views: 612
Posted By Ben
And?

And?
Forum: SQL Language October 1st, 2004, 05:04 AM
Replies: 2
Views: 612
Posted By Ben
Query Help...

I have a table which contains three fields one a fk, one a category (Together they make a composite pk), and finally a value thats associated to the category. Each fk can have up to 9 category's...
Forum: SQL Server 2000 September 30th, 2004, 04:07 AM
Replies: 2
Views: 754
Posted By Ben
SQL Help...

I have a table which contains three fields one a fk, one a category (Together they make a composite pk), and finally a value thats associated to the category. Each fk can have up to 9 category's...
Forum: Access April 8th, 2004, 05:10 AM
Replies: 1
Views: 838
Posted By Ben
Stuck with Select Query...

I have a table that contains like the following:

EmployeeName, Reason

I need to count the occurences of each reason for each employee and select the reason that occurs the maximum number of...
Forum: Access March 12th, 2004, 03:18 PM
Replies: 4
Views: 2,870
Posted By Ben
Enter the below in the ControlSource of a Control...

Enter the below in the ControlSource of a Control on your form:

=[Forms]![Form Name]![SubForm Name].[Form]![SubForm Control Name]

Only thing to remember is the SubForm Name is the name defined...
Forum: SQL Server 2000 March 12th, 2004, 03:09 PM
Replies: 3
Views: 2,026
Posted By Ben
Thank Imar that was really useful - I think I'm...

Thank Imar that was really useful - I think I'm going to go for the Evaluation Edition.
Forum: SQL Server 2000 March 12th, 2004, 02:31 PM
Replies: 3
Views: 2,026
Posted By Ben
SQL Server Developer Edition

Can anyone tell me the restrictions on SQL Server Developer Edition, I'm doing a certification, and I thought it would be good to get a copy for my home PC - Will I be able to test most of the...
Forum: Access VBA March 11th, 2004, 07:53 AM
Replies: 19
Views: 3,554
Posted By Ben
Sweeeeet, thanks Jürgen A lesson learned,...

Sweeeeet, thanks Jürgen

A lesson learned, the whole query ran in seconds!

I really appreciate your help on this

Thanks Ben
Forum: Access VBA March 10th, 2004, 11:35 AM
Replies: 19
Views: 3,554
Posted By Ben
Hi Jürgen, The data I'm querying is held in...

Hi Jürgen,

The data I'm querying is held in the same MDB as the code and while I have been doing the tests it has been located on my C:, so network issues are out of the picture.
The original...
Forum: Access VBA March 10th, 2004, 09:42 AM
Replies: 19
Views: 3,554
Posted By Ben
I made a couple of small changes, I changed the...

I made a couple of small changes, I changed the SQL to exclude the Top 8 command as there will never me more than 8 records returned, and I changed the getstring function to place a comma instead of...
Forum: Access VBA March 10th, 2004, 08:10 AM
Replies: 19
Views: 3,554
Posted By Ben
Hi Jürgen Thanks very much for your reply,...

Hi Jürgen

Thanks very much for your reply, the method you proposed took 19.778 seconds to process 8 records, again like the other two methods, it processed the first record twice [?]

Also the...
Showing results 1 to 25 of 75

 




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