Database

Member 8701813 wrote:

can anyone guide me ,how to decrypt the encrypted user defined function in sql server 2008

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

Member 8701813 wrote:

by d way i am not hacking anyone's db

Member 8701813 wrote:

i succeeded in encrypting but couldn't succeed in decrypting it

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

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?