a simple application

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

Join Date: May 2008
Posts: 48
Reputation: etc123 is an unknown quantity at this point 
Solved Threads: 0
etc123 etc123 is offline Offline
Light Poster

a simple application

 
0
  #1
Dec 1st, 2008
Reply With Quote Quick reply to this message  
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: a simple application

 
0
  #2
Dec 1st, 2008
lol another tip, post what you need in this forum in your next post

but, lets start here, what are you having trouble with?
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
Join Date: May 2008
Posts: 48
Reputation: etc123 is an unknown quantity at this point 
Solved Threads: 0
etc123 etc123 is offline Offline
Light Poster

Re: a simple application

 
0
  #3
Dec 1st, 2008
I have an excel spreadsheet that has two columns, a date column and a system code column. One of the applications that I use on a regular basis requires a system code, it changes each day. I want to write an app, batch file, etc., anything that upon launching will get the system code for the day(either by manually passing the value through some sort of GUI, or based off of the date on the computer) and return it to me in a text file that I can copy and paste.

Any recommendations on a language that would make this task very easy?
Reply With Quote Quick reply to this message  
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
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 Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC