Since you're getting a timeout table, I would say the easiest thing would be to script fewer tables at a time.

John

This ended up a little complicated, but it works, at least for the date range you provided. I had to mangle some of the keywords to allow me to...

I'm lost. What does "based on table name" mean? Choose the table whose name comes first alphabetically? Please will you post your whole query so I can...

COALESCE isn't going to work - it's only any use if any of the inputs are likely to be NULL. Now, where a column name exists in more than...

I take it the Sql Express 2008 Machine and your laptop are different computers? Have a look at the Security tab of the linked server object and work out...

Not enough information there, I'm afraid. Please will you post a script to create the linked server, and an example of a query that doesn't work, together with any...

Yes, but that's not because of the INNERness or the OUTERness of the join - it's because you're joining on Location. Since many projects can share the same location...

No, not as far as I know. What permissions is he missing? How did you do the attach and reattach of the databases? What did you change...

OK, here's your issue. Another poster changed to a LEFT JOIN to ensure you get all the projects, and you ran with that also. That's fine, but for...

What do you mean, why doesn't it work? Error message or wrong results? Do you have any projects where ProjectType is blank?

By the way, you need to be...

WHERE p.ProjectType <> 'New' AND (ABS(DATEDIFF(month, p.Finish, np.Finish)) <= 2

or

WHERE p.ProjectType = 'New'

John

You can't restore a database to a server with a lower version number. That doesn't also apply to the build number, though.

John

No CASE expression needed - change your WHERE clause:

SELECT DISTINCT [User name]

FROM MeADBA.dbo.DBUserDetails

WHERE [User name] NOT LIKE 'PERLON\%'

AND ([User name] NOT LIKE 'RMH\%' OR [User name] = 'RMH\AdminFunkdoobiest')

John

Is it as simple as this?

,CASE WHEN [>7 Days] = 1 THEN COUNT(invoiceid) ELSE 0 END AS InvoiceCount

,SUM(CASE WHEN [>7 Days] = 1 THEN 1 ELSE 0 END) as RowCount...

The snapshot is a sparse file - it starts off small, and as data pages in the source database are changed, the old version of the pages are written to...