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. sqlgrade1

    How to export data automatically?

    Hi, I am trying to create a job to export data from a view every night automatically. my problem is is there a function i can call to export the data? i know i can manually export the data to a file, but is there a function i can use?
  2. sqlgrade1

    HELP!!! how to convert a string to number?

    hi, can somebody help me to solve this problem? first, declare 2 variables declare @num int declare @str varchar(255) then set the varchar variable to '100/10' set @str = '100/10' is there anyway to assign a value to @num using @str, so that @num has a value 10?? set @num =...
  3. sqlgrade1

    Is Last() function removed from sql 2000?

    hi, i am trying to run this query on sql 2000 server: SELECT LAST(birthdate) AS LastBirthDate FROM MediCarePatients ORDER BY age and server returned this msg to me: 'LAST' is not a recognized function name. i am kinda new to sql 2000 server and is the LAST function removed...
  4. sqlgrade1

    Execute a function within a string. Possible?

    Thanks. i missed that 'select'....
  5. sqlgrade1

    Execute a function within a string. Possible?

    here is a tricky question. let's say i have a string. declare @functionstring varchar(255) set @functionstring = 'getdate()' is there a way to execute this string?

Part and Inventory Search

Back
Top