Search results for query: *

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

...together with the item repaired, then join three tables as I show in my code above, Jobs, RepairedThing, ThingDetails. Or using the names in my code above, SELECT j.*, rb.*, b.* FROM Jobs j JOIN RepairedCircuitBoard rb ON rb.job_id = j.JobID JOIN lower_assembly b ON b.assemblyID =...

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

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.

...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 ... or SELECT * FROM tAGProjects JOIN ProjectClients pc ON ... in your query. I know of a couple of...

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

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 .

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