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 wOOdy-Soft 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 TWillard

  1. TWillard

    how to disable print output from within sp

    I have a tsql stored procedure that contains print statements. I was wondering if there is a tsql command that I can include in the stored procedure that would disable/enable these output statements? Sometimes, I want to see the output like when I am developing in the procedure. However, I...
  2. TWillard

    converting value of float out of exponential notation

    Thanks George! Either cast or convert works, so long as you specify the scale and precision. Then you have the possibility of trailing zeros to work with. 0.00000010000000000000 0.000000100 DECLARE @data float SET @data = '0.0000001' select cast(@data as decimal(20,20)) select...
  3. TWillard

    converting value of float out of exponential notation

    The following sql returns the following: "1E-07" How can I get the select @data to return the original value of '0.0000001' without the exponent being applied and displayed? DECLARE @data float SET @data = '0.0000001' select @data
  4. TWillard

    List Dependencies - Table Names within Query Definition

    I am working in an ms access environment with many tables and queries. It contains some linked tables and some access tables. The queries are built off of access tables, linked tables, and also other queries. I have vba code to loop through all query objects and display name, type, sql, etc...
  5. TWillard

    help with like query - table.column like '%table.column%' - ?

    Is there a way to use a like operator and both sides of the like equation are columns. Listed below are two examples of what I am thinking. Is there a way to achieve this logic in a standalone query, without having to write a script or procedure? select count(*) from table_a a where...
  6. TWillard

    execute oracle procedure from sql server tsql

    My problem was that the query was not returning rows. The procedure was designed with no input parameters, no output parameters and no returned rows. The oracle procedure when called was just executing stuff. I modified the procedure to return (o_table out dbms_output.chararr) and...
  7. TWillard

    execute oracle procedure from sql server tsql

    Thank you for the reply ESquared. However, I get the following error message. I can execute this same procedure with success using oracle's sqlplus. This procedure does not have parameters. Msg 7357, Level 16, State 2, Line 1 Cannot process the object "EXEC PR_TEST". The OLE DB provider...
  8. TWillard

    execute oracle procedure from sql server tsql

    I am trying to execute an oracle pl/sql stored procedure from within sql server via tsql. I have used linked servers many times to perform selects and updates from sql server to and from oracle. I am looking for tsql syntax to call oracle procedure. Thank You.
  9. TWillard

    VB.NET like equivalent

    Here is a nice online code conversion utility: http://labs.developerfusion.co.uk/convert/vb-to-csharp.aspx
  10. TWillard

    set focus to element in onchange ?

    <html> <script language=javascript> function change(obj) { var x; x = obj.options[obj.selectedIndex].value; if (x=="one") { document.forms[0].one.focus(); } if (x=="two") { document.forms[0].two.focus(); } if (x=="three") { document.forms[0].three.focus(); } } </script> <form>...
  11. TWillard

    Help formulating totals - max min average on data sheet

    This is great advise by everyone. I just tested out the steps that Zathras provided. I can tell that this is going to increase the productivity, which is exactly what I was looking for.
  12. TWillard

    Help formulating totals - max min average on data sheet

    I have an excel sheet that has 52 columns and 4000+ rows. The data in the sheet is raw data. I would like to add three rows at the bottom of my sheet to display max, min, and averages per each column of data. I know that I can click on the function button and manually build a single function...
  13. TWillard

    form submit prompts undesired login?

    I have a form built within fp that sends an email. If I access the page with an administrator account, then the form submits fine. If I access the page with a non-admin account then I get a login prompt. If I hit cancel the non-admin receives the following: You are not authorized to view this...
  14. TWillard

    maintenance plan - change owner?

    How can I change the owner of a maintenance plan?
  15. TWillard

    Format Hyperlink - alias?

    Using Crystal 10.... I have a hyperlink value from a stored procedure. This field is formatted as a hyperlink in crystal using 'Current Website Field Value'. The hint states "This option will automatically create a hyperlink based on the data that is stored in the field in your data source."...
See more

Part and Inventory Search

Back
Top