Hi Sql Guru I tried with example which u gave but it is much time than what i already had can u give me those two possible

solutions

Hi John iam attaching execution plan pls go through it.

yes but i don't have any other go any ideas/suggestions are welcome.

Thank you john for you r favour but this is taking much time than my stuff as i am getting duplicate records...

sorry i couldn't understand what it mean execution plan can u explain me once

User_master table has nearly 30 columns, primary key is on user_name and one composite index is there which is created taking almost all columns and password filed is having non...

Hi Steve

Table Name: sale_Transactions

Followinga are the columns

Txn_IDnumeric(10, 0)

Txn_Typevarchar(10)

Txn_Modechar(1)

Prvd_IDvarchar(50)

Vendor_IDvarchar(50)

Payer_IDvarchar(50)

CSUser_IDvarchar(50)

CS_TxnIDvarchar(50)

Txn_Datedatetime

CS_Txn_Modevarchar(1)

Indexes are as follows

Clustered index is on 'Txn_ID' whic is having primary key

composite indexes is on 'Prvd_ID,Txn_Date' and 'Vendor_ID,Txn_Date'and...

Hi Steve

Table Name: sale_Transactions

Followinga are the columns

Txn_IDnumeric(10, 0)

Txn_Typevarchar(10)

Txn_Modechar(1)

Prvd_IDvarchar(50)

Vendor_IDvarchar(50)

Payer_IDvarchar(50)

CSUser_IDvarchar(50)

CS_TxnIDvarchar(50)

Txn_Datedatetime

CS_Txn_Modevarchar(1)

Indexes are as follows

Clustered index is on 'Txn_ID' whic is having primary key

composite indexes is on 'Prvd_ID,Txn_Date' and 'Vendor_ID,Txn_Date'and...