I am trying to get mysql 4, php5, and apache to work on my winxp sp2 comp, unfortunately even though php5 and apache seems to work ok I am unable to utilise mysql with php and apache, I have yet to see a guide that has a problem free installation, if there is such a guide or a fix on how to get ...more >>

Hello, I'm wondering if there is a way to concatenate two fields or a field and a string value in a single field in a view? Where in Access I might write; [field1] & " (m3)" as TotalVolume is there a way to do this in an SQL Server View? Thanks! ...more >>

Hello I've a really big doubt :) I've this two alternatives SELECT * FROM T1 a INNER JOIN T1 b ON a.F1 = b.F1 AND a.F2 = 1 SELECT * FROM T1 a INNER JOIN T1 b ON a.F1 = b.F1 WHERE a.F2 = 1 I don't know when I've use a.F2 = 1 1) In the INNER JOIN statement OR 2) In...more >>

Whats wrong with this query??? select shift, record_date, sum(timelost) from (select shift, substring(rcd_timestamp,1,8) record_date, timelost from my_table) group by shift,record_date ------------------------------------------------------------------------------------- shift t...more >>

I have a dts which creates a table which is utilized on my local intranet. The DTS runs without error and the table is created/populated/transfered to the appropriate db. Then it appears that there is an action on this table which truncates it. I have been unable to determine the culprit. Ca...more >>

Hi all Firstly this my first time posting to technical groups - so any mistakes I apologise for in advance. I am trying to count records in several secondary tables for the same run in a primary table. However, there might be no records in these secondary tables for the specific run. Hence ...more >>

Hi, I wanted to know how actually a database converter works. I am working on a converter from DBF to MS SQL server 2000 using Visual Basic 6.0. I wanted to know that once a legacy database is enterd in the program, how does it get normalised. I have aboout 40 tables in DBASE IV format. I want ...more >>

Hi, I have two tables: Code and Color. The create command for them is : create table Color( Partnum varchar(10), Eng_Color char(10), Span_Color char(20), Frch_Color char(20), CONSTRAINT pkPartnum PRIMARY KEY(Partnum) ) create table Code...more >>

Hello all. Is there a simpler way to write something like this: select column_a from table where column_b = ( select max( column_b ) from table ) ie. find the row where column_b is at it's maximum and return another column's value? something like (hypothetically) select column_a...more >>

I have not used this sp. We have a dynamic SQL statement generated by a sp. For performance reasons I would like to use it to reduce the number of explain plans created. I would like to understand its usage and pitfalls (if any) to its use. Any comments from the user community? ...more >>

I have three stored procedures that need to run nightly in SQL 7. The three procedures are not related; but to keep the procedures from running at the same time, I placed them as three steps of a single job. The first two steps are set to "Goto next step" on success; the last step is set to "Q...more >>

Hi, I have a table which contains a bunch of prepaid PINs. What is the best way to fetch a unique pin from the table in a high-traffic environment with lots of concurrent requests? For example, my PINs table might look like this and contain thousands of records: ID PIN ...more >>

Hi - Trying to chase down a baffling performance issue. Our database has been running very slow lately. So we are performance tuning the database. In doing so, we created a copy of our production database. In that database, I changed one clustered index on a table to try to improve performance...more >>

Hello, Does anyone know if SQL Server supports invoking Java methods from a Stored Procedure or even a Trigger. For example, it looks like oracle provides this capability based on the article at http://www.cs.umbc.edu/help/oracle8/java.815/a64686/04_call2.htm. It looks like for a Trigger it...more >>

I'm having a problem in getting a dynamic query in a sp working and the code is below so can someone please help me? It would be very much appreciated. Thanks Girogio -------------------------------------- set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[Search...more >>

Hi, When I use dbcc shrinkfile to shrink LOG file, following error occurs: DBCC SHRINKFILE(2) ---------------------------------------------------------------------------- ----------- Cannot shrink log file 2 (myDB_log) because all logical log files are in use. (1 row(s) affected) I have ...more >>

Recently I made a SQL introdutory course, and I like training SQL commands in my home. Is there any program that I could install in my home PC to issue SQL commands to practice ? I installed Toad, a database manipulating tool, but it's send "inexistent database" message, of course... Thanks....more >>

Hi Our product uses MS-SQL Server 2000. One of our customer has 10 installations with each installation stroring data in its own database. Now the customer wants to consolidate these databases into one and we already have plan for that by consolidating one DB at a time. But first they want to...more >>

