Recent content by rac2

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

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

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.

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

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

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

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

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

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

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.

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

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

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

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

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