ANOTHER ONE:

SELECT a.*

FROM OPENROWSET('SQLNCLI', 'Server=COM17\SQL2005; Trusted_Connection=yes;',

'SELECT *

FROM WorkOrderHeader

') AS a;

ERROR:

Login failed for...

A table can be joined to itself in a self-join. For example, you can use a self-join to find the products that are supplied by more than one vendor.

Because this...

You could also check this:

http://www.sql-server-helper.com/tips/read-import-excel-file-p02.aspx

Check the last parameter.

EXEC sp_addlinkedserver

@server = 'ExcelSource',

@provider = 'Microsoft.Jet.OLEDB.4.0',

@srvproduct = 'OLE DB Provider for Jet',

@datasrc = N'C:\DeleteMe.xls',

@provstr = 'Excel 8.0;HDR=NO;IMEX=1'

Some values in an Excel column...

WOW! Ok, Let me check so I can get back to you!

I have NO experience in database. I'm just a fresher out of college.

So lets see what I can...

UNION - Combines the results of two or more queries into a single result set that includes all the rows that belong to all queries in the union. The UNION...

Oh! Ok! I don't have much experience with Access.. so I thought I was probably doing something wrong!

Thanks, guys!

Its a query in Access SQL View!

Thanks a ton, guys! Yes, I agree with the 'truncate history row' part. That's exactly what I'm going to do.. will have to think over it a little.

Jsheldon, the purge...

Ok,

ONE:

The script to add columns to Access has to be applied on several servers across the organization as we maintain individual servers for the developers, testers, and so...

If I was to create a table with a column of datatype text and insert it with records through Management Studio or Query Analyzer, it would allow me to do...

I'm querying a remote database (at a different office site of the world) from Query Analyzer (SQL 2k).

I did read it.. but when I use the exact same query on my db, it only says -so n so- number of rows affected. Doesn't show me anything...

Totally sorted out!!

You know most of the times, mistakes are out of pure carlessness or oversight rather than lack of knowledge.. I can't always say that for me cuz...

Silly me!! Haha! Ok now i get what you guys are trying to say! I didn't pay much attention to that cuz I don't have any records for the 4th!

Silly...