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 derfloh 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: *

  • Users: rac2
  • Order by date
  1. rac2

    Cobine tables' definition

    Use the DTS wizard with this query. SELECT T1.A, T1.B, T1.C, T1.D, T1.E, T2.F, T2.H FROM Table_1 T1 JOIN Table_2 T2 ON T2.A = T1.A With this query the DTS wizard will create a new table with columns A, B, C, D, E, F, and H. The values in columns A, B, C, D, and E will be from...
  2. rac2

    Changing the data source/destination of a package

    A package [call it pkgA] that runs another package [pkgB] actually runs a version of the other package. When you update pkgB the version is not updated in pkgA, the calling package. You must change the version yourself in the Properties dialog for pkgA. Open the Properties dialog for the...
  3. rac2

    Lock table while DTS package runs

    Because the todo table is somewhat like a temporary table. Once the work is done, I dont want to keep it. TRUNCATE recovers disk space and is not loggged. So it is a bit more efficient than DELETE.
  4. rac2

    Lock table while DTS package runs

    I have a table of work to do. Rows are inserted by several different processes (web forms submitted). Once an hour a DTS package reads the table, exports to a text file, then TRUNCATEs the table. The package does not take much time to run but inevitably there will be an attempt to add a row to...
  5. rac2

    Execute Process with dynamic parameter

    How to specify a parameter for an Execute Process Task that takes its value from a global variable? I wish to run a batch command with a filename as an argument. The filename is generated by a date query in a global variable. The global variable is used for the data source. After the file...
  6. rac2

    UPDATE using an ItemTemplate

    But then I see the same query with parameters, not values, with a different approach that successfully updates the database. This approach uses the straightforward gridview with an edit command column. So I think the TextData from the SQL Profiler trace does not show the values, only the query...
  7. rac2

    UPDATE using an ItemTemplate

    When I check one of the radio buttons, SQL Profiler records this TextData. UPDATE [Alternative] SET [Status] = @Status WHERE [UANC_id] = @original_UANC_id I would think that the parameters should have been replaced by values before SQL Server saw the query. And that those values would be...
  8. rac2

    UPDATE using an ItemTemplate

    How to update the Status column when a radio button is checked? The Status column may have values 0,3,5, or 8. The initial display of rows in the gridview shows the appropriate radio button checked if the value is 3,5, or 8 and none are checked if the Status value is 0. I want to update the...
  9. rac2

    Query Question

    Suppose M < N. This implies there will be some values on the N side that cannot be matched with values on the M side because all of those will be taken. Suppose M > N. This implies there will be some values left over on the M side after matching up N of them. Suppose M=N. What would such a...
  10. rac2

    Query Question

    Is it actually an N:N relationship? Meaning each User is related to N Shifts and each Shift is related to N Users? What we would obtain from a cross-join, the Cartesian product. Or do you simply mean many to many? Cause if it truly is N:N then there can be a 1:1 set, otherwise not.
  11. rac2

    Data Files modification date

    This is a question about the physical file which stores the database, the .mdf file in particular. I notice that the dates Modified and Accessed shown by Windows Explorer file Properties do not match the activity in my databases. Databases which are continuously used and in which data is...
  12. rac2

    Update SQL Table

    I think this is not going to be easy. Is there a utility function in the Unidata system for synchronizing or replicating data? SQL Server has some capabilities like this, I have never used them. "correct" is probably too much to hope for. You might be able to get to "is the same". Is the...
  13. rac2

    Recommendation for Table structure

    The really essential thing about the Jobs table I suggest is that it does not have any column referring to the thing that is repaired. No thing_id and no thing_type. You would determine the type of thing repaired by the table in which the repair is stored. From there you would find the JobID...
  14. rac2

    Recommendation for Table structure

    Yes, those null values in certain kinds of rows in the Jobs table dont feel right. Neither does the introduction of a TypeOfJob column. It seems like the info in those optional columns dont really tell us about the job. If they are not attributes of a Job then maybe they need to be located...
  15. rac2

    Open and close windows

    Gosh, for a moment there I thought Tek Tips was wacked out, the Message box was nowhere to be seen. When you post code, use the Tecumsah markup tags for code. ...
  16. rac2

    Help with denormalizing data

    Is there a way in Access to export the results of a PIVOT query. If so, and you could produce a pivot table with one row per donor and one column per donation sequence number, then you might have it.
  17. rac2

    dynamic WHERE clause criteria is null, causes a problem

    I dont see any condition in this WHERE clause that refers to the ProjectClients table. Since you mention that table I would guess that you have JOINed it or that it is the basic table in the query. By this I mean there is something like SELECT * FROM ProjectClients pc JOIN tAGProjects ON ...
  18. rac2

    get a week range to record for each week?

    It can be difficult finding things which are not there. Somehow you must create a set of rows for each week. This is independent and separate from Registers or Marked. One way to do this would be to create another table called Weeks. It could have a single column named WeekNumber with 53...
  19. rac2

    VB Script to populate jscript web page shell

    Hmmm. JScript is used with ASP as is VBScript. ASP is an alternative to PHP. Could it be that you are looking for the ASP equivalent of fopen? This would be the FileSystemObject, associated objects and methods. Try the ASP forum forum333 .
  20. rac2

    IF Statement in SELECT Query

    "feasible" is an interesting word. It sort of implies that something can be done but that the cost would be prohibitive. Usually when we say that something is not feasible, we mean it is possible. But we dont want to do it. In the Microsoft SQL Server dialect of SQL, there is no such thing...

Part and Inventory Search

Back
Top