It may take me some more time to try out your code because I need to understand it first.

I hope you don't mind waiting.

Why is it the number 17 with varchar and not 16 or 18,19 etc.

Is this what you had in mind for the first part of the query looking at ProjectID:

SELECT

cast(timesheet.ProjectId as varchar(17)) as Job_ID_Timesheet,

timesheet.TaskCode as...

OK. Sounds great.

OK. Thanks very much. I will have a try now.

Can you please show me how to do that? Sorry, I am new to all this.

Why have you got 17 in brackets.

I think I am down to my last error now:

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the varchar value '0802M10 ...

Ok. I ran it and got this error:

Msg 156, Level 15, State 1, Line 62

Incorrect syntax near the keyword 'where'.

Just another question if I may. I would be interested if you don't mind having a look at what changes would need to be made to my existing code.

Thanks again!!!

WOW!! Thank you so much for spending the time doing that.

Just a quick question before I run it..... Does this code do any writing to the database or is it...

Here it is for the task table:

USE [Web TimeSheet]

GO

/****** Object: Table [dbo].[Task] Script Date: 07/24/2009 13:55:40 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Task](

[Id] [int] IDENTITY(1,1) NOT...

Thanks again for your help.

How do I get a copy of the DDL?

Hi there,

Thanks you so much for the reply. Just to let you know I am looking to Create a View with this query. Just out of interest, is it...