Hi There, I have a table with a branch code, pay date, hours & description. within the description field the options are either Actual or budget. id like to create a query to add to my reporting services dataset that works out the differnce between the budget & actual for each pay period/bran...more >>

Hi All, Could anybody tell me why is better have an ERP with SQL Server than other with Visual Fox Pro databases?. My boss are evaluating two software one in Visual Fox and other in with Visual Basic or ASP but both with SQL Server database. I understand why is better SQL Server if I have 50 ...more >>

We are moving to a new ERP system next year based upon a SQL database. Max 100 users, generally between 50-60 users. I've tried to find out what the recommendations are for running SQL on a different server to the actual ERP system, but there don't seem to be any. Would anybody have any commen...more >>

Hi all, NooB questions: What's the difference between a login user and a database user? Thanks! ...more >>

In SQL Server 2000, I have a field that is datetime. It stores it in this format: 7/27/2005 8:32:44 PM When I retrieve data from this field, I'd like to display it in the same format, but in 24 hour time: 7/27/2005 16:32:44 I was trying to manipulate it with ASP, but am getting errors. I...more >>

Hi, I am currently trying to develope a reporting system through Enterprise Manager. The origional Database was an Access Database. I tried the upsizing wizard to put the Database onto the SQL Server which didn't work. I now have to re-type all my queries in SQL through Query Analyzer. ...more >>

hi guys, i have a pb usine the convert and cast function from nvarchar to decimal when i run for erxample this script declare @TT as nvarchar(6) set @TT = '2,2' select cast(@TT as INT) i got this message Server: Msg 8114, Level 16, State 5, Line 3 Error converting data type nvarchar ...more >>

Hi, I have a database in MS Access, and I want to copy the table structures and data over to a SQLExpress database. Could someone please advise what the best way of doing this would be? Do I need to create all the tables manually, then copy the data, or can I do it all in one fell swoop? ...more >>

Hello, I am trying to upsize a table from Access to SQL Server and get this message: CREATE UNIQUE INDEX PHONE ON Contacts(PHONE) Server Error 1505: CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 5. Most significant primary key is '<NULL>'. Server Error 362...more >>

I am attempting to restore the master database in SQL Server 2000. However, I continually receive the message: "You are attempting to overwrite an existing database. Check the force restore over existing database option to overwrite the existing database." I have started SQL Server...more >>

I know the number of rows returned compared to the number of rows that exist---a percentage-- determines the selectivity of the data. Is there a commonly accepted percentage that determines, 'yes, this data is hightly selective'? Returning 90 of 100 is 90%, definitely not selective. Returni...more >>

I am having trouble with getting a networked computer to find an instance of the SQL server on my network....more >>

I am trying to import data to an SQL Database from Access. I tried importing using the Enterprise manager, importing into a project connected to the Database, and using the Access upsizing wizard. The Enterprise Manager gives me this error: Error at destination for Row number 516. Errors enc...more >>

When calling multi select statements in a stored procedure how do you set the namespace to each select statement? Thanks Chris ...more >>

In a datetime field, my app forces users to use the 7/25/2005 10:58:39 AM format. If users end up typing in 24-hour times, will it break anything? ...more >>

How can I copy data from a varchar field into an integer field, obviously copying only the values that can be an integer? For instance, I have data in a field like this: 1 2 A1034 432 B876 and I want to create a new field and copy over only those values that can be numeric, i.e., 1,...more >>

Hello, I am considering moving a company's Access App to SQL Server. I am confused about what I need to accomplish this in the way of Server Software. The pricing on the Microsoft website says, Standard Edition: $2249 with 10 Cals. The SQL Server would be running on one network server,...more >>

Does anyone know where I could find comprehensive information (on the net) on how to intepret SQL server's execution plans? For example: Hatch Match/Left semi join - Cost: 41%; Sort/Distinct Sort - Cost:100%; Merge join/Inner join - Cost: 0% Thanks in advance ...more >>

Hello, in my app I've a constraint like constraint sales_fk foreign key (salesman) references members (member) What is the use of the keyname "sales_fk"? My idea is only to remove (or edit) the constraint. May bee, there is also other use, please could any one tell me more or other...more >>

Hi there I have a table with three fields, viz. EmployeeNo, WorkDate, Company. Records for a particular employee (viz. 660) are given as follows: EmpNo WEDate Company 660 19990530 SA Cargo 660 19990606 SA Cargo 660 19990613 SA Cargo 660 ...more >>

Hi there I have two tables, T and U, that look something like this: Table T EmpNo EmpName ---------- --------------- 1 Larry 2 Lawrence 3 Laurence 4 Laurent 5 Laurel .... T...more >>

Hi, I have SQL 2000 runninh on a 2-node cluster running Server 2k3. When I start Enterprise Manager from my PC, a huge SQL.log file is created (or gets appended) and each action afterwards takes quite long time to do. This happens only from my own PC. Other admins' PCs do not have the same ...more >>

I'm creating a vb.net web form that connects to an access database. I just need clarification on a SQL statement. Basically, I do a record update like so: UPDATE TClaimTrak SET resolved = True WHERE id = 40 Now I need to not only do an update of a field, but also do update another fie...more >>

I have inherited a SQL 2000 SP3 system running on W2K SP4. We have a table load process that uses BCP to insert data and build a temporary table. I then have a stored procedure that appends two system parameters onto each row. The procedure then selects all the rows from the temporary table...more >>

I've a project to work on that needs to be done in Visual Studio 2003 .net and MySql 2000. But the machine I'm on currently has the VS 2005 beta and SQL Server 2005. I've already figured out that VS 2003 and 2005 can be installed side by side, but I can't seem to determine if SQL Server 2005 a...more >>

I upgraded my server from 2 processors to 4 processors. Is there any tuning or adjustements in SQL that need to be done in order to take advantage of the new hardware? It is SQL 2000 SP4 Enterprise Edition. Any help would be appreciated and thank you in advance. ...more >>

my sql server is too slow, like an example - if i want to open an table or like if i want to open any section of sql server or like i i want to go to stored procedure section, any where i want to go, i taking time to open it was fast before but from last few days is slow can any one please te...more >>

Hi, Lets say I have a table with these fields: Date, Category, Prod_Name The first few rows look like this: 1/04 CatA ProdA 2/04 CatA ProdB 3/04 CatA ProdC 4/05 CatB ProdD 5/04 CatB ProdE 6/05 CatC ProdF 7/05 CatC ProdG From this table, I'm looking for a result set that looks like this...more >>

Hi all, The Win2000 server in my office starting running slow and find that the SQL2000 server eat up many cpu usage.... I'm thinking it may be caused by a query in an in-house application which doing a Select Max query before insert a history record, the history table probably the biggest ...more >>

Is there an easy way to construct a query that would calculate year to date totals? My original table is as follows: Category Month Class Amount 1234 01 Rate 10 1234 02 Rate 100 5678 01 Vol 20 5678 ...more >>