Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dimplekv

    Renaming file with date

    Thank You! my email is dimplekv@yahoo.com. Thanks again.
  2. dimplekv

    Renaming file with date

    Thanks for the reply, but I need to run the batch file which would rename the file from abc.txt to xy_ddmmyy.txt where ddmmyy is the system date.
  3. dimplekv

    Output File

    Thanks for your response guys. I will be running the SQL command using Osql/isql to get the output. I cannot use VB as we don't have it. I am surprised that this feature is not available in MS SQL Server. I think many of us are using this with a work around. Thanks anyway.
  4. dimplekv

    Output File

    How can I write my result from 'select * from abc' to a text file on C drive with the name 'Result_061301.txt' where 6/13/01 is the system date? Any Ideas?
  5. dimplekv

    Renaming file with date

    How do I rename a file 'abc.txt' to 'xy_061301.txt' where 061301 is the date of the system in 6/13/01 format. I need to run a batch file which renames the file. Thanks in advance.
  6. dimplekv

    Passing Parameter to a Stored Proc

    Thank You very much.
  7. dimplekv

    Passing Parameter to a Stored Proc

    Hi Group, My stored proc is something like this: "select * from authors where state in (@State) and lastname like 'B%'" the following sql works fine "select * from authors where state in ('CA','PA','NJ') and lastname like 'B%'" I am unable to send the @state parameter from...

Part and Inventory Search

Back
Top