Derek Dongray (11/4/2008)

---

Not...

Hi

Iam afraid you will have to write your own storedproc/ trigger. I cant do that for you. If you know oracle then doing it in SQL should not be a...

You can use a CTE to find out the parentusers. Ex: Userid 9 -> UserID 7 -> UserID 1 and so on. You can then assign points to these...

Hi

I feel you need only one User table. Columns - UserID,Name,ParentUserID.

Whats the logic behind Right & Left. Wont knowing the parent of the user suffice?

Hi

query to find matching records

select * from indus WHERE qh11 like '%' + qh21 + '%'

query to find non matching records

select * from indus WHERE qh11 not...

Well your question is not clear but try this

This query will return rows where qh21 is "present" in qh11. Ex:- value 1345 in qh21 column is present in 134567890 in...

Hi

The point is if you have declared a parameter for a stored proc then it needs to be passed from your application.

Cant see ur code but if varchar(4000) is the problem try using VARCHAR(MAX).

Hi

You dont need a where clause since you are passing null

if @P1 IS Null

Begin

SELECT [UID]

,[StaffNumber]

,[BusinessReason]

...

You cannot use output columns of a sp to join with other tables.

Select empid,checkintime from EducationDepartment

WHERE DATEDIFF(ss,checkintime,getdate()) < 7200.

I have converted 2 hrs into seconds to get as much correct results as possible.

You are using a substring function in your code. check the value of the length parameter being passed.

Article talks about using a trigger not a stored procedure.

Well i assume that the op will insert data into the first table (which ever it is ) and then into the other table....in the normal way.

GilaMonster (12/10/2008)

---

sunandas (12/10/2008)

---

I need to do reindexing as the tables are very big and if I wont do reindexing then locking in objects and for which the agent's system are...