tag:blogger.com,1999:blog-3000721125799986885.post1607244977321184419..comments2024-03-19T00:26:31.180-07:00Comments on SELECT Blog FROM Brad.Schulz CROSS APPLY SQL.Server(): Oh Yeah? Collate This!Brad Schulzhttp://www.blogger.com/profile/01852762873611487368noreply@blogger.comBlogger32125tag:blogger.com,1999:blog-3000721125799986885.post-91609671338702485832021-09-06T22:38:57.011-07:002021-09-06T22:38:57.011-07:00I have a mission that I'm quite recently chipp...I have a mission that I'm quite recently chipping away at, and I have been at the post for such data <a href="https://www.monteverdetourscr.com/trip/puerto-viejo-cahuita-snorkeling-costa-rica/" rel="nofollow">Costa Rica Snorkeling Tour</a><br />mastanahttps://www.blogger.com/profile/06734098526918539885noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-12229019039989226592021-07-16T10:53:12.965-07:002021-07-16T10:53:12.965-07:00Incredible tips and straightforward. This will be ...Incredible tips and straightforward. This will be exceptionally helpful for me when I get an opportunity to begin my blog. <a href="https://www.monteverdetourscr.com/trip/cataratas-en-cinchona-san-fernando/" rel="nofollow">San Fernando Waterfall Costa Rica</a><br />kurkhttps://www.blogger.com/profile/02833749040619068682noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-45281626624948586372021-07-12T13:33:39.187-07:002021-07-12T13:33:39.187-07:00Incredible tips and straightforward. This will be ...Incredible tips and straightforward. This will be exceptionally helpful for me when I get an opportunity to begin my blog. <a href="https://www.monteverdetourscr.com/trip/laguna-rio-cuarto-costa-rica/" rel="nofollow">Río Cuarto Volcanic Lagoon</a><br />kurkhttps://www.blogger.com/profile/02833749040619068682noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-11815781568033481962021-07-08T09:50:10.357-07:002021-07-08T09:50:10.357-07:00I no uncertainty esteeming each and every bit of i...I no uncertainty esteeming each and every bit of it. It is an amazing site and superior to anything normal give. I need to grateful. Marvelous work! Every one of you complete an unfathomable blog, and have some extraordinary substance. Keep doing stunning. <a href="https://matkaoffice.net/" rel="nofollow">satta</a><br />mastanahttps://www.blogger.com/profile/06734098526918539885noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-38111846778306430332021-07-04T23:09:52.788-07:002021-07-04T23:09:52.788-07:00I no uncertainty esteeming each and every bit of i...I no uncertainty esteeming each and every bit of it. It is an amazing site and superior to anything normal give. I need to grateful. Marvelous work! Every one of you complete an unfathomable blog, and have some extraordinary substance. Keep doing stunning. <a href="https://matkaoffice.net/" rel="nofollow">satta king</a><br />mastanahttps://www.blogger.com/profile/06734098526918539885noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-89423648265764741712021-07-02T22:16:35.733-07:002021-07-02T22:16:35.733-07:00An obligation of appreciation is all together for ...An obligation of appreciation is all together for the better than average blog. It was amazingly useful for me. I m playful I found this blog. Thankful to you for offering to us,I too reliably increase some new helpful learning from your post. <a href="https://matkaoffice.net/" rel="nofollow">matka</a><br />mastanahttps://www.blogger.com/profile/06734098526918539885noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-32083922158893719712021-06-15T09:01:20.324-07:002021-06-15T09:01:20.324-07:00Your online diaries propel more each else volume i...Your online diaries propel more each else volume is so captivating further serviceable It chooses me happen for pull back repeat. I will in a blaze grab your reinforce to stay instructed of any updates. <a href="https://askthetroll.wordpress.com/2021/06/13/moonboys/" rel="nofollow">Moonboys</a><br />mastanahttps://www.blogger.com/profile/06734098526918539885noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-19668305171682927362021-06-12T13:43:53.371-07:002021-06-12T13:43:53.371-07:00Your online diaries propel more each else volume i...Your online diaries propel more each else volume is so captivating further serviceable It chooses me happen for pull back repeat. I will in a blaze grab your reinforce to stay instructed of any updates. <a href="https://happytripsolutions.net/" rel="nofollow">buy magic mushrooms</a><br />mastanahttps://www.blogger.com/profile/06734098526918539885noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-41271710848448304112021-06-09T23:34:44.553-07:002021-06-09T23:34:44.553-07:00Your online diaries propel more each else volume i...Your online diaries propel more each else volume is so captivating further serviceable It chooses me happen for pull back repeat. I will in a blaze grab your reinforce to stay instructed of any updates. <a href="https://matkaoffice.net/" rel="nofollow">satta matka</a><br />mastanahttps://www.blogger.com/profile/06734098526918539885noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-88811582219914221092021-06-08T23:46:45.285-07:002021-06-08T23:46:45.285-07:00This post is genuinely incredible. I really like t...This post is genuinely incredible. I really like this post. It is remarkable among different posts that I ve read in a long time. You shake for this alright post. I genuinely welcome it! <a href="https://flackify.com/" rel="nofollow">new products</a><br />mastanahttps://www.blogger.com/profile/06734098526918539885noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-9488536798196617892021-06-07T02:31:24.133-07:002021-06-07T02:31:24.133-07:00I have been looking to discover a solace or powerf...I have been looking to discover a solace or powerful method to finish this procedure and I think this is the most reasonable approach to do it viably. <a href="https://www.monteverdetourscr.com/destinations/puerto-viejo-cahuita-tours-things-to-do/" rel="nofollow">Puerto Viejo Talamanca Zip Line Canopy</a><br />mastanahttps://www.blogger.com/profile/06734098526918539885noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-34920279401573450522021-04-20T12:32:49.542-07:002021-04-20T12:32:49.542-07:00This is extremely exceptionally decent post you sh...This is extremely exceptionally decent post you shared, I like the post, a debt of gratitude is in order for sharing.. <a href="https://tidyups.co.uk/end-of-tenancy-cleaning-gainsborough/" rel="nofollow">End Of Tenancy Cleaning Gainsborough</a><br />kurkhttps://www.blogger.com/profile/02833749040619068682noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-3143124216009969262021-03-22T05:40:19.388-07:002021-03-22T05:40:19.388-07:00Thought Media is a top WordPress Web Design compan...Thought Media is a top WordPress Web Design company providing web development businesses thrive on! Industry leading WordPress Experts and website designers that are skilled in SEO search engine optimization of your website to generate more leads and sales for your business. <a href="https://www.thoughtmedia.com/services/wordpress-web-design/" rel="nofollow">wordpress web design</a><br />kurkhttps://www.blogger.com/profile/02833749040619068682noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-79601323714134141022021-03-20T03:31:50.080-07:002021-03-20T03:31:50.080-07:00Thought Media is a top mobile application developm...Thought Media is a top mobile application development company. A team of the best mobile app designers and developers ready to grow your business fast. Work with leading mobile application developers today! <a href="https://www.thoughtmedia.com/services/mobile-application-development-ios-android-app/" rel="nofollow">mobile application development</a><br />kurkhttps://www.blogger.com/profile/02833749040619068682noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-77757702739671211312021-02-27T13:17:21.160-08:002021-02-27T13:17:21.160-08:00I have been looking to discover a solace or powerf...I have been looking to discover a solace or powerful method to finish this procedure and I think this is the most reasonable approach to do it viably. <a href="https://sportstoto365.net" rel="nofollow">먹튀검증</a><br />kurkhttps://www.blogger.com/profile/02833749040619068682noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-50944019489808288062020-10-15T10:15:42.234-07:002020-10-15T10:15:42.234-07:00The issue you we included above is certainly regar...The issue you we included above is certainly regard proficient for anyone to work out. the possibility of your article is substantial and It will realize a positive way. <a href="https://www.premierrange.co.uk/glass-splashback-in-bespoke-colours-made-to-measure" rel="nofollow">splashback colours</a><br />kurkhttps://www.blogger.com/profile/02833749040619068682noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-15317602768941304642020-08-07T07:36:42.779-07:002020-08-07T07:36:42.779-07:00The issue you we included above is certainly regar...The issue you we included above is certainly regard proficient for anyone to work out. the possibility of your article is substantial and It will realize a positive way. <a href="https://perfectdataentry.com/data-entry-services/" rel="nofollow">data entry professional</a><br />kurkhttps://www.blogger.com/profile/02833749040619068682noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-71496071769170361912019-10-08T03:04:19.543-07:002019-10-08T03:04:19.543-07:00I am genuinely thankful to the holder of this site...I am genuinely thankful to the holder of this site page who has shared this splendid section at this place <a href="https://www.55printing.com/news/24-hour-near-me-prints-and-overnight-services-online/" rel="nofollow">cheap 24 hours printing services near me</a><br />adilkhatrihttps://www.blogger.com/profile/16988121792297348012noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-1742357255537654172019-10-07T23:44:25.993-07:002019-10-07T23:44:25.993-07:00I require you to thank for your period of this rad...I require you to thank for your period of this radiant read!!! I definately value every last bit of it and I have you bookmarked to take a gander at new stuff of your blog an outright need read blog!!!! <a href="https://www.55printing.com/news/collate-printing-terminology-all-to-know-about-printed-collated/" rel="nofollow">collated printing meaning</a><br />adilkhatrihttps://www.blogger.com/profile/16988121792297348012noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-15738860162318941302015-02-09T12:24:26.741-08:002015-02-09T12:24:26.741-08:00@Anonymous:
Sure, you can change the collation of...@Anonymous:<br /><br />Sure, you can change the collation of the database... but are you going to blindly do that on a Production database? Or on TempDB?<br /><br />The point of this blog post was to get around having to do that... and the fact that TEMPDB can have a collation different from the USE database... I had a need to write generalized code to handle that collation difference without hard-coding a SPECIFIC collation.<br /><br />Brad Schulzhttps://www.blogger.com/profile/01852762873611487368noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-59969655534409815172015-02-09T05:31:59.819-08:002015-02-09T05:31:59.819-08:00ALTER DATABASE test2 -- put your database name her...ALTER DATABASE test2 -- put your database name here<br /> COLLATE Latin1_General_CS_AS -- replace with whatever collation you needAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-1478828076914880032009-07-28T10:12:33.292-07:002009-07-28T10:12:33.292-07:00Excellent Brad.
Enjoy the summer. :)Excellent Brad.<br /><br />Enjoy the summer. :)Brian Tkatchhttps://www.blogger.com/profile/11320700842381820277noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-54289490184040894432009-07-28T10:04:51.563-07:002009-07-28T10:04:51.563-07:00No I'm not bored... our family is on vacation ...No I'm not bored... our family is on vacation for 2 weeks... and yes, I would like to tackle that subject when I get back... you read my mind... that was something I was considering.Brad Schulzhttps://www.blogger.com/profile/01852762873611487368noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-28972636156349193002009-07-28T05:45:07.655-07:002009-07-28T05:45:07.655-07:00Brad, bored of posting already?
I have an idea. C...Brad, bored of posting already?<br /><br />I have an idea. CTEs can be UPDATEd, DELETEd, and so on. Confusing topic, i say. Want to try to tackle it?Brian Tkatchhttps://www.blogger.com/profile/11320700842381820277noreply@blogger.comtag:blogger.com,1999:blog-3000721125799986885.post-47054913371643441442009-07-14T05:06:56.699-07:002009-07-14T05:06:56.699-07:00@Brad
Just wanted to add.
The confusing part of ...@Brad<br /><br />Just wanted to add.<br /><br />The confusing part of the problem is that it is a two-level grouping, where the second group can include the first group. Thus, the top-to-bottom approach does not work.<br /><br />The obvious solution is to go bottom-to-top. That is, have a recursive CTE create a calculation-chain for each calculation, identifying each a level. So, if there is a level 2, level 1 relies on it, and so on. Then, process each calculation/level from the highest to lowest level.<br /><br />That ought to work, but, if the second level includes more than one calculation, there is no way to have a CTE reference a record other than the one prior to it. For example, if calculation 1 has a set that uses the results of calculation 2 and calculation 3, even if processed 3 then 2 then 1, calculation 1 can get to the results of calculation 2 because it is the prior record. But calculation 3 is out of bounds. The branches are not handled well.<br /><br />That is why i am using a temp TABLE.Brian Tkatchhttps://www.blogger.com/profile/11320700842381820277noreply@blogger.com