Now I have a great excuse to use 2012. Thanks for all your help today. :satisfied:

I created a test env and , as you warned me, once I update the column I get the following message for a badly-formed xml fragment:

Msg 9412, Level 16, State...

Excellent, thanks very much for this.

We are looking at 301,066,784 KB of data so I am expecting this to double. I’ll also look at creating a Pre-prod...

CREATE TABLE [dbo].[tDocSummary](

[DocSummaryKey] [dbo].[Id_dom] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[DocKey] [dbo].[Id_dom] NULL,

[IdentityNbr] [dbo].[Id_dom] NOT NULL,

[DateExpiry] [dbo].[Date_dom] NULL,

[SingleMultiple] [dbo].[Indicator_dom] NULL,

[MonthsAllowed] [dbo].[Count_dom] NULL,

[ValidTo] [dbo].[DateTime_dom] NULL,

[Type] [dbo].[Type_dom] NULL,

[Key] [dbo].[Id_dom] NULL,

[ApplNbr] [dbo].[Id_dom] NULL,

[Ind] [dbo].[Indicator_dom]...

Thanks, using a Variable makes sense.

The result set I am getting is,

CLIENTID DocSummaryKey

101 10000

101 ...

Thanks for responding so quick.:-)

I need the highest DocSummaryKey per ClientId.

Thanks, thats much better than using a view. 🙂

Hi,

I guess this would be better if I didnt use a view, but is it possible?

Cheers, Phil

Done it 🙂 . However, please feel free to let me know if this syntax is considered bad practise in any way.

IF OBJECT_ID('vwAppCounter') IS NOT NULL

DROP VIEW vwAppCounter

GO

CREATE VIEW vwAppCounter

AS

SELECT...

Hi,

Thanks Steve.

I've not explained this well. 🙂

Using the following returns what I want , however;

SELECT (SELECT distinct COUNT(a.ApplNbr)as "Applications" FROM tApplication a ) as "Applications",(

SELECT distinct COUNT(c.IdentityNbr)...

Thanks, but I am still getting issues. Can you break it down further? Sorry, I am a newby.

I am using the following;

SELECT (SELECT distinct COUNT(a.ApplNbr)as "Applications" FROM tApplication a )...

phil.layzell (7/26/2010)

---

I am a 43 year old .NET/VB Developer who wants a new challenge and would like to move over to a SQL DBA role. This is a role I...

Hi, many thanks for your help with this. I ended up using the following tho;

select PersonID, max(Namefirst) as NameFirst,

max(Namemiddle) as NameMiddle,

max(Namepreferred) as NamePreferred,

max(NameLast) as NameLast

from

(

SELECT

N.PersonID,

(SELECT Name WHERE nameTypeID = 7780...