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 |
lsy
Yak Posting Veteran
57 Posts |
Posted - 2007-02-25 : 22:37:24
|
How can i query record from certain work week? |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-25 : 22:41:20
|
Define your work week ?Post your table structure, some sample data and result that you want. KH |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
lsy
Yak Posting Veteran
57 Posts |
Posted - 2007-02-26 : 01:28:32
|
MyDate as Date/Time... it will show as "mm/dd/yyyy hh:mm:ss am" format...then i need to query the record by work week. |
 |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-26 : 09:56:14
|
quote: Originally posted by lsy MyDate as Date/Time... it will show as "mm/dd/yyyy hh:mm:ss am" format...then i need to query the record by work week.
Well, that clears things up. CODO ERGO SUM |
 |
|
|
|
|