Found the issue and fixed it.

It was a corrupt ResourceDB database.  It's not one I had a backup of.  I had another server at the same build and...

You could have also included the over clause in those count examples, e.g.

SELECT DISTINCT Column1,COUNT(*) OVER (PARTITION BY Column1 ORDER BY Column1) FROM #TmpCounts;
SELECT DISTINCT Column1,COUNT(*) OVER...

the answer is only correct when using SqlServer 2012 and above. Previous versions prompt an error.

Thank you for the quick response. The example you provided works great. So I've tweaked it to update my test table which has about 2.5million rows. It's...

Failover, Restore and Repair

I think one has been forgotten, and it's one that's not to be taken likely because you have to know your data. This method is Reconstruction.

Sometimes,...

I found some info on the Latin Small Ligature œ in books on-line and it appears to be conversion issue with sql colations and code pages. Seeing as I...

I think Dinosaur comics summed up failure best with

Failure: it's just success rounded down

which is a healthy way to look at it.

I had exactly the same problem with my network card on my home pc last month. It had somehow been configured to auto negotiate at 100mbps. The internet...

how about...

DECLARE @string VARCHAR(20)

SELECT @string = 'ABC DEFGH'

select @string = replace(@string,' ','')

select @string = substring ( @string, 1,(len(@string)-3)) + ' ' +

substring ( @string, (len(@string)-2),3 )

select @string

Document - Assemblage23

Circle of the Tyrants - Celtic Frost

White Room - Cream

Looking for Strange - KMFDM

Stalkers - Mind.In.A.Box.

Be The Hero - O.S.I.

Travel - The Gathering

Fearless - VNV Nation

One Day Remains...

you could try this, it's a bit crude but works...

declare @string varchar(50)

SET @string = 'ABCDEFGHIJ123'

select reverse ( substring ( reverse ( @string ) , 1 , 3 ) )

Saying a project is a success just because you did everything that was asked of you is arrogant. Saying that your work/ development & implentation of the specification on...

Hi,

I'm sure there's a better way of doing this using joins but this is all I can come up with for now:

set nocount on

create table #test1 (accno varchar(50))

create table #test2...

You could record a macro in excel to load up all of the files into worksheets and then have it save the completed spready. That way, you can run...

missed that one Mark, quite right too.