View Single Post
Join Date: Aug 2008
Posts: 1,158
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 136
dickersonka dickersonka is offline Offline
Veteran Poster

Re: a simple application

 
0
  #4
Dec 1st, 2008
as you said before, you can import this into sql express with no problems correct?

you can do something like this
  1. SELECT SYSTEM_CODE, DATE_FIELD
  2. WHERE DATE_FIELD >= convert(datetime, '2008-12-1 12:00', 120)
  3. AND DATE_FIELD < convert(datetime, '2008-12-2 12:00', 120)

you can run this sql select, now its a matter of what you are familiar with to get it to a text file, you can do it with dts / ssis, c#, whatever else you may prefer
Custom Application & Software Development
www.houseshark.net
Reply With Quote