Results 1 to 2 of 2

Thread: usign getdate() in UDF

  1. 08-22-2003, 03:29 AM #1
    bhavna
    bhavna is offline Registered User
    Join Date
    Jul 2003
    Posts
    23

    usign getdate() in UDF

    i have to get the current data and time somehow in my udf which returns a table of 7 columns. using sproc is not helping, though i have successfully passed the getdate() value from the sproc to hte function but this is preventing me from selecting a particular column from the table which the function is returning.because now my function is called inside the sproc. in the sproc i have called it as 'select * from f1()'
    Reply With Quote Reply With Quote
  2. 08-22-2003, 05:43 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Can you post the function and sp?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules