wrap your initial query up into a CTE, then select from the CTE where rank in (1,2,3)

If its in the development stages, then you should be able to use perfmon on your development SQL server and identify the counters needed.

Granted this wont give you a true...

Another one to watch out for is Sybase's ability to store the following date

0000/00/00 00:00:00.00000

Even if you try to convert this to datetime2 you will get an error as that...

What is your process of transfering from Sybase to SQL.

I would make use of the datetime2 data type and load into a staging table, then use a convert call to...

What level of training do you need? SSRS Administration or SSRS Development?

I took the official MS course 6235 (I think) for SSRS, its a mixture of both, but focuses...

Your logic was sound in theory but not in practise.

Please follow the second link in my signature on posting code for the best help.

With that we will be able to create a mock environment and help you out

This will do the trick

SELECT

SubnetID,

COUNT(*)

FROM

#mytable

WHERE

STATUS = 2

GROUP BY

SubnetID

Its a GUI thing.

MS have simplified the GUI so that you dont need 1 GUI for Standard Edition, 1 GUI for Enterprise Edition etc etc, so you will see options...

Or change the registry, but as I say, I dont personally recommend doing that, but for something so small might be better than an uninstall reinstall. Might save you...

something like this should do it.

declare @sum int

select @sum = COUNT(co.orderno)From UserAccount as u

join CustomerOrders as co on co.VerifiedBy = u.ShortAbbr

where u.IsAdmin = 1 and u.CanVerifyOrder = 1

Select u.FirstName +...

Export, import, then open each MP in the new server and change the connection managers.

Or

Export, open each SSIS package in BIDS change the connection managers, import.

http://ss64.com/nt/robocopy.html

Use the above link to create your own ROBOCOPY command which does what you want it to do.

The link tells you about the main switches that you will need, then...

Ah well, I would say recreate them as when you save a maintenance plan, it stores the hostname in the connection string.

You could export them and import them, but you...

no as I said in my last post, that will only change the default language for any new logins which are created, not the actual instance.