I have a stored procedure from sql server database that has a start date and end date parameters as nvarchar data types, but now if I run this in crystal reports will there be a problem with the date a format? The Rreason why I used nvarchar for the date is because that is only way it works in the stored procedure  because it is used in the

the stored proc actually worked in crystal, but now i need to create another identical stored proc using another database and call it sp_b. So what would be the syntax to call stored sp_a from database A within stored sp_b from database B? the sp_a has input parameters @tablename, @start date and @enddate. This is not a sql forum but does anybody have an idea of how to do that? Your help is greatly appreciated