Its because, semicolon missing at the end of return statement.

Use the simplified one below :

CREATE FUNCTION dbo.ExecuteStringAsQuery (@empID as nvarchar(500))

RETURNS Varchar(8000)

AS

BEGIN

/* Build Transact-SQL String with parameter value */

return(select JoinDateQuery from...

Sort the records from a table using ORDER BY in OLE DB Source component before sending rows to excel spreadsheet

e.g., SELECT cols......

FROM ...

Its because of ISNULL() function. ISNULL(exp1, expr2) always returns expr1 if expr1 is not null. Else expr2 typecasted to expr1. As column 'A' is of varchar with no length.. so...

Whoever posts question in QoD column, always makes sure your question is correct with zero syntax and semantic errors and also make sure when you ignore for syntax/semantic error atleast...

Browse thru http://technet.microsoft.com/hi-in/library/cc966529(en-us).aspx to clearly understand on how to tune ssis packages.

can be re-written like this :

WITH CTE AS

(

SELECT Emp_Name, Company, Join_Date, Resigned_Date, ROW_NUMBER() OVER (order BY Emp_Name, Company, Join_Date, Resigned_Date) AS ROWNUM

from #Emp_Details

)

DELETE FROM CTE

WHERE ROWNUM NOT IN (SELECT MAX(ROWNUM)...

i strongly disagree with you.. as the rollback/commit statments does not work for alias unless preceeded by TRAN or TRANSACTION so the syntax error.... i chose answer "Error : incorrect...