Only if it is running a virtual machine running a Windows OS. SQL Server can't be installed directly on a non windows OS.

Gift Peddie (7/24/2009)

---

Actually no data backup...

Actually Jeff, please do post the url when you find it.

Gift Peddie (7/24/2009)

---

Ok I am assuming there is a comprehension problem here data is just part of what is lost recovery from data pedestrian. While code is not so...

No.

Gift Peddie (7/24/2009)

---

I had backup but data backup and development backup are not the same that is the reason software development companies sell source control systems. So the only...

Could be how the data was moved around in the datapages as it was converted. More pages could have been allocated to store the same amount of data.

TAman (7/24/2009)

---

I think we are really close, but when I add a date range in my WHERE clause(see below)

WHERE DATEDIFF(mi,L1.Start_Entry,L2.Start_Entry) < 60 AND Start_Entry BETWEEN '07/01/09' AND '07/23/09'

I get...

Yes, you also need the cast to varchar(17) for ProjectID in the select statement as well. Good catch, be sure to do it in the third query in...

Consider this, each row of the ntext (or nvarchar(max)) column could...

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,

...