Here is the situation
Table 1 : tbl_documents
docID    docName
1    aaa

Is this possible?
A char variable length field contains this data: (for example)
ABC,XYZ,GEF,CAB
I need to query another table on the contents of each of these names that

I am having a little problem creating this query.
I have a stored procedure that accepts 4 parameters.
One of the parameters tells the query which column to sort on.
Select

I have a result set that returns Loctation Codes.
Each location code is the following format: [Letter][2 Digit Number].
For example,
A10

Is it possible to add a column description when creating a table? An example
would be great.

Hi there, I'd like to ask you for help with following:
having 3 tables:
T1 (Person_ID, Product_ID, Costs)
T2 (Person_ID, Product_ID, Balancies)

I have a table with the fileds  empid,empname,designation,branch.. etc I
have 5 types of  designations CEO,BM,PL,Tester,and PRG and the two branches
those are Hyderabad and Visakhapatnam i need the query like
first CEO name next Hyderabad BM Name next Hyderabad PL name next ...

I created a stored procedure that renames a table to OLD_xxxxx and replaces
that table with another (copy) that resides on a different database. I pull
the
tablename names through the use of a cursor table and construct a SELECT INTO

I'd like to display the result of this query in percentage:
SELECT SYS.Client_Version0, SYS.Client_Type0, count(*) as 'Count'  
FROM  v_R_System as SYS
WHERE SYS.Client0=1  

I have a query that returns back rows that have multiple entries for a given
UniqueID.  I want the query to be expanded so that it then only returns 1 of
the multiple rows based on the maximum date.  Thefore, my return set looks
like this:

I have two sets of Data. For example Sales And Purchasing.
SALES(ISAL)
PURCHASING(IPUR)
-------------------------------

I have a db  which stores all my sales transactions.
The task is to extract the buy price(price) for each item(ItemCode) where the
date is the latest for each item.
For Example:  

How can I get this to work?
declare @WkEmpID
declare @sql varchar(1000)
set @sql = 'select distinct @WkEmpID = EmpID from Employee'

  Can someone help me to build a query base on :
  SELECT  Full_Name,FLT_ID, FLT_DT_ID,PNR_ID
  Where Full_Name,FLT_ID, FLT_DT_ID is duplicate in the same table
Thank You very much

Here is what I am trying to do.
I need to query a table like this:
SELECT     PROPERTYTYPE, INDUSTRY, ORGNAME
FROM         ORGANIZATION