Specify an alias for Table1 in your FROM clause and use that in your SELECT list.

John

Yes, but it's certainly not pretty and probably not efficient on large data sets.

WITH Numbered AS (

SELECT

CAST(id AS char(2)) + ' ' + name AS Concatenated

,Dept

,ROW_NUMBER() OVER (PARTITION BY Dept...

Abhas

That's a task usually best done in the presentation layer. Reporting Services would be good for something like that. If you must do it in T-SQL, please will...

Does your package involve a SQL Server, and if so, can you send messages from that server with sp_send_dbmail? I always find that easier than using the Send Mail...

To know what the previous row is, you need a column (or combination of columns) by which to sort. A table has no inherent order, so which column(s) will...

OK, we're getting somewhere. Not quite all bold yet, though.

Please post the exact error message. Is the Execute SQL task the only task in your ForEach Loop container? Is...

I'm out of my depth now, I'm afraid. I have the immense good fortune very rarely to have worked with Access.

John

You can use sp_send_dbmail to send the results of a query by e-mail.

John

I don't think that's to do with the network. The MSOLAP provider is for Analysis Services, not Access.

John

Does your remote SQL Server capture failed logins in its errorlog? If so, do you see anything in there after you attempt to connect? Can you connect to...

A different interpretation of the requirement:

SELECT

Deptno

,locationid

,pid

,sid

,LAST_VALUE(value) OVER (PARTITION BY locationid, pid, sid ORDER BY Empid RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) * 1.0

/ FIRST_VALUE(value) OVER (PARTITION BY locationid, pid,...

Thanks. You've answered the question in bold - please will you now answer the others?

Please post the exact error message. Is the Execute SQL task the only task in...

Please post the exact error message. Is the Execute SQL task the only task in your ForEach Loop container? Is the table it updates on a central server,...

OK, you've shown what results you need, but you haven't said in what way what you currently have isn't working. I would guess that your col1 looks more like...

I'm not 100% sure I understand your requirement, but does this point you in the right direction?

REPLACE(@EmailAddress, CHAR(146), '''')

John