RSS Forums RSS

a simple application

Please support our MS SQL advertiser: Programming Forums
Reply
Posts: 48
Reputation: etc123 is an unknown quantity at this point 
Solved Threads: 0
etc123 etc123 is offline Offline
Light Poster

a simple application

  #1  
Dec 1st, 2008
AddThis Social Bookmark Button
Reply With Quote  
Posts: 1,157
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 133
dickersonka dickersonka is offline Offline
Veteran Poster

Re: a simple application

  #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  
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

  #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  
Posts: 1,157
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 133
dickersonka dickersonka is offline Offline
Veteran Poster

Re: a simple application

  #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
select SYSTEM_CODE, DATE_FIELD
where DATE_FIELD >= convert(datetime, '2008-12-1 12:00', 120)
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  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.



Views: 444 | Replies: 3 | Currently Viewing: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 10:16 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC