for xml explicit

Due to restrictions on implicit column alias usage in SQL queries (only in ORDER BY), Emtucifor (Erik) suggested the idea of explicit expression aliasing. I like the approach because it makes the query easier to read and increases the SQL developer productivity. What do you think?

Example query for explicit expression aliasing:

SELECT 
  [Year],
  [Month],
  SUM (H.TotalDue) TotalSales
FROM AdventureWorks2008.Sales.SalesOrderHeader H
USING 
  YEAR (H.OrderDate) AS [Year],
  MONTH (H.OrderDate) AS [Month]
WHERE [Year] > 2002
GROUP BY [Year], [Month]
ORDER BY [Year], [Month]

This thread is a spin-off from: http://social.msdn.microsoft.com/Forums/en/transactsql/thread/4ad14cad-1e61-43a0-96f8-70a506106a00

 

I create an IPCChannel on the server and register a singleton with it.  My client creates an instance of this remote object for communication purposes.  If the server process is restarted, my client can detect this and will try to re-activate the remote object.  It seems that if this disconnect/connect to the server happens to quickly, the client will receive a RemotingException indicating "Access Denied".  This leads me to believe that cleanup of the named pipe needs to be done when the service shuts down, to ensure it is available immediately upon restart.  However, to accomplish this I've tried IPCChannel.StopListening(null), ChannelServices.UnregisterChannel(serverChannel), and also setting the remote object to null on the client -- all to no avail.

 

I found a newsgroup article where folks report identical behavior with no resolution: http://groups.google.com/group/microsoft.public.dotnet.framework.re

Hi, so on msdn page

http://msdn.microsoft.com/en-us/library/9yb8xew9.aspx

They say

<quote>

The disadvantage of omitting IEnumerable and IEnumerator [in C#] is that the collection class is no longer interoperable with the foreach statements, or equivalents, of other common language runtime-compatible languages.

You can have the best of both worlds, type-safety within C# and interoperability with other common language runtime-compatible languages, by inheriting from IEnumerable and IEnumerator and using explicit interface implementation as demonstrated in the following example.

</quote>

But the example they show right beneath that, does it actually contain any explicit

I have the following C# code in a method of a class that inherits from Image. Basically I'm setting a random left margin (within some parameters) relative to its container (a Grid object).

int auxLeftMargin = rand.Next(Convert.ToInt32( ((Grid)Parent).ActualWidth / 4), Convert.ToInt32(((Grid)Parent).ActualWidth - ((Grid)Parent).ActualWidth / 6));

Margin = new Thickness(auxLeftMargin, Margin.Top, Margin.Right, Margin.Bottom);

I've changed the container type a couple of times already, so I would like to be able to not have it hardcoded. I've tried casting with "( Parent.GetType() )" but it doesn't work.

Is there a way to do this dynamically? Thanks.

Hi

I try to pass my parameter CRM_FilteredSystemUser from my main report to the sub report.

So it's working fine in the main report. And it's working fine as parameter entered by myself testing straight in the subreport.

But I don't know how to set this parameter in the subreport to make this work.

In my main report I pass the CRM_FilteredSystemUser =Fields!systemuserid.Value to the sub report.

My main report has as report parameters : CRM_FilteredSystemUser, Non-queried : SELECT systemuserid,eu_securityrole, eu_reporthubname, fullname, businessunitidname FROM FilteredSystemUser

I'm using as well this parameter in my subreport : ...SELECT  businessunitidname,  EU_attendanceentry.*
FROM EU_attendanceentry INNER JOIN  ('+@CRM_FilteredSystemUser+') ....

In my subreport I've a report parameter :  CRM_FilteredSystemUser / Non-queried : =Parameters!CRM_FilteredSystemUser.Value

But doint that I've the error: An error occurred while executing the subreport ‘subreport1’: The definition of the report '/Calls per field Day_SubReport' is invalid.

I'm very confused there,