Hi,

Thanks for updating your table up to 2022.

I tried to find a Microsoft Road Map to see where .Net 6 ,7,8 fit in the SQLCLR picture.

Most of my CLR use...

Thanks Roby.

The proposed CASE strategy was NOT on my radar when I first tried to harvest API from Web sites in 2007. At the time...

Did you solve your problem? I am faced with something similar and I am not finding solution(s).

Jerome

I quite agree that XML is no panacea(?). In my shop, we deal with what we call moving specs and XML have proven very robust when adding items that were...

something like:

set @XMLParameters =

'<OrderGroup>

<Item TargetPrinterType="DIAMOND_X" GroupStatus="ACTIVE_cc" ReferenceNo="Joe" />

</OrderGroup>'

I have been using an XML string to achieve the same results. Not sure that it is faster, but it is quite flexible as:

EXEC sp_xml_preparedocument @idoc OUTPUT, @XMLParameters

insert into #T

select...

An other way to get column names is to use a View. In the SQL Management Studio, select View, New, Select the table(s) you want and select all columns. The...