Not sure what you a really asking for, need better understanding of what you are trying to do.

If [iRecipientId] is not IDENTITY then you know the value anyway

DTS

it will allow you to transform the data during load

Correct

The syntax is incorrect, but seems to work

The correct syntax should be

EXEC sp_executesql @sql, N'@res varchar(255) OUTPUT', @result OUTPUT

Corresponding names in...

So, next question...

I presume this is the converse of the original problem.

You could use ten IF's or if...

SET @AddCounter = 1

WHILE @AddCounter < 11

BEGIN

SET @TempVal = UPPER(RTRIM(LTRIM(

CASE

WHEN @AddCounter = 1 THEN @Address1

WHEN @AddCounter = 2 THEN @Address2

WHEN @AddCounter = 3...

Use DATALENGTH, eg

SELECT MAX(DATALENGTH([col])) FROM

To find the longest length of the column

SELECT [col] FROM WHERE DATALENGTH([col]) > n

To list the columns longer than the maximum required

(substitute...

is there any way to avoid repeating the query in the child query

Only by using a temp table,...

and as I see, David posted his solution even before I completed writing my post

WOW is this a...

at a guess (would be helpful for test data and expected results )

SELECT c.CustNo,

c.CustomerName,

p.ProductDesc,

p.Productcode,

p.SourceID,

p.FRB,

p.MktSegmentID,

SUM(idp.Quantity) AS [Quantity],...

DECLARE @upd int

CREATE TABLE #temp (Empno int, Empname varchar(20), Empnamesupermgrname varchar(20), supermgrid int)

INSERT INTO #temp (Empno, Empname, Empnamesupermgrname, supermgrid)

SELECT e.Empno, e.Empname, m.Empname AS [Empnamesupermgrname], m.Empno AS [supermgrid]...

Personally I do

SELECT adi AS [Adlar]

it removes all problems and abiguity

Look up sp_help_fulltext_columns in BOL (Books Online)

1. Whilst your 3 columns correlate the data does not, what is DHBName?

2. Your sample output is not possible from the sample input you provided

Your query :-

SELECT ISNULL(a.DHB_service, b.DHB_service) AS...

You're missing a comma and the end of the SUM line

...

SUM(LOII.LII_MARKS) * 1.0 / COUNT(*) AS "Av No of correct answers",

CASE IA.IAT_DATA AS "Group"

...