My only problem is may not have the math right. I can't get the same values when using Calculator, so please double check the equation used and provide feedback...

Here is my updated version. Please note that there is now a clustered index on EmpNo and PerDate. This is required for this to work. It is...

Okay. I think you provided incomplete info in your posts, unless I missed it, as I didn't see anything resetting @FinalData to 1 on an employee or year change....

Not going into the code, this is actually a good time for you to also try out writing a recursive CTE (since you are using SQL Server 2005, based on...

The only other question I have, are there primary keys defined on the tables as well?

😎

This is the way you should do it:

if exists(select object_id(N'tempdb.dbo.##tmp_mj_jobSync'))

drop table ##tmp_mj_jobSync

Select * into ##tmp_mj_jobSync from mj_jobSync

😎

This?

If exists (select top 1 * from ##tmp_mj_jobSync)

Drop table ##tmp_mj_jobSync

Select * into ##tmp_mj_jobSync from mj_jobSync

Actually, there is something better, but I have to find it... Stay Tune.

😎

I think this is what you are asking for, but realize that @FinalData will not reset to 1 when EmpNo changes. If that is also a requirement (not stated...

If you have this table in a development environment, have you tried creating an index like this:

create index IX_DateColCol1Col2 on dbo.BIG_table (

datecol asc,

...

Here is the sample data you provided:

EmpNo PerDate PerformanceData GrossData FinalData

1 01/10/2006 1.4534...

re_dean_illumina (5/13/2008)

---

We're having the same problem. And, we're finding that the database is growing by 3% per day (or about 20% a week), and it is two tables ......

If you look in BOL you'll find all the information you want and were afraid to ask about the table backupset.

You will find there that the file size shown in...

I like photography, just haven't really been into it lately. Was really into it while in junior high school. Had a darkroom at home and everything. Only...

achaudhr (5/12/2008)

---

Is it going to cause lot of complications/ changes to be made.

I tried to create it said full text searching not enabled then I enabled it via

sp_fulltext_database @action='enable'

then tried...

You may want to consider full-text index.

😎