Please try by adding SET NOCOUNT ON as the first statement of the sp.

G.R. Preethiviraj Kulasingham

Chief Technology Officer.

Softlogic Information Systems Limited,

14 De Fonseka Place,

Colombo 05.

Sri Lanka.

Try to put the conditions to Table C and check whether you have proper indexes and relationships. If still your query takes more time, try to reindex the table C

If...

I think you are trimming after concatatenation only

Try

update clnpers set cust_id = ltrim(rtrim(shop_id)) + ltrim(rtrim(rec_sname)) + ltrim(rtrim(rec_fname)) + ltrim(rtrim(rec_bday))

example:

if shop_id ='1 '

rec_sname='ss ...

I agree with Andy. Only exceptional tool may be Log Explorer.

Since the log file format is not disclosed by Microsoft, and If there is a crash between...

What Do you want?

What changes you want to check (schema changes, data or both)?

Are you planning to check only what are the changes (compare with another backup) or periodically...

In addition to what Smith had said,

If you are writing a trigger for update statement and if you are updating multiple rows using one statement,

please remember that you...

quote:

---

Is there a way to assign each of the values, i.e. t1.datefield to a variable....

i beleive the code would be

DECLARE @var varchar(255)

set...

This link may be usefull for you

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=19663

G.R. Preethiviraj Kulasingham

Chief Technology Officer.

Softlogic Information Systems Limited,

14 De Fonseka Place,

Colombo 05.

Sri Lanka.

What I meant as a clustered index generated by the system may what franch quotes as "phantom clustered index"

I believe that always system keeps "some sort of clustered index" like...

I think you have the answer in your question:

quote:

---

drop the clustered index - takes 6 hours!!

This is approx equal to...

Having the book is a great idea. But i prefre the e - Book so that I can aviod the shipment cost.(Outside US specially to asian countries)

The topics are so...

You wrote there can be maximum one full load per day.

I think that in your way it may accept 2 full loads

G.R. Preethiviraj Kulasingham

Chief Technology Officer.

Softlogic Information Systems Limited,

14 De...

quote:

---

SELECT TOP 12532 * FROM table_name and look at the last row.

By the way, if you have a clustered index on...

Create a UDF

Create myUDF(@LType, @LBeginDate)

Returns int

AS

BEGIN

Declare @Count int

IF LType ='F'

Select @Count=Count(*) from Table1 Where LoadType =@LType and

LoadBegindate=@LBegindate

ELSE

SET @Count=1

Return @Count

END

GO

Check Constrint on Table

Alter Table Table1 WITH NO_CHECK add Constraint...

Try this as well

http://www.sqlservercentral.com/scripts/contributions/242.asp

G.R. Preethiviraj Kulasingham

Chief Technology Officer.

Softlogic Information Systems Limited,

14 De Fonseka Place,

Colombo 05.

Sri Lanka.