Viewing 13 posts - 1 through 13 (of 13 total)
November 9, 2017 at 12:03 am
November 7, 2017 at 8:55 pm
November 7, 2017 at 2:16 pm
November 6, 2017 at 2:44 pm
November 6, 2017 at 9:30 am
November 6, 2017 at 9:19 am
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...
November 6, 2017 at 9:14 am
November 6, 2017 at 8:31 am
Did you solve your problem? I am faced with something similar and I am not finding solution(s).
Jerome
January 28, 2012 at 9:58 am
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...
August 10, 2010 at 5:53 pm
something like:
set @XMLParameters =
'<OrderGroup>
<Item TargetPrinterType="DIAMOND_X" GroupStatus="ACTIVE_cc" ReferenceNo="Joe" />
</OrderGroup>'
August 10, 2010 at 7:21 am
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...
August 10, 2010 at 5:59 am
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...
September 11, 2009 at 7:10 am
Viewing 13 posts - 1 through 13 (of 13 total)