Summary
Martin has been involved with computers in one way or another for as long as he can remember,
but started professionally in 2000. After university Martin started out as an ASP 3.0 developer
for a year working with Access and VBScript, but he breathed a sigh of relief when the .NET Framework
was released in 2001 and has been working with .NET and VB ever since. He has been certified in Team
Foundation Server since early 2007 and thinks it is the best thing since sliced bred. You can download
Martin Hinshelwood's CV to find out more.
.NET Evangelist, Architect, Application Developer. Particularly interested in Service Orientated
Architectures, client/server and relational database design using SQL Server, and .NET. Currently
working in the services industry, but with a background in community networking sites. Currently
specialising in MOSS 2007 and Sharepoint 3.0 as well as Team Foundation Server implementation,
deployment and development.
Specialties
- In-depth knowledge of .NET 3.5 (VB9,LINQ), .NET 3.0 (WCF), .NET 2.0
- Superb understanding of Service Orientated Architecture and Software Factories.
- Solid working knowledge of all Win32 platforms.
- Experience in client-server TCP messaging system.
- Excellent understanding of e-Mentoring and other relationship management systems.
- Solid knowlage of Microsoft Office Sharepoint Server 2007 and Windows Sharepoint Services 3.0
and Visual Studio 2005 Team Foundation Server
Found GDR Bug: At least I think it is.
Published on: Thursday, September 04, 2008 [Permalink]
This is not isolated to GDR, but seams to exist in Data Dude as well. If you create the following SQL:
1: CREATE VIEW [dbo].[v_SomeView] AS
2: SELECT [BH].[Col1],
3: [BH].[Col2],
4: [BH].[Col3],
5: [BH].[Col4],
6: [BH].[Col5],
7: CASE WHEN [BHPP].[OtherCol1] IS NULL THEN -1 ELSE 1 END As [Col6],
8: CASE WHEN [BHPP].[OtherCol1] IS NULL THEN 'Not Applicable' ELSE 'PowerPack' END As [Col7],
9: CASE WHEN [BHPP].[OtherCol1] IS NULL THEN [BH].[Col5] ELSE [BHPP].[OtherCol2] END As [Col8]
10: FROM [dbo].[Table1] as [BH]
11: LEFT JOIN (SELECT [OtherCol1], [OtherCol2], [OtherCol3]
12: FROM [$(CMD)].[dbo].[Table2]
13: WHERE [OtherCol1] <> -1) as [BHPP]
14: ON [BH].[Col2] = [BHPP].[Col2]
And add it to your Database project, but using proper table names :) You will get the following error for every use of [BHPP]:
Error 13 SR0029 : Microsoft.Validation : View: [dbo].[v_SomeView] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects:....
This is a show stopper for us as we can't (without good cause) be creating more views just to do a derived table...
I have submitted a Bug, so vote as you like, but please vote...
Bug: GDR - derived tables
