Thanks Eugene Elutin.

Eugene Elutin (3/7/2012)

---

That is exactly what I was asking for!

Here we are:

I guess your setup should be changed to:

CREATE TABLE #ReportingToPerson

(

Staff_ID INT,

Staff_Name VARCHAR(50),

Reporting_To_ID INT,

Department_Head BIT

)

INSERT INTO #ReportingToPerson...

Hi Eugene Elutin,

I missed one more Column called Department_Head. If Department_Head means value will be "1" else "0". "Senthil", "Ramalingam" and "Kumaran" are different department level heads. "Karthik" is user...

Hi Eugene Elutin,

I want to find the approval level person id by passing current login person id. Form the above records "Kumaran", "Ramalingam" and "Senthil" are the approval person.

Approval Level:...

Hi,

Yes i need to get the return values from every table where the particular value in the UserID Column.

Thnks,

Senthil.

ChrisM@home (10/26/2010)

---

Senthil Varadharajan (10/26/2010)

---

Hi,

Is it possible to find the single user map...

Hi Adiga,

I need to find the particular userid referenced to how many tables in the application.

Eg: If Login UserID = 1. I need to find the values used in how...

Hi Adiga,

AS per your reply i done the steps and i got the solution from local machine. When i tried in the server i got the following error.

Error:

-----

Msg 4305, Level...

Hi Dugi,

While running the update statement, missed to select the where condition. So i need to restore data using the transaction logs. Can i know the process to retrive it.

Thnks,

Senthil...

Hi GilaMonster,

Can you explain me how to restore from the transaction log.

Thnks,

Senthil Varadharajan

Hi Adiga,

Can you explain me how to restore from the transaction log.

Thnks,

Senthil Varadharajan