You have to write seprate UPDATE/DELETE statements to update/delete rows from each table.

INNER JOIN can be used in UPDATE/DELETE statements.

INSERT INTO #TEMPTBL (formula, final_formula) VALUES (@FORMULA, @FINAL_FORMULA)

select PersonId, count(PersonId) as NullCount

from dbo.Table_1

where value is null

group by PersonId

1) Create a temporary table with required columns (3 columns for given year, 3 for previous year).

2) Insert values to the first 3 columns for the date range passes as...

Do you mean data diagram? Click "Database" in the menu, then select "Reverse Engineer..."

Suresh

1) Defragment the indexes.

2) INCLUDE the SELECTed columns in the nonclustured indexes.

>>after some hours log file size increases about more than 2gb. Thats the issue.

May be, there are so many transactions. Check it with Profiler.

Don't shrink the log file, unless you...

select name, is_published, is_subscribed from sys.databases

BOL says:

If ALL is specified and the underlying table is a heap, the rebuild operation has no affect on the table.

Your table is a heap (= table without clustered...

Check whether there is trigger.

>> Transaction is taking more space after truncating also.

What is meant by taking more space? Does it mean log file size is same as before?

Did you shrink the log file?

Check...

The .BAK file should contain full database backup.

If it contains only differential backup, it is not enough.

Suresh

select distinct i.number, m.text1, i.name, i.date

from dbo.Main m

inner join (

select e.number, e.name, e.date

from dbo.Entries e

inner join (

select Number, max(date) as date

from dbo.Entries

group by Number

) s

on s.Number = e.Number

and s.[date] =...

select Number, Text1, [name], max(date) from

(select distinct e.Number, m.Text1, e.[name], e.date

from dbo.Entries e

inner join dbo.Main m

on e.Number = m.Number

) a

group by Number, Text1, [name]

(8 row(s) affected)

64694826363769AbdulS2007-11-28 10:10:40.457

64694826363769MariaC2008-05-06 08:26:27.553

64695495673941HillaryL2008-05-15...

Try Windows Scheduled Task.

Suresh