-- select table to merge into merge into dbo.post p -- select table to merge from using (select tag from template_tag) tt -- select how they map together on p.tag = tt.tag and p.post_id = @post_id -- specify WHEN to do when not matched then -- specify WHAT to do insert (tag, post_id) va... [More]

This post is part of a series and the source code can be found at http://github.com/MikaelHenrixon/ConqueringNServiceBus Conquering NServiceBus part 1 – Getting Started Conquering NServiceBus part 2 – Initial configuration Conquering NServiceBus part 3 – A simple Saga Conquering NSer... [More]

select count(*), cast(convert(varchar,a.CreatedDate,101) as smalldatetime) as VisitDate from ActivityLogs.dbo.DetectionLogs a where a.Column = 'value' group by cast(convert(varchar,a.CreatedDate,101) as smalldatetime) order by cast(convert(varchar,a.CreatedDate,101) as smalldatet... [More]

This is due to the edmx file being generated or updated from a SQL 2008 instance and run against a SQL 2005 instance. I tried about every trick I could think of before reading about it here. Basically all you need to do is to open the EDMX file with XML Editor and change ProviderManifestToken=”2008”... [More]

Hi, today I had to do an extremely boring task! I had to create a table for holding the worlds countries. Not only had I to create the stupid table I had to fill it with all the worlds countries. Thanks to the guys over at http://snippets.dzone.com/. They had a post with all the countries of the wor... [More]

On first impression it looks really nice. The installation gui has really improved to something that is easy to understand and follow. Adding features is not supported through the gui yet. I there for recommend thorough planning of your Sql Server 2008 installation. I believe you do not want to spen... [More]