Hi,

before that try this,

use the default is easy option and common usage.

create table #temp

(

slno int,

DBNAME varchar(10) default db_name(),

servername varchar(15)default @@servername

)

insert into #temp (slno)

select 1

select * from #temp

ARUN SAS

Yes,Possible

ARUN SAS

Hi,

During sort, make sure no insert,update and delete operation happened in the main table the put the nolock in the main table

ARUN SAS

Hi,

Your just select (retrieve) the record? If so, then no need to think the concurrency just put the locks in the main table.

You need to stored the record with concurrency...

Hi,

For better assistance in answering your question

See this link http://www.sqlservercentral.com/articles/Best+Practices/61537/

Then post your codes.

ARUN SAS

Hi,

NO, in the Citrix, the workstation name for all users is same i.e. only unique Citrix server name retrieved for...

Hi,

System_user and @@spid is enough to act like better concurrency,

Instead of system_user use the workstation name (host_id()) gives best concurrency in the Static temp tables.

ARUN SAS

Hi,

you need sort in the...

hi,

show you tables

1)Emp_SalaryDetail,

2)Emp_EmployeeMain,

3)Emp_SalaryStructured,

4)Emp_SalaryDeduction

with sample data

ARUN SAS

Hi,

Then how you are calculate the TotalSalary?

ARUN SAS

Hi,

Try the

EXEC sp_lock

ARUN SAS

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

01 ...

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 ...

Hi,

once againg see/study the above simple pivot code.

ARUN SAS

Hi,

try this

create table #temp

(

figno varchar(3)

)

insert into #temp

select '1'

union all

select '2'

union all

select '3'

union all

select '1a'

union all

select '2b'

union all

select '2c'

union all

select '1c'

union all

select '11'

union all

select '12'

select * from #temp

select * from #temp

order...