Viewing 15 posts - 2,701 through 2,715 (of 4,080 total)
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2009 at 12:54 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2009 at 10:15 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 29, 2009 at 3:46 pm
I notice the OP has been silent throughout this little discussion.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 29, 2009 at 3:37 pm
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),...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 29, 2009 at 8:14 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 28, 2009 at 8:20 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 27, 2009 at 2:31 pm
DTH2CRSRS
STBSD
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 25, 2009 at 2:18 pm
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
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 24, 2009 at 9:01 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 24, 2009 at 1:08 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 24, 2009 at 10:30 am
My wife phrases it "Keep us in the dark and feed us manure."
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 24, 2009 at 10:17 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 24, 2009 at 9:56 am
No, no, no. Don't post it whatever you do!!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 24, 2009 at 9:49 am
No need. I have already filed the solution you posted in my toolbox. Thanks 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 24, 2009 at 8:30 am
Viewing 15 posts - 2,701 through 2,715 (of 4,080 total)