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 SkipVought 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. forecasting

    Can you change users within a stored procedure?

    the databases are on the same server and the user just doesn't have rights to the other database. Since it appears from your answers that you can't change the connection string within a stored procedure, it appears y best best is to 'grant insert permission on that table'. Thanks for your help!
  2. forecasting

    In 1 or in 2 tables?

    What is efficient? If all you need to do is know the status of the employee, a simple boolean field (EmployeeStatus) solves the problem. Then you can add the field in a WHERE clause and get only the records you want (including any linked tables). And if you are searching for a person by name...
  3. forecasting

    Can you change users within a stored procedure?

    I have two databases in the same instance of SQL Server, DB1 and DB2. I connect to each database with a separate login that is not shared between databases (login1 for DB1 and login2 for DB2). When running a particular stored procedure on DB2 I want to insert a record on DB1. I can do this...
  4. forecasting

    Syntax for IN clause when used in Stored Procedure

    Alas! I was hoping for something easier. Sooner or later, every good idea degenerates into work. Thanks for the answer.
  5. forecasting

    Syntax for IN clause when used in Stored Procedure

    I think what you are saying is to insert the values into a temporary table in order to use them. Am I correct?
  6. forecasting

    Syntax for IN clause when used in Stored Procedure

    I am trying to write a stored procedure where I can pass in the criteria as a single string. For example, DECLARE @INclause nvarchar(20) SET @INclause = '''WA'',''CA''' SELECT City, State FROM Atlas WHERE State IN (@INclause) SQL does not interpret the @INclause as two criteria. Does...
  7. forecasting

    Does meta data list a tables last update time

    Is it possible to query meta data to get the last update time and date for all tables in the database
  8. forecasting

    ASP : global.asa file connectivity problem with sql server

    on logout if you call session.abandon variables are not destroyed until the script you are executing is finished. since no script is executing when timeout shuts the session down, I'm not certain the case is the same. is your connection string stored in the session object? if it is, have your...
  9. forecasting

    How to get mouse coordinates

    I found a method to work. <BODY onmousemove="window.name = window.event.x + '|' + window.event.y"> My vbscript then gets the value in "window.name" when it traps a double_click event. Is there any reason, however, that "window.name" is a bad place to store this value? If that is so, is...
  10. forecasting

    ASP : global.asa file connectivity problem with sql server

    I don't know the answer, but if I had to guess I would assume that the session_onend triggered after the session was closed. If so, you're connection string is gone. What code are you trying to execute?
  11. forecasting

    ASP : global.asa file connectivity problem with sql server

    I found this KB article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;175671 "CAUSE Microsoft Windows NT Server is denying access to the SQL Server. This error can be caused by the way Users, Groups, Rights, and Permissions are configured. Specifically, Microsoft Internet Information...
  12. forecasting

    How to get mouse coordinates

    From within a web page
  13. forecasting

    How to get mouse coordinates

    Does anyone know how to get the screen coordinates of the mouse with vbscript? I tried "window.event.screenX", but get an error message telling me "Object required: window.event
  14. forecasting

    Recover MDF File

    Is it possible to recover a database from its mdf/ldf files? My OS was corrupted and I had to reinstall SQL Server on my work machine. I have the .mdf files but no .bak.
  15. forecasting

    TreeView scroll to first node

    Thanks I also found that I had to select the root to get to the top node once I got to the top level node without a parent.
  16. forecasting

    TreeView scroll to first node

    I am building a treeview from a list that requires building the children before the parents. I seem to have the reconstruction of the Tree down pretty well, but when I open the list I am not at the first node. What's more, the first node isn't even shown on the screen. Since I seem to have...
  17. forecasting

    Trying to pass TreeView Node...but type mismatch?

    D'Arcy, Don't know if you had any luck, but I found that the Nodes parameter does not work with Windows Common Controls v6, only with v5. If you previously used the nodes paramete, you might want to see what the recent version of TreeView is that you are using. The way around it is to declare...
  18. forecasting

    Looped insert stops prior to meeting condition

    Once @datestring gets beyond the intitalization, it pulls the record from the database and includes the time. So I don't think that is the cause. I never could figure out why it wouldn't work. Eventually, I converted the sql to a stored procedure and executed that. All of the records get...
  19. forecasting

    I am trying to insert a time series

    Sorry about being vague. My question is whether I have failed to configure ADODB.Command properly and that is the reason it fails to insert the proper number of records. Is there a property with ADODB.Command that would cause it to exit a While loop before its condition is met?
  20. forecasting

    I am trying to insert a time series

    I am trying to insert a time series into a table. The table consists of two fields, a time stamp that increments 15 minutes for each record and a second time stamp that is 15 minutes later than the first stamp. TT15_Stamp TT15_Stend 1/1/2001 00:15 1/1/2001 00:30 1/1/2001 00:30...

Part and Inventory Search

Back
Top