I just got caught up on the last couple of days of The Thread 🙂

Welcome back and nice going, Roy!

For a more definitive answer (and a coded, tested solution), please give us the margin calculation formula and set up your sample data as shown in this best practices[/url] article.

Thanks.

A slightly different version of the XML, if you want to get rid of that nagging semicolon at the end. Put the semicolons in front and then use STUFF...

Cursors are rarely needed to solve problems in SQL.

I have used a cursor in a loop to read a table of linked server names and build identical queries to extract...

I notice the OP has been silent throughout this little discussion.

Okay... I'm guessing you are new to SQL or used to a product other than Microsoft SQL, yes?

INT doesn't have a length parameter. It's not INT(9),...

Another tally table solution, but this one doesn't require the creation of a separate user defined function. CTEs are used to parse the "ARRAY" into a table which...

Hey Paul 🙂

Jeff already pointed out that it's not strictly correct, but I stand by my statement anyway. Just like string parsing or concatenation, if someone...

DTH2CRSRS

STBSD

Couldn't find anything in BOL, but here's an article discussing the behavior.

http://www.sqlservercentral.com/articles/Linked+Servers/62246/%5B/url%5D

Hey Jan,

Robur was like Captain Nemo, except that he had a giant airship instead of a submarine. I remember there being another story, possibly a sequel...

Jack, one of my best friends from high school came to visit and we got to talking books. He mentioned the Mad Scientists Club was one of his...

My wife phrases it "Keep us in the dark and feed us manure."

On King: I loved the last four books of the Dark Tower, even the "optional" last chapter. I also thoroughly enjoyed Duma Key, although it's...

No, no, no. Don't post it whatever you do!!