What I've done is write a very specific query to return one record/row, however I would like the results for that query pasted into the spreadsheet from top to bottom rather than left to right. I know this is 90 degrees from what we think it should be but it is easier for the user to comprehend...
I'm a SQL developer trying to get results returned in a column format rather then being returned in a row. There must be a property that changes the default from row to column, can anyone help me?
I have written a pkg to read a file from a directory on the DB server. I've created an ActiveX script to use FSO to determine if any files exist in the directory. When running the DTS pkg using the play button, the script will run ok however, when I use the dtsrun utility (within a Job) the pkg...
Did you ever get an answer to your question? I am getting the same thing. I'm trying to create a view and as part of the query I'm using the EXISTS statement (which I've used in other views) If I remove this statement the view create without an issue however with it I get the same error.
Any...
Yes, because of the following scenario. Where Key1b is the sequence number I'm creating and Key1a and Key1b together make the primary key.
Key1a Key1b
Case 1 1
Case 1 2
Case 1 3
Case 2 1
Case 2 2
Case 3 1
I am using a trigger to create a sequence number, the secondary field on a primary key. The trigger works when I manually input records into the table but I get the following error when I use an INSERT/SELECT : Server: Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint...
I've written a macro to export a hotfile to a specified path, however the export doesn't produce anything anywhere. However, if I leave off the path and leave just the name, the hotfile is produced in the winnt\system32 directory. See the code below. If anyone has any advise please let me...
I have a need to run two batch threads concurrently; on the completion of these two threads I need to start a job. Of the two threads one will not necessarily end before the other and both have to complete successfully before the next job is started. Does anyone have any suggestions how to use...
I have a job step that runs a vb exe, process exit code is set to zero, however if the vb exe fails the step doesn't capture the failure and continues as a success. I've tried raising an error from within the vb code, this still didn't work. Does anyone have any suggestions on how to make this...
I am using odbc to connect to DB2 on the mainframe. My ODBC configuration states that MTS is the TP Monitor. However when I run two simple queries in one transaction and end successfully (run setcomplete) and then try to do an insert I get the error message: only one...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.