Assuming that the source and destination tables have a common unique key, you would do a lookup in the destion table to see if the record already exists. If...

I think I'm still a little lost. Given date 'x' what are you expecting regarding start date and end date for 2 months? Same for the week start...

Have to ask, has anything changed since the last time everything ran okay?

kramaswamy (11/2/2011)

---

Actually, a followup question for this -

Upon thinking about this a bit more, I realised that in order to get what I'm trying to do to work, I'll need...

I find it easier if you show me what you are looking for, I figure things out better when I have a picture of what is needed. Think you...

IIRC, and this may have changed, converting an Access MEMO field to SQL Server becomes an NTEXT or TEXT...

Sounds like an echo. I seem to remember...

Yes, and some how they need to link together unless a cartesian...

Edit: Never mind, I missed the flipping of first and last name as well.

This?

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

CREATE TABLE #mytable

( MyColumnName varchar(50))

INSERT INTO #mytable(MyColumnName)

SELECT 'LN1,...

The questions should be related to something else you really can't do much unless you develop your own schema to answer the question(s). Since we can't see your book...

You are apparently using SQL Server 2008 based on the forum you posted. Put the two queries into CTE's and then use those CTE's in the final query.

Here is...

And if this is homework (which it really looks like it), also show us what you have have tried so far and where you are having problems.

We'll help you help...

Start with what Gail suggested. Also, do you perform any scheduled database maintenance, such as defraging indexes, updating statitistics?

Not sure what you are asking. Please read the first article I reference below regarding asking for help. It will show you what we need and how to...

Would help if you provided us with the DDL for the table(s), sample data, and expected results based on the sample data.

Please read the first article I reference below in...