IMHO you should look at the ANSI_PADDING settings:

Quote:

'ANSI_PADDING

When set to ON, trailing blanks in character values inserted into varchar columns and trailing zeros in binary values inserted into varbinary columns...

Try this:

SELECT A.value1,A.value2,B.value1,B.value2 FROM

sree A

CROSS JOIN

sree B

WHERE A.[date] = '2003-12-12' AND B.[date] = '2003-12-13'

'date' is a reserved T-SQL keyword hence it is good practice to use []

Using 'datetime'...

What do you mean exactly?

Pass it to your stored procedure as a VARCHAR() and use it in your query with the EXEC sql command.

Ex for dynamic sql:

DECLARE @MyColumn...

Why not do an object copy with DTS?

Copy the object into a new table (with the indexes) then move all the data from your old table into the new one...