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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dimplekv

  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...
See more

Part and Inventory Search

Back
Top