Hi there, I have a data manipulation process written in a Nested Stored procedure that have four levels deeper. When I run these individual procedures individually they all seems to be fine. Where as when I run them all together as Nested proces (calling one in another as sub-procedures) Log ...more >>

Hello all, We are developing an add-on for GoldMine, however my problem is a generic SQL Server problem. The situation is this; we have a database, with collation set to SQL Latin. When we connect to database via Goldmine, Enterprise Manager or Delphi (through ADO) we cannot see Turkish charact...more >>

Hello: I didn't find any documentation that notes save point names are case sensitive, but I guess they are... Stored Proc to reproduce: /* START CODE SNIPPET */ If Exists (Select * From sysobjects Where Type = 'P' and Name = 'TestSaveTran') Drop Procedure dbo.TestSaveTran Go Cr...more >>

We have 2 SQL Server 2005 machines. One has the CTP version installed, the other is the RTM. When running the query below, results are returned for the CTP version but not the RTM version. select * from table t1 inner join containstable(table, column, 'formsof(inflectional, ''b=FCcher'')')...more >>

Hi All, I am facing this issue very frist time. I add a logical device as following: USE master GO EXEC sp_addumpdevice 'disk', 'AdvWorksData', 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BACKUP\AdvWorksData.bak' -- Create a logical backup device, AdvWorksLog. USE mas...more >>

Is there a way to read data from a linked server, within a transaction, without using DTC? The data on the linked server is static, therefore there is no need for two-phase commit. There is no need for locking data on the linked server, because it is not being updated (either from the remote...more >>

We have an application that is experiencing I/O contention, particularly in tempdb but also in two other databases. The data is stored on mirrored PowerVault 220's, each with 10 of 14 possible disks. The PowerVaults are JBOD devices, not true SANs. The current config has four separate groups of ...more >>

In Query Analyzer I could go to the Query menu and select Show Server Trace and it would give me trace information with duration, CPU, Reads and Writes cost. I have been using SQL Server 2005 for a couple months now and I can't seem to find that option in SQL Management Studio. Am I missing som...more >>

An Access 97 linked server in SQL Server 2K has recently stopped working. In Enterprise Manager, the following error message appears when attempting to view the list of tables in the linked server: Error 7399:OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. OLE DB error trace [OLE/...more >>

Hi all Please read my previous post here if this interests you: http://groups.google.co.uk/group/comp.databases.ms-sqlserver/browse_frm/thread/d5b12d2dadd16465?page=end&q=100%25+cpu+usage&hl=en& I have (or rather a colleague has) found the situation that appears to be causing this problem ...more >>

I have an application to capture and process timesheet information. Put simply, employees clock in and out at various locations. Business logic determines how to process these events. The system allows an administrator (though it's not strictly relevant, this is through an ASP.NET front end) ...more >>

Hello, I have a table that contains approx 2 million records. I want to query 2,000 random records. Example: 500,000 names divided by 20,000 samples = 25. The N is 25, meaning samples would be sent to every 25th name on the list. this is what I am using to create a random selection or...more >>

i have two tables, tab1 having N1 col and tab2 N2 col. now N1 is subset of N2. I need the information from tab2 (having N2) of all rows having the matching entry in N1 in tab1. For this i am using Inner Join on cols N1 and n2. But result is giving duplicate rows. Can anyone suggest how do u i r...more >>

Hi, I have a problem. When my computer loses connection to server during transaction it is rolled back automaticly by server after 2-5 minutes. During the time a can reset my computer, run my program again and I can see data from not commited transaction becouse I have to set isolation level t...more >>

we are creating a database of sales agents. Basically I have a table of about 35,000 people, a second one with 8000 offices, and a third table of around 400,000 transactions done by those 35,000 people in those 8000 offices. We get new data everyday that just updates the existing tables with t...more >>

My SQL Server has kicked out a deadlocked process, which should only be running a select statement, though there is another select on one of the tables in the WHERE clause (see code below). Can anyone tell me whether this is possible, or is it that my system, which is re-using connections, is t...more >>

Hi, Below is the query that causing problems SELECT T.Id AS TaskId FROM dbo.Task T (NOLOCK) INNER JOIN dbo.WorkOrder WO (NOLOCK) ON T.WorkOrderId = WO.Id INNER JOIN dbo.StateMaster (NOLOCK) ON StateMaster.Id = WO.StatusId WHERE WO.AssignedTo = 1020 AND StateMaster.IsInDashb...more >>