Thanks Solomon.

It is a median of float values. Sorry for the confusion. The return of the query is date, median(list) is what I meant.

I will follow up on...

Hello Solomon, thanks for your reply. It's been a while but I use this code to compute a median for a list that varies every day.

so basically date(T), median(list(T))....

Hi everyone, not sure if anyone is still looking at this thread but recently I have been running into the following error. I inspected the data but I am not...

It actually worked when using the UNC. Thanks!

Oh and \\CTrading\public is H: as shown in the screen shot attached.

Thank you Orlando. I will definitely take a look.

Just to clarify though,I do have access to the remote drive as shown in the screen shot attached.

Thanks

Hi Orlando,

Great article. Thank you.

The script seems to have an issue finding a server path. I am not sure why it's not finding the folder.

Please see attached...

Hi guys, I am using the CLR and for some reason I get this error :

A .NET Framework error occurred during execution of user-defined routine or aggregate "Agg_Median":

System.InvalidCastException: Specified...

Thanks but still get this error message:

TITLE: Microsoft SQL Server Management Studio

------------------------------

The Activity Monitor is unable to execute queries against server DSQL.

Activity Monitor for this instance will be placed into...

Thanks

Where do I do the grant view ?

hi adejola,

After following the instructions you provided. I get the following error:

"TITLE: Microsoft SQL Server Management Studio

------------------------------

The Activity Monitor is unable to execute queries against server DSQL.

Activity Monitor...

Very much appreciated!

This article has been very useful!

Thanks again

Thanks for the article but it seems that the link is not working.

CreateAssemblyAndAggregate.sql

Also when I try to create the procedure below I get an error. I named the dll...

Thanks for the article.After reboot, I tried going through the steps but when I set up the alert at the end, I get the following error message:

The specified object_name('SQLServer:Loks')...

Hi 1982,

I've seen your post multiple times online but I am not sure what you mean exactly by adding an entry. Could you clarify?

Thanks