Hi,

I could not find a solution to define at the sp level but I have found a way to make it more generic

using database_default

So if there are collation issues because of differences in the tempdb and the database in which you are running the query use database_default for more generic solution

CREATE TABLE #BusinessDate

(

RequestID VARCHAR(10) COLLATE database_default,

FileName VARCHAR(100) COLLATE database_default,

FileTypeID INT,

BusinessDate VARCHAR(8) COLLATE database_default

)

Aparna