tag:blogger.com,1999:blog-3000721125799986885.post5002232645880752716..comments2024-03-28T04:05:20.028-07:00Comments on SELECT Blog FROM Brad.Schulz CROSS APPLY SQL.Server(): T-SQL Tuesday #005: ReportingBrad Schulzhttp://www.blogger.com/profile/01852762873611487368noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-3000721125799986885.post-3368942336456883352014-05-27T15:42:59.826-07:002014-05-27T15:42:59.826-07:00Hi James...
Thanks for the feedback.
It's be...Hi James...<br /><br />Thanks for the feedback.<br /><br />It's been a while since I've looked at this... but from what I recall, the data is all retrieved via a created-on-the-fly sequence number. <br /><br />What are you populating into the #TreeData temp table?<br /><br />If you want, you can email me directly at brad dot e dot schulz at gmail dot com.<br />Brad Schulzhttps://www.blogger.com/profile/01852762873611487368noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-61820312805111868402014-05-27T13:48:32.619-07:002014-05-27T13:48:32.619-07:00I have a question for you. First, thank you for po...I have a question for you. First, thank you for posting what you have done. I think it great that you do that.<br /><br />I found a problem and I was hoping you could help me out. I have a hierarchy that has a duplicate ID value. It is used in multiple relationships where the Parent + ID are a unique instance. When generating the data for the box, only the FIRST instance of the box data is retrieved based on the ID value. I would think it would be a retrieval on the parent/child ID's rather than just the ID. The result is that I get the same Data For Box values where the ID is the same. <br /><br />What would you recommend that I do to accommodate that situation with the tree?<br /><br />Thanks so much for your time!Anonymoushttps://www.blogger.com/profile/00035854685220818422noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-85116075955622397752012-06-13T14:54:34.727-07:002012-06-13T14:54:34.727-07:00@Wilfred:
The corruption may have occurred becaus...@Wilfred:<br /><br />The corruption may have occurred because of a bug in the procedure. The contents of the #TreeResult temp table were not being SELECTed in the correct order. I've since updated the code at my SkyDrive and in the blog post that comes after this one.<br /><br />--BradBrad Schulzhttps://www.blogger.com/profile/01852762873611487368noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-73190819805674393682010-12-01T08:11:07.592-08:002010-12-01T08:11:07.592-08:00@Wilfred:
Can you supply test data to dulicate th...@Wilfred:<br /><br />Can you supply test data to dulicate the problem? Email it to brad at stockciphering dot com.<br /><br />--BradBrad Schulzhttps://www.blogger.com/profile/01852762873611487368noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-55546792795861672962010-12-01T08:06:07.455-08:002010-12-01T08:06:07.455-08:00Brad,
Excellent script I use for creating diagrams...Brad,<br />Excellent script I use for creating diagrams for our ETL process. However, some tabels at the end of the tree got corrupted. (width > 220 chars, 6 levels deep). text width already 1024 chars. Any ideas?Wilfred van Dijkhttp://nl.linkedin.com/in/wilfredvandijknoreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-22793017855488630822010-04-15T06:02:00.954-07:002010-04-15T06:02:00.954-07:00@Aaron: You're right... I changed it to "...@Aaron: You're right... I changed it to "temp table". Thanks. I figured airlines were an easy target that everyone could relate to... thank God I don't fly that much. 8^)Brad Schulzhttps://www.blogger.com/profile/01852762873611487368noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-534521756907410272010-04-15T04:54:48.863-07:002010-04-15T04:54:48.863-07:00Brad, should that be a 'temp table' not a ...Brad, should that be a 'temp table' not a "temporary file"? <br /><br />Love the bit about the airlines! :-)Aaron Nelsonhttp://sqlvariant.com/wordpress/noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-76111111735991110362010-04-13T12:11:24.526-07:002010-04-13T12:11:24.526-07:00I loved putting that in there (the "rehearsed...I loved putting that in there (the "rehearsed earlier" thing)... it's one of the reasons that local news drives me up the wall.<br /><br />Back to you, Michael. 8^)Brad Schulzhttps://www.blogger.com/profile/01852762873611487368noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-5398935369159052002010-04-13T12:05:33.798-07:002010-04-13T12:05:33.798-07:00My favorite bits:
"as exciting as watching a ...My favorite bits:<br />"as exciting as watching a CURSOR routine finish up."<br />and<br />"... something we rehearsed earlier"Michael J. Swarthttps://www.blogger.com/profile/05408240220683534698noreply@blogger.com