I'd like to take values between a date range and enter into a table
I have a date range @startdate and @enddate
i'd like my user to enter the date range and then for the system to take the date range entered and insert them into a table, however, my table only allows one date value i.e Dte
how do I take my @startdate and @enddate and make into @Dte?
Is that possible?
INSERT INTO tblA (dte,intID,RoomType,Qty,Price) VALUES (@dte,@ResortID,@RoomType,@Qty,@Price)
Any sort of advise or links would be appreciated