Click here to Skip to main content
15,896,153 members

Comments by Member 11820531 (Top 30 by date)

Member 11820531 31-Aug-16 14:48pm View    
Agreed, but not quite the answer I need :)
Member 11820531 31-Aug-16 9:39am View    
That works if the column is always the same length. I used one column and row as an example. But I need to split by ';' and '=' irrespective of length.
Member 11820531 3-Aug-16 17:46pm View    
EOMONTH is not recognized as a built in function on my DB. I'd have to change my database compatibility level. The solution for my problem was that I didn't make my query more selective in its creation. Thank you for your info! In hindsight, my question didn't fully encapsulate what I was trying to accomplish. So I didn't ask the correct question. Thanks again.
Member 11820531 3-Aug-16 15:09pm View    
That's more of a "after the fact approach". Ideally, I'd like to control re-seeding when my temp table is created and populated. I believe your solution is tied more towards a "permenent" table. Thanks for the info though!
Member 11820531 3-Aug-16 14:52pm View    
Deleted
Check this link out: http://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query. Good luck!