Database

Shiv irfi wrote:

I created a table which has following columns Sl_no,name and employee_id

SELECT Sl_no, name, employee_id
  FROM [a table]
 WHERE 1=1

Shiv irfi wrote:

Is that a possible when i select a table i should get a designation of an employee in place of his name??

SELECT Sl_no, designation, employee_id
  FROM [a table]
 WHERE 1=1

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

CREATE TABLE EMPLOYEE
(
	Sl_no int identity,
	Name varchar(40),
	Employee_id int

)

INSERT INTO EMPLOYEE(Name,Employee_id)
SELECT 'Anil',1001
UNION ALL
SELECT 'Mahesh',1002
UNION ALL
SELECT 'Raju',1003

CREATE TABLE DESIGNATION
(
	Employee_id INT,
	Designation varchar(30)
)

INSERT INTO DESIGNATION
SELECT 1001, 'Developer'
UNION ALL
SELECT 1002, 'Tester'
UNION ALL
SELECT 1003, 'Trainee'

SELECT E.*,D.Designation FROM EMPLOYEE E INNER JOIN DESIGNATION D ON E.Employee_id=D.Employee_id

ContractID (INT)<br />
OrderSource (INT)<br />
AgentID (INT)<br />
ProvinceID (INT)<br />
DeliveryMethod (INT)

SELECT
    CustomerID,
    MIN(OrderPlaced),
    --(Some or other subquery to get the value for AmountOrdered),
    --(Some or other subquery to get the value for ContractID),
    --(Some or other subquery to get the value for OrderSource),
    --(Some or other subquery to get the value for AgentID),
    --(Some or other subquery to get the value for ProvinceID),
    --(Some or other subquery to get the value for DeliveryMethod)
FROM Orders
WHERE ProductID = 123
GROUP BY CustomerID

SELECT *
FROM Orders
WHERE OrderID IN (
	SELECT (
		SELECT TOP 1 OrderID
		FROM Orders O2
		WHERE CustomerID = O1.CustomerID
		ORDER BY Inserted
		)
	FROM Orders O1
	GROUP BY CustomerID
)

Jörgen Andersson wrote:

I believe one subquery is unnecessary. Try:

SQL

SELECT  *
FROM    Orders
WHERE   OrderID IN (
    SELECT  TOP 1 OrderID
    FROM    Orders O1
    GROUP BY CustomerID
    ORDER BY Inserted
)

Daaron wrote:

is there a way to crowdsource the solution?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

What's a VA?

Daaron wrote:

is there a way to crowdsource the solution?

Daaron wrote:

crowdsource the solution?

Muveen_Delhi wrote:

How many tables should I make

Muveen_Delhi wrote:

How can I design the database to show the record on the page.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]