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.

😎

achaudhr (5/12/2008)

---

Let me know what else should I put here to make you understand better

One example of the query I am using on the view is:

select BibNumber from [vw_TypesOnlinePeriodicalsJoin]

where TiQueryValue...

Also depends on the position you are being interviewed for:Database Developer vs Database Administrator as well as level Junior, Mid, or Senior. That would also impact the correctness of...

That is the RTM version. You need to download and install SP 2.

So how would you have written this question?