| | |
a simple application
Please support our MS SQL advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation:
Solved Threads: 137
lol another tip, post what you need in this forum in your next post
but, lets start here, what are you having trouble with?
but, lets start here, what are you having trouble with?
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
•
•
Join Date: May 2008
Posts: 48
Reputation:
Solved Threads: 0
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?
Any recommendations on a language that would make this task very easy?
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation:
Solved Threads: 137
as you said before, you can import this into sql express with no problems correct?
you can do something like this
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
you can do something like this
MS SQL Syntax (Toggle Plain Text)
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
www.houseshark.net
![]() |
Similar Threads
- I want to get started learning a programming language (Computer Science)
- Error Running Web Application (ASP.NET)
- "breaking up" your application (C++)
- Developing SQL Server 2000 (MS SQL)
- Simple character change in a char* error (C++)
- Simple VB application (Visual Basic 4 / 5 / 6)
- Delphi 7 - How to create a simple tool? (Pascal and Delphi)
- a simple C program to create/open/write/close files generaing basic arithmetic ops (C)
- Applet or Application? (Java)
Other Threads in the MS SQL Forum
- Previous Thread: Displaying Data
- Next Thread: Error In trigger.
| Thread Tools | Search this Thread |






