This sample file should help you get to where you need to go. I have successfully tested it on my machine.

declare @tbl1 table(

id int,

descr varchar(25)

)

declare @tbl2 table(

id int,

descr varchar(25)

)

insert...

I just read you post again :hehe:

Let me have another look.

-Adam

After reading the post again, my previous post did not give you the result you are trying to achieve.

Let me look at it a little harder.

Have you tried to join them?

SELECT *

FROM TABLE1 a

INNER JOIN TABLE2 b ON A.id = B.id

Use dynamic SQL to generat the backup with a variable to house the date.

e.g.

DECLARE @sql NVARCHAR(200), @dt VARCHAR(20)

set @dt = rEPLACE(convert(varchar,getdate(),101),'/','')

set @sql = N'

BACKUP DATABASE LcsLog

TO DISK = ''\\HQ-NAS1\SQLBACKUP$\HQ-APPS2\Data\LcsLog' +...

MCITP: Database Developer

http://www.microsoft.com/learning/mcp/mcitp/dbdev/default.mspx

In getting this certification, you must also get the MCTS: SQL Server 2005 certification, as it is a prereq.

http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx

It sounds like the you dont have access to the server you are tyring to copy to. The login timed out because it could not connect.

Verify that you can...

Only with Filegroup...

Create the backup...

I have seen it where tsql code breaks because of compatibility level. Some code that works on 2000 is not compatible with 2005 because of syntax.

Another solution:

select *

from Test e

where e.date = (select max(date) from Test a where e.name = a.name)

order by e.name

Yes, SQL server Management Studio is different between standard and express. I believe that the Express verison is stripped down. One piece of evidence that leads me to...

Update:

I created a new query with the the script you provided to determine fragmentation level? I take it that was what I was supposed to do? I ran it and...

The clean up task is exactly what you need 😉

And I believe reporting services comes with Express to.