I have a variable like @OrderTime varchar(8) now this variable I am using to add a timestamp to a file. Like SET @FileName = 'xyz' + @OrderTime.+ '.xml'
My file should look like this xyz20101229130446470.xml . How Can I do that? I want everything except the millisecond part so 470 will be removed and it should be xyz20101229130446.xml