Viewing 15 posts - 19,561 through 19,575 (of 26,490 total)
saby (7/24/2009)
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...
July 24, 2009 at 12:36 am
manoj2001 (7/23/2009)
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...
July 24, 2009 at 12:30 am
Unless you are having disk space issues on your server, I would not shrink the database.
July 24, 2009 at 12:28 am
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 (
...
July 24, 2009 at 12:24 am
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,
...
July 24, 2009 at 12:19 am
paula (7/24/2009)
Can you please show me how to do that? Sorry, I am new to all this.Why have you got 17 in brackets.
It is in parens, not brackets. Look...
July 24, 2009 at 12:17 am
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.
July 24, 2009 at 12:06 am
If you read the comment on that last WHERE clause, it can be dropped.
July 23, 2009 at 11:57 pm
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,
...
July 23, 2009 at 11:56 pm
paula (7/23/2009)
Ok. I ran it and got this error:Msg 156, Level 15, State 1, Line 62
Incorrect syntax near the keyword 'where'.
Which one, my rewrite or your modifiy original code?
July 23, 2009 at 11:52 pm
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,
...
July 23, 2009 at 11:43 pm
Sorry, I may need to make a few more adjustments to your original code.
July 23, 2009 at 11:39 pm
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)...
July 23, 2009 at 11:32 pm
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.
July 23, 2009 at 11:18 pm
Just reads. I didn't see any UPDATE statement in your previous posts.
July 23, 2009 at 11:17 pm
Viewing 15 posts - 19,561 through 19,575 (of 26,490 total)