Glad to help and welcome to SQL Server Central 😉

Not really.... it's just about getting SQL Server and the OS to work without one starving the other out of memory.

What numbers you choose depend on how much RAM you...

select b.val

from @tbl1 as a

inner join @tbl2 as b

on a.id = b.id

group by val

having COUNT(val) = (select COUNT(id) from @tbl1)

p.panneerselvam (2/12/2013)

---

Execution plan

...

Heh... you think this is bad, take a look at one of my databases below LOLOLOLOL 🙂

Is there a clustered index on the table? If so, which columns does it reference?

oops just saw the last line of your post. Why no set your ID column as...

Because I can only perform FULL backups to the NAS from one sql server per day and the offsite backup collection is on Thursday morning, I really need a fresh...

Thanks 🙂 I didn't know about WITH COPY_ONLY

As requested here is the complete sproc:

CREATE PROCEDURE [dbo].[usp_GenerateKeys]

@SourceTable VARCHAR(50)

AS

BEGIN

SET NOCOUNT ON

DECLARE @sql NVARCHAR(MAX)

DECLARE @MSG NVARCHAR(500)

-- Get source table unique reference

IF EXISTS (SELECT 1 FROM sys.tables WHERE name = 'FieldMappings')

DROP...

SSIS has PIVOT transformation component for this kind of thing.

Alternatively you can use a SQL task component and use the T-SQL PIVOT command to transpose your table.

replace EXEC with either SELECT or PRINT, e.g. PRINT( @sql)

Fair enough. I think I'm trying to be too clever when I should be concentrating on getting the rest of the project done first! This part works but everytime I...

Yes that's right, where I define the variables I have...

Not sure if I explained this very well so I will try again!

I have a table with the following columns:

TABLE NAME = Phonetic_Keys

RecordID, PhoneticSurname, PhoneticForename, PhoneticStreet, PostCode, Premise

This table will...

Thanks for your input Sean. I really appreciate it.

As mentioned, this is part one part of a record linkage exercise I'm working on. The way it works is like this:

I...