Eugene Elutin (8/30/2012)
Replace the line executing the proc with following:
declare @dt datetime = CAST (FLOOR (CAST (CURRENT_TIMESTAMP as float )) as datetime)
exec dbo.CreerFile '00000000-0000-0000-0000-000000000000',@RefCourrier , @dt
Great!
What a co-incidence, I also declared the variable as @dt 🙂
Did not noticed that you posted the solution while I was investigating.
Cheers!
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter