question

sokoban avatar image
sokoban asked

MsSQL date calculation problem

I have 2 tables in MsSQL. Table B contains the dates, the currency type and the current rate on that date. Table A contains transactions and transaction dates and times. I want to find the rate that corresponds to the date of the day before in table B for transactions before 15 o'clock in table A in Ms SQL QUERY. How can I do it ?

mssql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.