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"

...

...if you were to write this as a normal stored procedure what would it look like...

You cannot, that...