TSQL: Concatenate Column from Multiple Rows into String

יום שלישי, ינואר 24, 2012

Ok , So I had a problem related to concatenation of a single Column into one ( same ) column when using GROUP BY . The Problem came from a Reporting Services perspective and there might be other solutions ( like coding in VB.NET in the report ) I have found a very nice samples : Option 1: use Northwind declare @CategoryList varchar(1000) set @CategoryList ='' select @CategoryList = @CategoryList + ' , ' +...

SharePoint 2010 : The following computer running SharePoint does not contain the required Infopath form template

יום שני, ינואר 23, 2012

What can I say … except "elementary my dear Watson" ;) Ok , the problem is that you didn’t activate a feature in the site you’re working with :P go to : Site Actions > Site Settings > Manage Site Features > Team Collaboration Lists. The problem : The solution: ( Personal Note: I know it has been a while , but once in a while doesn’t hurt ;)  )

T-SQL Israeli CardID Checker / ת.ז. ישראלית

יום שלישי, אוגוסט 24, 2010

T-SQL Israeli CardID Checker / ת.ז. ישראלית Once in a while I come across code that I didn’t fins in the internet … mainly because it’s for local use ;) This is one of these times :) This code is the T-SQL version of the algorithm  that checks the given Israeli CardID , and adds a leading Zero , if need one ( like in my personal case ) , and calculates the “Check Number” ( SIFRAT BIKORET ) , if it’s missing. I needed this for an SSIS Package that loaded monthly information...
69 תגובות

BizTalk 2010 Beta 1 & AppFabric RC

יום ראשון, מאי 23, 2010

BizTalk 2010 Beta 1 & AppFabric RC On the 20th , BizTalk 2010 Beta 1 was released ,  a day after the AppFabric RC. We all know ( at least a bit ) about BizTalk , but regardless we shouldn’t disregard the Windows Server AppFabric which is a set of integrated technologies that make it easier to build, scale and manage Web and composite applications that run on IIS. Windows Server AppFabric targets applications built using ASP.NET, Windows Communication Foundation (WCF), and Windows Workflow Foundation (WF). It provides out-of-the-box capabilities...

Express 2010 RTM Download summary

יום חמישי, אפריל 29, 2010

Express 2010 RTM Download summary Any one who really knows me , knows that my 2nd passion is the Express toolset :) Now, that Visual Studio 2010 has RTM-ed a few days (weeks) a go I have decided to build a small collection of relevant URLs : from http://www.microsoft.com/express/Downloads/ Visual Basic 2010 Express Visual C# 2010 Express Visual C++ 2010 Express Visual Web Developer 2010 Express ( Part of the WebPI Toolkit ) All - Offline Install ISO image file And the SqlServer Express 2008 R2 – with the new 10GB support :) Microsoft SQL Server 2008 R2 RTM - Express with Advanced Services Microsoft SQL Server 2008 R2 RTM...

"How Do I" Videos SharePoint Development with Visual Studio 2010

"How Do I" Videos SharePoint Development with Visual Studio 2010 This reminds me of an old post I did .. Moss 2007 and Designer Webcast How-To is growing , and a few more like SharePoint Developer Training and Webcast Series: SharePoint for Developers and … but that’s ancient history ,and it’s Moss2007. Now, we start to talk about SharePoint 2010 ! So, here’s a small and growing list : #1 | How Do I: Create Visual Web Parts for SharePoint 2010 in Visual Studio 2010? #2 | How Do I:...

Office 2010 RTM !

יום ראשון, אפריל 18, 2010

Office 2010 RTM ! Long time waited Office 2010 has finally RTM-ed. I know that some of use played around with the Office 2010 on the developer's side .. and some of use on the user/client side . So this news is what most of us have been waiting for a long time :) For me , this news come from the Microsoft Office 2010 Engineering blog - Office 2010 Reaches RTM! Specification .. knowing you , I guess you know already – the main thing is that now it’s RTM , so more reliable...

SharePoint 2010 is just around the corner

יום שני, פברואר 15, 2010

SharePoint 2010 training material released in January: 2010 Information Worker Demonstration Virtual Machine (Beta) – fully functional virtual machines to demo Office 2010 and SharePoint 2010. Free E-learning: What’s new in Microsoft SharePoint 2010 for Developers. Free E-learning: What’s new in Microsoft SharePoint 2010 for IT Pros Learning snack for developers – Developing solutions with SharePoint 2010 SharePoint 2010 Developer material on Channel 9 SharePoint 2010 – Getting started with development on SharePoint 2010 – HOL in C# and...

Information Worker 2010 (beta) Demo VM

Information Worker 2010 (beta) Demo VM The download link is here Overview This download contains a two Virtual Machine set for evaluating and demonstrating Office 2010 and SharePoint 2010. Virtual machine “a” contains the following pre-configured software: Windows Server 2008 SP2 Standard Edition x64, running as an Active Directory Domain Controller for the “CONTOSO.COM” domain with DNS and WINS Microsoft SQL Server 2008 SP1 + CU2 Enterprise Edition with Analysis, Notification, and Reporting Services Microsoft Office Communication Server 2007 R2 ...

Office 2010 & SharePoint 2010 Beta Release

יום חמישי, נובמבר 19, 2009

Office 2010 & SharePoint 2010 Beta Release Well, now it available for you to download :) All you want to start learning about the Office 2010 is here: Office 2010 beta SharePoint Server 2010 beta – take a look at Software and hardware requirements before starting your installation SharePoint Foundation 2010 Microsoft Office Web Apps while connect users got this version on the 16th, just a few days a go ;)