what do you mean by output from the trigger. do you want to fill log table from a trigger?

Use the following query

select @cols = STUFF((SELECT ',' + QUOTENAME(Date)

FROM #distinctDate

Order by [year], MonthNumber

FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'),1,1,''

)

I have remove the distinct, if you want to distinct the record...

Refer to the following link http://technet.microsoft.com/en-us/library/ms179254.aspx

Mark Eckeard (12/5/2013)

---

Remove the imbedded SQL, put everything in a stored procedure, pass in all your values, wrap it in a transaction and call it a day. That would...

i hope i understand it right,

you need to join the table "tbl_acyear_lookup" with the query to

Select TargetID, Academic_Year_id, Course_Mode, UK_Enrol, Int_Enrol, Notes, Revision_Number

, ACY.academic_year

from

(SELECT ROW_NUMBER() OVER (partition...

you need to Convert/Cast this value in Time to be inserted properly.

whether its 2000 or 2008.

just to get an idea. that you are looking for Alternative of SSAS. Am i right ?

=Today() 'returns date only

=Now() 'returns date and current timestamp

Share a sample how you want to view the result set. The details u shared is not helping

i almost clicked on "YES". 😛

Thanks for sharing

Phil Parkin (12/4/2013)

---

Have...

okay ... have u tried to execute this package locally what error it give u

Add the Destination Server through "sp_addlinkedserver" For more detail refer to the following http://technet.microsoft.com/en-us/library/ms190479.aspx

Appreciated 😎

+1, i think you have many set the length of the output columns of...