Diego Galeano

How to format the subtotals of a Reporting Services matrix differently, using InScope - Rob Farley : "Here's the scenario. Your SQL Server Reporting Services (SSRS) report has a matrix, showing the sales of each salesperson per year. You put conditional formatting in place so that cells in the matrix that have sales over 1000000 are in a different colour - which is done by putting a formula in the property 'color', like =iif(me.value > 1000000, 'Red', 'Black')" But then you put subtotals into your matrix (right-clicking on the column/row field to get the option), and you find that all the subtotals are being coloured Red, because together, they add up to more than 1000000. And this becomes a problem, because you can't put different formatting on the subtotal as you have on the rest of the inner cells of the matrix. That is, without having a slightly trickier formula. The function you want is INSCOPE. First look up the name of...

  Problem With SQL Server 2000, we had OPENQUERY and OPENROWSET to execute a pass-through query on the specified server, but it has several inherent limitations. Starting with SQL Server 2005 we have another more elegant way using "EXEC AT" to execute a pass-through query on the specified linked server which also addresses several shortcomings of OPENQUERY and OPENROWSET table functions. In this tip I am going to start my brief discussion with OPENQUERY and OPENROWSET table functions, its limitation and how the new EXEC AT command overcomes them. Solution SQL Server 2005 introduces an enhancement to the EXEC command to allow dynamic SQL execution on the linked server. The new EXEC AT command addresses the above limitations of OPENQUERY and OPENROWSET. EXEC AT specifies that command_string is executed against linked_server_name and results, if any, are returned to the client.  The linked_server_name must refer to an existing linked server definition ...

BBC NEWS | Science & Environment | How to fit 300 DVDs on one disc : "How to fit 300 DVDs on one disc"

  MIREN QUE MARAVILLA!!!   una foto de la toma de posesión de obama del 20 de enero pasado, en ella se puede distinguir claramente cada persona de la muchedumbre. Apunta a cualquier parte. haz doble click tanta veces como quieras para agrandar la imagen de la persona. espera unos segundos y veras la persona. esta foto fue tomada con una cámara robot de 1474 megapixeles, es decir 295 veces más potente que las fotos de 5 megapixeles de nuestras camaras. una sola foto y la posibilidad de "fichar " a un millon de personas ¡¡ http://gigapan.org/viewGigapanFullscreen.php?auth=033ef14483ee899496648c2b4b06233c

After installing oracle I got this error. The installer set up this variable automatically without any warning according with my regional settings and i didn’t need that. Solution: go to the registry to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 and leave blank the NLS_LANG key value.