Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pgrandjean
Starting Member
5 Posts |
 Posted - 2009-06-22 : 08:09:22
|
| Hi.In a view i would like to select all transaction before a date:e.g.:Select * from ledgertrans where transdate < '2009-05-30'I use the view in Excel, where I also have written the date (called ExcelDate).Is there a way in tSql to write something like Select ExcelDate from monthreport.xlsI am using Sql 2005 and Excel 2007RegardsPeter |
|
|
Mangal Pardeshi
Posting Yak Master
110 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
tSQL to get info from Excel