This should do what you want:

--I have a question which is probably really basic but can't work it out for the life of me so i thought i'll ask for...

I don't think the OP will notice because he hasn't logged in since 2009....

How about this?

--========= TEST DATA =============

declare @a table ([User] int, [Year] Char(4), Status1 Char(4), Status2 Char(4), Status3 Char(4));

insert @a values ( 1, 2011, 'Pass', 'Fail', 'Fail' );

insert @a values (...

This is quite similar to the other one - the main change is the section for allocating sequences to the ground- & air- turnbacks.

Again you will need to add/delete columns...

Not sure why you've got some rows with Common=0 & not others..

But how about this?

--==== TEST DATA ======

if object_id('tempdb..#temp') is not null

drop table #temp;

create table #temp

(

Client_id int,

id int,

value int

);

insert #temp...

ChrisM@Work (9/19/2012)

---

Easy - but first, we need to sort out your dates. You do yourself no favours by changing the date arithmetic back to the original each time I attempt...

Can you give an example of what you're thinking of?

This should do it - You'll need to add extra order dates as required.

--======= TEST DATA ==========

if object_id('tempdb..#ORDERS') is not null

drop table #ORDERS;

create table #ORDERS

(

UserID int,

OrderDate datetime

);

insert into #ORDERS values...

It's not something as simple as...

SELECT *

INTO dbo.new_table_name

FROM dbo.existing_table

... is it?

This does the job. I've included all code as I've added an extra row & corrected a time.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

--========= DROP TABLES IF THEY EXIST...

Try Books On Line:

http://msdn.microsoft.com/en-us/library/ms157328.aspx

--====== TEST DATA SET-UP =================

if object_id('dbo.pvt') is not null

drop table dbo.pvt;

create table dbo.pvt

(

reckey varchar(10),

amt1 decimal(8,2),

amt2 decimal(8,2),

amt3 decimal(8,2),

amt4 decimal(8,2),

amt5 decimal(8,2)

);

insert dbo.pvt...

Hi

Something to bear in mind:

I used an inner join from dbo.MSP_EpmProject_UserView to [MSPCFPRJ_Business Owner_AssociationView] because that's what's in the code above. If [MSPCFPRJ_Business Owner_AssociationView] hasn't got a match for...

Is this what you want?

SELECT p.ProjectUID, p.Project_Status,

p.ProjectName AS [Project Name], p.ProjectModifiedDate AS [Last Modified],

...

What are you trying to do exactly?