i am having 2 tables pur_hd and pur_det, Pur_hd is having invoice_date and
pur_det is having cost column, and common column purno is in both table for
linking.How can i take the cost of max(invoice_date)from pur_det table using
select stmt.

Heres an example of a query with the display
SELECT * FROM STOCKks WHERE Price < Cost;  Both price and cost are
smallmoney datatypes.  They display with 4 digits to the left of decimal pt.  
How do I set it to display only 2 digits for both colums?  

I have a table that has the significant date set up as a CHAR datatype with
length of 8, i.e 20051027.  I want to select all transactions where this date
equals the system date.

I have lost my password for my mssqlserver can someone help me retrieve it or
should I delete this server and download another.

  If I create a view consist of this query "Select Sum(Amt) From Table1".
Is it increase the performance rather then pass the "Select Sum(Amt) From
Table1" SQL statement to the reporting tools ?

I hope I can explain this a little better.  I have two tables that I need
information from.  The first table has all but two fields that I need.  I am
having two problems.  First all I want to do is read the first table take the
part number and check the second table.  If it is ...

I working with SQL Server 2000 table called dbo.test.
I need to separate value "User Name:xxx" that are in one column named "log"
that are space limited.
For example I have a column called log and the

English Query still available in SQLServer 2005, or something that implements
natural query?

I have the following view in my db:
SELECT     dbo.vw_rptShortagesFG.SalesOrder,
dbo.vw_rptShortagesFG.ReqShipDate, dbo.vw_rptShortagesFG.MStockCode,
dbo.vw_rptShortagesFG.Style,

I have imported a table into msSQL (2000)
One of the fields which was stored originally as a simple date field
(05/05/05) was created as nvarchar(8).
How to I alter this column to become a DateTime field type?

First thing I am new to write a query.  I have two tables that I need
information from.  The first table has the user, date and time.  The second
table has the user, date, time and a record that contains 132 characters.  
What I need to do is match the user, Date and time along ...

I have one table that contains, among other fields, a NAME and 14 SERVICE
fields.  The ID number is obvious and the SERVICE fields contain a "Y" if
that particular person (NAME) carries out the service.  A person can carry
out 1 or more services or the person can carry no service ...

I just could not figure out what is wrong or missing - here my sample code:
   Dim horse_recordset As New ADODB.Recordset
   Dim SQLstmt As String
   Dim xyz As Integer

I have a table that has:
sku, vendor_number, vendor_item_number.
Right now there are multiple vendor_item_numbers to 1 sku.  I need to find
just 1 vendor_item_number per sku (doesn't matter which one.)  So if I knew

Question:  If I have created a select statement that returns all possible
values, can I step through this list using SQL to get a random selection of
10% of the rows?  If so, what commands should I be looking at?  The closest
I've came was to get the top 10%.  However, I do not ...