Hi, I'm having some trouble with a join on two tables. Table 1 (all items) codigo | descricao Table 2 (subset of table 1 and some columns added) codigo | tipo | tb_nome Since table 2 has a subset of table 1 on 'codigo', I made my query as follows: Select tabelas.codigo, tab...more >>

I've just purchased and installed SQL Server 2005 Developer Edition as I was lead to believe that it would allow me to import and export data from Access, etc. whereas the Express edition would not. Unfortunately, I can see no way to do this, I've looked through the menu items in SQL Server...more >>

How convert a decimal column so 5.3700000000000001 will display as 5.37 at the same time .3900000001 displays as 0.39? I need to just drop the extra decimals after 2 decimal points and if possible use a preceding 0 if the number is less than 1? Thanks for your help. ...more >>

I have a VERY simple stored procedure that I've used the Stored Procedure wizard in sql2000 to create. This is it: **************************** CREATE PROCEDURE [delete_PC] (@PC_1 [varchar]) AS DELETE [mtsys].[dbo].[PC] WHERE ( [PC] = @PC_1) GO ***************************** ...more >>

In access I am able to use a query with .SELECT......HAVING whatever.whatever="" when a field is empty but not null. How do I use the same condition in enterprise manager? When I try to set "" as condition I get no data, in access I get data. ...more >>

Hi there The following query runs a heck of a long time, with CPU utilization rising to 100% for an extended period. I must be doing something wrong (or could be doing something better). Please help! Best regards Loane use database select a.refno, min(a.date), (select top ...more >>

Dear experts, I'm an Oracle guy, looking to pick up SQL Server. I've installed SQL Server 2000 on XP (home). I'm now trying to navigate SQL Server. In Oracle, I would just open SQLPLUS, and query away. SqlPlus looks like a DOS window, or telnet window into Unix. It just has the dot pro...more >>

Is there any problem installng the developer's edition (or what ever it is called now) of MS SQL Sever 2005 on the same client computer that's runnning SQL 2000? TIA....more >>

I tried to setup a NET SEND on SQL errors to my work PC Name (SYSADMIN), inside of Enterprise Manager (I'm running SQL 2000 SP-3a) and when I click TEST, it fails. If i put the name of a server that is on my network, in there, it works fine. What is wrong? I have a Windows 2003 Server Active ...more >>

Hi, After what could have been a very nasty experience with my Access database, I'm looking at possible ways of making things a little more reliable... My current configuration is a dotNET application that is installed on each client along with an Access database that contains queries and ...more >>

Can someone tell me where I can find more information on indexes and how they are utilized. I understand that indexes are B-trees (I think B+ trees), but how are they utilized. I hope someone can help me understand this better. Here is what I think I know: 1. Nonclustered indexes are st...more >>

Hi there, I restored a SQL 2000 database into a SQL 2005 server, i need to change ownership of the tables in the database for my application to work correctly. Under 2000 I could select the database, then tables and in the preview pane displayed the owner. Part 1: How do I find out wh...more >>

I'm having trouble trying to put together an update query. I have a single table that looks like this (relevant data only): PK INT PRIMARY KEY IDENTITY, nameresolved VARCHAR(30), dtresolved SMALLDATETIME, nameapproved VARCHAR(30), dtapproved SMALLDATETIME I'd like to set the nameapprove...more >>

Hello Group, new user to SQL Server. My network guy is after me to "defrag" the SQL Server databases. He says that some of my databases are bad. What does defrag have to do with databases? Rich...more >>

Hi, This que. was asked me in an interview. The situation is : I have to update a Salary of employees. comm = comm + sal * 10% for comm < 1000 and comm = comm - sal * 10% for comm > 1000 for all employees whose salary > 10,000 in emp table. How can I do this using single update statm...more >>

I was reading: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_8sit.asp The first bullet point half way down says "The index is implemented as a B-tree index structure...The pages .. are are inked in a doubly linked list"... I thought that would make it...more >>

Hello! I'm programming in VC++ 2005 MFC and I have never use SQL server as the database before. Earlier I have used ADO and Access database. I have a database which consist of 4 tables, see below I know all values at the same time. I wonder how do I update the database in the best way? ...more >>

Hello Group, I am new to SQL Server. What causes a date field to have the date 1/1/1900 in it? I have been given a database to extract some data from and I can see several of the records have 1/1/1900 in them. Other records have <NULL> in them; the obviously have not been touched. Wh...more >>

Just installed a dev SQL 2005 server, imported some old SQL 2000 databases. I am now trying to query a table and would like to know what the equivalent to 'Return all rows' is? Many thanks ...more >>