saby (7/24/2009)

---

example

columns names a ,b c, d

a b c d

1 5 5 =10

2 4 10 = 14

3 8 14 = 22

i want to write a query so...

manoj2001 (7/23/2009)

---

Thanks for your reply lynn.

But i have change compatibility level from 100 to 90 then took a backup of 2008 database.

logically this should work, if i am not wrong.

please...

Unless you are having disk space issues on your server, I would not shrink the database.

I also made a couple of changes to my rewrite. I'd like you to test it out as well when you get a chance.

WITH TRAF (

...

Hopefully I caught it in all the right places.

SELECT

timesheet.ProjectId as Job_ID_Timesheet,

timesheet.TaskCode as Cost_Code_Timesheet,

timesheet.Name as Cost_Code_Description_Timesheet,

...

It is in parens, not brackets. Look...

Looks like you need to cast Timesheet.ProjectID as a VARCHAR(17) when comparing it to traf.WS_Job_Number.

Which may also require the COLLATE Latin1_General_CI_AS on traf.WS_Job_Number.

If you read the comment on that last WHERE clause, it can be dropped.

Nevermind, I figured it out. Missing a closing paren.

SELECT

timesheet.ProjectId as Job_ID_Timesheet,

timesheet.TaskCode as Cost_Code_Timesheet,

timesheet.Name as Cost_Code_Description_Timesheet,

...

Which one, my rewrite or your modifiy original code?

I think this is what will actually be required based on your original code.

SELECT

timesheet.ProjectId as Job_ID_Timesheet,

timesheet.TaskCode as Cost_Code_Timesheet,

...

Sorry, I may need to make a few more adjustments to your original code.

Here is your modified code.

SELECT

timesheet.ProjectID as Job_ID_Timesheet,

timesheet.TaskCode as Cost_Code_Timesheet,

timesheet.Name as Cost_Code_Description_Timesheet,

cast(null as varchar)...

If the data looks okay, we may need to add an ORDER BY clause to the code as well. I'm not sure how you'd want it sorted.

Just reads. I didn't see any UPDATE statement in your previous posts.