Thank you everyone for your suggestions.

Below is the DDL of the table in which I insert and search. This table currently has 5,10,278 rows(half million) and records are inserted daily.

Actually...

Thanks all for the replies...

Apart from what was suggested by all would it help if I made a view and transferred all data in a separate table for the reports.(because...

I have used nolock also. still the slowness occurs sometimes.

Thanks

Thanks to all for your replies

What I understand from your replies is that it would be best to have the identity column for the join rather than the generated string...

I am using SQL server 2005 and when I try this code for generating a running sequence no. to start from 1 it gives me the error

SELECT ROWNUMBER() OVER (ORDER...

I tried your example with sql 2005 but it gives me this error

Msg 195, Level 15, State 10, Line 1

'ROWNUMBER' is not a recognized built-in function name.

Thanks for the replies. I am looking for a simple serial no. count starting with 1,2,3......

I just have to display the customerid and customername along with a serial no. starting...

Thanks for the help

What I did was

1) Took backup of my database in sql 2000 (db name is CLG and login and user is CLGUSER)

2) I created a login...

Thanks for your reply.

The Transfermaster does not have a category because while doing a transfer that transfer can happen from 1 source to 1 or multiple destinations under the same...

Sorry I should have done it earlier.....

The structure and data of the tables is as follows:

create table InternalSource

(

SrcId int IDENTITY(100,1) PRIMARY KEY CLUSTERED

SrcName varchar(50)

)

create table ExternalSource

(

SrcId int IDENTITY(100,1) PRIMARY KEY...

I was just curious to kwow that in a application which revolves around the balance amount is it a better practice to store the balance for each category or is...

/*CREATE TABLE PurchaseTranMaster

(

TranID int IDENTITY(1,1) PRIMARY KEY CLUSTERED,

...

Thanks for reading. After reading I know my post looks messy. I hope I was able to explain what I intent to do. I have the table DDL below

Thanks for your replies. I have changed my initial logic plan in the last 2 days and now I need to store the data rather than update it. My aim...

Thanks for your help.

What I meant was instead of storing the balance in a table if I am just inserting the purchase transaction in a table. So everytime before I...