Previous Thread:   No SQLCLR in sys.dm_os_hosts

11/30/2005 7:17:53 AM    Re: Do I misunderstand the funcionality of CLR?
From that description I haven't a clue as to what you want to do.  Can you  
  
explain a little differently please?  
  
--  
  
Andrew J. Kelly  SQL MVP  
  
"Tim Blume" <prodevelop@gmx.net> wrote in message  
  
news:uGA%23TjZ9FHA.2176@TK2MSFTNGP14.phx.gbl...



11/30/2005 9:53:15 AM    Re: Do I misunderstand the funcionality of CLR?
Hello Tim,  
  
I assume the you mean "the possibilities of the using the CLR hosted by SQL  
  
Server 2005" since that's the context for this newsgroup.  
  
You should be able to, but you'll probably want to use a stored procedure  
  
instead of a function. You can pass the first query into the code supporting  
  
..NET class's method which can execute that and get a dataSet if you like.  
  
You can then fire off that second procedure to get the results you want to  
  
the data from second source, up the dataset and start generate results from  
  
the updated dataset.  
  
I can post an example if you like.  
  
Thank you,  
  
Kent Tegels  
  
DevelopMentor  
  
http://staff.develop.com/ktegels/

11/30/2005 11:28:34 AM    Do I misunderstand the funcionality of CLR?
Hi guys,  
  
I don't know if I understand the possibilities of CLR.  
  
I thought, I could write a function that gets an SQL statement as parameter.  
  
In tn this function I want to execute the statement. Then I have to search  
  
for specific columns. When I find them I have to replace the values with  
  
values from another select.  
  
Can I do this with a stored procedure or user-defined function?  
  
Thanks in advance  
  
Tim