How do you combine two SELECT statements from two different tables into one result (assuming bioth tables have the exact same fields)? Like, assuming that the query SELECT * FROM Table1 gives the result ID Name 001 Smith 002 Jones and the query SELECT * FROM Table2 gives the result ...more >>

Hi, all! The Criminal DB is going strong (as of today: 50 Tables, on 3077 Filegroups) Right now I stuffed in it about 2 million records (About 7% of total), but I'm constantly having an issue with dates. What is the CORRECT format to use when importing a DateTime Field??? Thank you!!! ...more >>

I have a Stored Procedure that performs a simple SELECT. The Select have no locking hints or other hints and the database is set up in a standard configuration. The problem is that the SELECT runs for some time and while it is running I can see (in the profiler) that other SPs with simple SELE...more >>

A newbie sql writer, so I hope the question makes sense..... I need to take a users current title and begin stepping through all their title records that they have had since they have been with the organization, until I find a break in the dates of service with their current title. So a use...more >>

Learn Oracle Database Administration in 10 Minutes. No kidding. Check it yourself, http://www.takveen.com Only good analogy makes complex concepts simple! ...more >>

Hello I'm a newbie to programming and need help writing an if statement. I have a database set up in SQL with the following fields: Category Questions Answers I only want one category to appear for all of the questions and answers submitted for that category. The way I have i...more >>

Hi to all... I've a little trouble with a t-sql db... I've 2 tables int he db. On the child table i've a trigger that do some controls and some calcs that are saved on a 3 table. When i've created the db, i've added the reference from the child to the parent, with the option ON DELETE CASCADE...more >>

Under SQL 2000 I have a table that consists of a single column of text type, each record holds about 15-25,000 chars. This data happens to be an xml, and I want to write this records to a text file. In order to accomplish this i'm using ISQL.exe, but i'm finding that some of the text type reco...more >>

I've scoured Google searching for an answer that seems like it should be easy but apparently isn't...when I open SSMS to connect to a SQL 2005 database and choose Windows authentication, it greys out the User Name box...problem is, the server I need to connect to is in another domain...how o...more >>

Hi all, I'm having some trouble with connecting to SQL server instance lately without adding a port number. I used to be able to always connect to instance without having to input SQLSERVER,portnumber. However now this is not the case. I doing this through an ADO connection object, and cre...more >>

Dear Experts, What is the best way to do a large insert WITHOUT having direct access to the machine SQL Server is running on? For example, imagine I want to insert something like 20,000 records. If I were to have access to the server, I could BULK INSERT into a temp table and then insert into ...more >>

I've got the following SELECT statement in a stored procedure: SELECT FirstName, LastName, BusinessName, MailingAddress1 FROM tblAddresses WHERE FirstName LIKE '%' + ISNULL(@FirstName, '') + '%' AND LastName LIKE '%' + ISNULL(@LastName, '') + '%' If I input "tom" for @FirstName then it ret...more >>

Hi, I am new to SQL 2005. My text import with DTS in SQL 7 ( my previous version) works fine. I check the column URL, the data seems to be ok. I set it to varchar and length 255 ( I tried higher as well). Any idea? - Executing (Error) Messages * Error 0xc02020a1: Data Flow Task: Data co...more >>

I cannot seem to connect to this Instance locally which was i able to in the past. I can connect to the instance from out side. The instance is running and the DBs in the instance are available and used successfully by the applications but i cannot connect to the instance using the enterprise ma...more >>

Hi, I have 2 fields in a database: 'email' and 'website'. In the majority of cases, the website field is not populated even though the email address is. In 90% of cases, the website will be 'www.' followed by whatever is after the '@' symbol in the email address. Would anyone be able to...more >>

Hi, I am creating creating a table with a Date column dd-mm-yyyy. But I cant seem to find a SQL function that just returns today's date. getDate() returns the time as well so I cant use it. The reason is simply that I want to update/overwrite over and over again all records from current day...more >>

Hi Friends, What is the equivalent function of pwdcompare() in Sql2005? Thanks, ArunDhaJ ...more >>

Hi! I have a table looking like (username) (account number) (start date) (end date) (product) wich I can have up to 4 lines for the same client. I wist to transfert those lines into a new table looking like (username) (account number) (start date 1) (end date 1) (product 1) (start da...more >>

Don Burleson said in SQL Server2005, several new features are introduced include function based index.( Specialised index on a computed column (ala Function based Index)) But when I refered MSDN, I could't find this new function. CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_nam...more >>

Hello, Can I import an OLTP (Reltional DB) as a Data Source into SQL Server Analysis Services 2005 and then use the Cube Wizard and the new Data Source View feature to create the OLAP model ? Or do I have to first design an OLAP Data Warehouse with a Star Schema and then import this DW as a...more >>

Hi! I am trying to dynamically modify my pass-through query containing a procedure call with 2 parameters. When I run my access app, I get this error: "Object or provider is not capable of performing reuqested operation." Below is my access code: Dim varItem As Variant Dim st...more >>

I have an odd one for everyone and hopefully someone can help me. I have a process that selects from table 1 using a left join to Table 2. Table 2 contains the records that have already been selected and the query is design to only select new records out of table one. THe process then adds the...more >>

Hi, I created a user account on my active directory service. I then tried to assign a service located on my SQL server to be executed by this account. However, when I try to configure my SQL server service, I get the following error message: WMI Provider Error "No mapping between account...more >>

Hi Friends, Help me in retrieving a table with a SNo column Select Name From SysObjects Where type = 'U' Order By Name asc the above query would fetch the Table names. as Name Table1 Table2 Table3 Table4 i need a view which should also include the serial number SNo Name 1 ...more >>