Target framework is a project property and not solution property. It's possible that a solution has different projects with different target framework. If you have a working project with specific framework and you do not mean to change/extend functionality - do not change target framework... I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

No I mean there's statistically a number of errors per square inch on the wafer. The larger the chip, the larger the chance there's something wrong with it. So it's harder getting a good yield. Wout

Hi, It's clear that you have met some trouble in this problem, why not try esProc to solve it? esProc is a tool for mass data computation, especially fit for the complex data computation like yours. Check below for more details: A Query Language Over-perform SQL[^]

Nice post - good compendium of what used to be cutting edge gaming! Check this - back in the day (circa 1980) my best friend's dad worked at Motorola, makers of the ROMs for all of the 2600 games. So he hooked his son up with a circuit board with an interchangeable IC chip-socket that would plug into the normal 2600 cartridge slot. My friend would get all the newest games in chip form almost weekly, even alpha versions sometimes, in a plastic case covered on the inside with anti-static foam. I remember that a couple of the first games we got to test were Adventure and Dragster... Good times. :thumbsup: "... having only that moment finished a vigorous game of Wiff-Waff and eaten a tartiflet." - Henry Minute  "...who gives a tinker's cuss?" - Dalek Dave  "Let's face it, after Monday and Tuesday, even the calendar says WTF!" - gavindon   It's plain that they do not yet know what true fear really is. - JSOP 2011

Try 'c' + c.ID = co.CID and not c.ID = 'c' + co.CID If C.Id is of integer type then cast it 'c' + Cast(c.ID as varchar(20))= co.CID Try this Declare @City table (Id int,Name Varchar(20)) Insert Into @City Select 123,'City1' Union All Select 1,'City2' Union ALl Select 124,'City3' Union ALl Select 5,'City4' Declare @Country table (Id int,CID Varchar(10),Name Varchar(20)) Insert Into @Country Select 1,'c123','Country 1' Union All Select 1,'1','Country 1' Union All Select 1,'c5','Country 1' SELECT c.Name, co.Name FROM @City C JOIN @Country co ON 'c' + Cast(c.ID as varchar(20))= co.CID Hope this helps Niladri Biswas