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 Chriss Miller 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. Invicta

    Editing properties for multiple Exchange 5.5 users

    Hi, hope someone can help with this! My small team supports several organisations on one Exchange 5.5 server. As the result of a name change, I need to change the "Company" field for a sub-set of users. Even though it's a sub-set there are still 400 accounts so I really don't want...
  2. Invicta

    How do I call an MS-SQL stored procedure from Javascript?

    Thanks Nick. I could come back to the same page but with request("varname") populated, maybe? I was hoping for a solution where "onblur" calls a javascript function that itself invokes an MS-SQL stored proc and uses the returned value to pre-poulate the input box using...
  3. Invicta

    How do I call an MS-SQL stored procedure from Javascript?

    As a learning exercise I'm writing a small application but I've hit a small problem and I'd like some help. I have a form. On the form is a selection box. When the user selects one of the options the cursor moves onto the next input box. The bit that's missing is the bit that pre-populates...
  4. Invicta

    How Do I Learn MS SQL and What Is With This Server Stuff ??

    Hi. That's a lot of questions. SQL is "Structured Query Language" and it is used to query a database. It's a little like a programming language but it is very specialised. An SQL Server is a server running a database management system (or database engine) that responds to SQL...
  5. Invicta

    SQL Update Question...

    You're right.&nbsp;&nbsp;I did say it was an easy solution!<br><br>You need a more sophisticated approach if what you describe is possible.&nbsp;&nbsp;Do you need to know which records were affected every time this update is run or do you just need to know periodically?&nbsp;&nbsp;What will you...
  6. Invicta

    SQL Update Question...

    An easy solution would be to add an attribute, say &quot;marker&quot; (bit).&nbsp;&nbsp;You then modify your UPDATE statement to set the marker to 1 as well.&nbsp;&nbsp;When you've finished whatever you need the marker for, set it back to 0, ready for the next time.<br><br>UPDATE TIDS <br>SET...
  7. Invicta

    How can I pass the contents of an IN() statement to a sp?

    You could always pass each fam_id as a separate parameter but this would be more work than necessary and you'd be limited to 1024 fam_ids!&nbsp;&nbsp;<br><br>Another option would be send the string as a parameter and then use string functions to break it into individual components within the SP...
  8. Invicta

    Using a variable in Order By clause

    ...VARCHAR(30)<br>AS<br>&nbsp;&nbsp;&nbsp;DECLARE @CommandText VARCHAR(100)<br>&nbsp;&nbsp;&nbsp;@CommandText = 'SELECT * FROM test ORDER BY ' + @Orderby<br>&nbsp;&nbsp;&nbsp;EXEC (@CommandText)<br><br><br>In this example you pass the order as a parameter.&nbsp;&nbsp;The sp then creates a...
  9. Invicta

    Checking for Duplication

    Shirley, a select statement may be the answer you're looking for if you simply want to know if the key is booked out or not.<br><br>SELECT COUNT(*) FROM KeyLogOutTable WHERE KeyNumber = 123 AND SiteNumber = 56 AND ReturnedDate IS NULL<br><br>This statement will return 1 if the key is out, 0...
  10. Invicta

    stored procedures

    Hi Nancy, you've got us all curious with this one!<br><br>Another thought, are there any triggers on this table that may be running off and doing all kinds of things every time you insert a record, perhaps coming back to the spcl table?<br>
  11. Invicta

    Possible to concate strings for column names in UPDATE statment

    I'm still unsure of what you're trying to achieve.<br><br>The final comment in your last message seems to imply that you're trying to change the name of a column in a table.&nbsp;&nbsp;If this is the case then I'm unaware of any way of doing this other than rebuilding the table.<br><br>If you're...
  12. Invicta

    Possible to concate strings for column names in UPDATE statment

    I should've taken more notice of your subject.<br><br>I don't have access to SQL server to tell you what you're doing wrong but I can offer this:<br><br>Try<br><br>DECLARE @Command VARCHAR(100)<br>SET @Command = 'UPDATE table SET ' + @str1 + @str2 + ' = &quot;001&quot;'<br>EXEC (@Command)
  13. Invicta

    Possible to concate strings for column names in UPDATE statment

    What are you trying to do joblue?
  14. Invicta

    Can not update/add or edit records on database

    Rahel, when you say your client can &quot;see&quot; tables do you mean that you can see that the tables are there or do you mean that you can see the data within the tables?
  15. Invicta

    Efficient searches

    Ian, I'm unsure of why you need to reindex.<br><br>Can you not just SELECT &lt;fields&gt; ORDER BY &lt;field&gt;?<br><br>You could also try reducing the number of fields in your table.&nbsp;&nbsp;For only 100,000 records though the performance increase may be minimal unless your table is very...
  16. Invicta

    Where is my cursor?

    That's all for your comments.<br><br>Cal, special thanks for the extra info on where things sit DURING and on RETURN.
  17. Invicta

    How can I restrict row number of a union query result?

    Point noted Eduard.<br><br>I meant more natural as a statement, maybe I'm showing a little bias &lt;g&gt;.
  18. Invicta

    How can I restrict row number of a union query result?

    The SQL Server version is easier...<br><br>SELECT TOP 50 A, B, C ....
  19. Invicta

    Where is my cursor?

    When writing VB6 code to use stored proceedures on the server, is the result of the select (within the SP) stored on the server or passed to the client?
  20. Invicta

    Create a NEW Stored Procedure

    Doug, there are several ways you could do this but have you considered replication?&nbsp;&nbsp;Replication is all about what you want to do here - keeping two databases (or parts of them) synchronised.&nbsp;&nbsp;You can do this in real time or, and I suspect this is what you need, in snapshot...

Part and Inventory Search

Back
Top