Yah there is difference, becuse your output shows like this,

TotalSalary

1233

124

12

122

.

.

like so on.... this is not going to show the whole information dear which i need.. Now i hope you have...

arun.sas (5/14/2009)

---

waqarlaghari (5/14/2009)

---

Now I want to write a stored procedure which show Data like this....

EmployeeID -- Basic Salary -- Medical -- Connvence -- IncomeTax -- LeaveFine -- Loan -- TotalSalary

01...

I have check it not once but a lot of time it is given me the right result. Please brother you check it first may be you were worng... I...

this is not working dear,

It gives only totalsalary and nothing else...... Do you have an other idea...

I have table named Emp_SalaryDetail Which contains following coloumns.

EmployeeidFk -- SalaryStructuredID -- SalaryStructureAmount --...

this dear, after try i will send you response... Again thanks.

Thanks brother for your reply..

I am stuck in condition. Because i am working on project which developed by another person. In quries it uses both words "Left Outer Join" and...

Dear Brothers thanks a lot.. Speacially Ramesh

Best regards

Waqar Hussain Laghari

Software Engineer

This qurey does not show me records which are present.....

if i remove the TimeIn = '3/31/2009' then it show me records...

If you have idea about this..

Best regards

Waqar Hussain Laghari