Probably Deny ALTER to [role] might help but then the role created won't serve the purpose that it meant to. Therefore please do not execute this....

Let us wait to hear...

I could be completely wrong here but I guess in reporting services configuration manager under E-mail Settings tab SMTP server must be set to have this enabled for that instance...

Can you please post what did you try till now ?

Have you tried taking the backup of the database in the shared folder of your laptop. (assuming you are connected...

If values > 0 are to be viewed then in that case why not bring values > 0 only ?

Probably something like

DECLARE @T DECIMAL(10,2) = 1055263.55

SELECT ROUND(@T/100000,2)

Silly me .. I was trying with MERGE... It was so simple with CTE. Thank you @Koen Verbeeck

Could you please post DDL for table, some sample set and the expected O/P for the same ? This will help us understand and to work on the problem better.

If I understood your question correctly then MERGE statement should solve your problem. Please take a look at http://msdn.microsoft.com/en-us/library/bb510625.aspx

I'm not sure if I understood your requirement correctly or not but I feel dynamic SQL is what you are looking for ...If yes then something like following should serve...

You may try to use recursive CTE..

Please take a look at

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/95353/

Did you try using SSIS log provider for SQL server ?

In that case you would be able to join but it won't guarantee the output you are looking for ... Instead output will completely depend on how ID values are...

Have you tried using SP_MSforeachDB ? A vague code using it is written below...Please see if this helps

EXEC sp_MSforeachdb

'

IF EXISTS( SELECT 1 FROM SYS.DATABASES WHERE NAME LIKE ''%LETTER IN DB...

Not sure which will perform better the one shared by Eugene Elutin or the shared below...

It's been long since got a chance to use PIVOT thus the following solution

SELECT IDD...