for a while i have wanted to try to use MSH from SQL server, and last
night i finally decided to give it ago..

here are some examples of msh that is running in my code:

select dbo.sqlmsh('$b = 0 ; 1..10 | foreach {$b = $b * $_ }; $b ')

select CAST ( dbo.sqlmsh('[xml]"hello"') AS XML)

select * from dbo.multimshhash('$a = @{this = 5;that= 10; 2 =
[DateTime]::Now; filterthisout = "dont see this"}; $a')
where name not like 'filter%'

select * from dbo.multimsh('9,8,3,4,4,3,3,2,2,5 | sort | gu')
where mshitem > 5

to read more about it go to my blog entry.
http://www.karlprosser.com/coder/?p=10

i'm keen to get feedback and see if others are interested in helping
turn this proof of concept into something solid.

------------------
Karl /GODCENTRIC
Visionary Media
the creative submitted to the divine.
Husband of my amazing wife Aleshia
Klumsy@xtra.co.nz

--D-SIPL

------------------
"One World. One Web. One Program." -Microsoft promotional advertisement
"Ein Volk, ein Reich, ein Fuhrer!" -Adolf Hitler

I also walked through this ohh so easy to follow tutorial:
http://arstechnica.com/guides/other/msh.ars
..very easy to follow

now I just need to decide what I'm going to use it for..

i've just made another host for MSH today.. i'm making a new post here, and on my blog for it.

------------------
Karl /GODCENTRIC
Visionary Media
the creative submitted to the divine.
Husband of my amazing wife Aleshia
Klumsy@xtra.co.nz