>>I need to return back SCOPE_IDENTITY() as well as NewID(). Or at least NewID() that I'm putting there as ID of the order may not be that important, though I may want to display it.
>>
>>I can not use SP as it's SQL Server CE.
>>
>>Appreciate your ideas.
>
>
>You cannot batch calls to sqlce. the sample code shows how to do this..

John,

Are you sure this would not work
INSERT INTO [Orders] ([OrderPk], [OrderDate]) VALUES (@NewOrder, GetDate()); return Scope_Identity()

and I need to use the exact idea from your article?

Thanks again.