I Installed MOSS (Microsoft Office Sharepoint Server) virtual hard drive which can be found here http://www.microsoft.com/downloads/details.aspx?FamilyID=67f93dcb-ada8-4db5-a47b-df17e14b2c74&DisplayLang=en To use virtual hard disk I installed Microsoft Virtual Server. I was trying to access the Virtual hard disk using virtual server and was using the user name “Administrator” with Password “pass@word1″ which is provided by Microsoft documentation. I [...]
I wanted to concatinate multiple address fields as a single field separated by comma. Here is the solution which is doing job for me. 8000 is the Max length of varchar data type in sql server. Using COALESCE() function saves lot of IF or CASE decision logics. This function Returns the first nonnull expression among [...]
