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 Mike Lewis 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: rq
  • Order by date
  1. rq

    Textcopy Login error

    I need guidance on resolving this issue. I'm trying to execute the Textcopy utility within the command prompt. I followed the syntax defined for Textcopy and encountered "SQL Server Message 18456: Login failed for user 'username'" and "DB-Library Error 10003: Login incorrect." messages. As...
  2. rq

    using WriteText to load a BMP image

    I have a SQL table that is used to store ID pictures. Field (called FldA) is an image data type that will store these pictures. I want to store bitmap files onto this table wherein each file represent an ID picture. Since I have the file names to these bitmaps and am aware of the folder where...
  3. rq

    precedence constraint question

    What task do you use to raise an error so that I can check the table for data?
  4. rq

    precedence constraint question

    In the DTS package I created, there exists a Transform Data task wherein a newly created SQL table is populated with data. Whenever this task is executed, results vary for this Transform Data task -- that means this newly created table could have several records at times or none at all. An...
  5. rq

    database still loading

    Our office has a SQL Server database called DbLive. We successfully backed up DbLive via Enterprise Manager. Then, accessing DbTest we wanted to restore with DbLive backup. A day later DbTest is still loading. How can I resolve this?
  6. rq

    sp_makewebtask and a For XML Explicit query

    The query I created has several Select statements bounded by the Union operator. This query uses the For XML Explicit clause. Query looks like the following... select 1 as tag, null as parent, '' as [Enterprise!1], null as [Properties!2!DataSource!element], null as...
  7. rq

    create XML export file within DTS

    I meant XML format, not AML format.
  8. rq

    create XML export file within DTS

    I want to create a DTS package that will convert SQL 2000 data into an XML format. As an fyi, I figured out how to extract the data using the SELECT...For XML Explicit statement. What must I define within this DTS package, in terms of setting up a task and/or connection, so that so that the...
  9. rq

    XML declaration statement

    I created a Select statement using the For XML Explicit clause to convert SQL data into an XML format. As you are aware the XML declaration statement -- <?xml version ="1.0" encoding="UTF-8"?> must be inserted before defining the root element. How do I define the XML declaration statement with...
  10. rq

    traverse data table via stored procedure

    Yes, the value will be different for each record. Thus, the user-defined function is what I'm looking for. How do you call a user-defined function within an Update statement? Is it something like this -- Update tablename Set fieldname = functionname()
  11. rq

    traverse data table via stored procedure

    I'm aware of that approach. The issue is I need to update the field using a stored procedure. This stored procedure genrates a value. Can the SET clause (of the Update command) accept a call to a stored procedure?
  12. rq

    traverse data table via stored procedure

    What is the alternative if cursors are not the way to traverse the whole table for an update?
  13. rq

    traverse data table via stored procedure

    I am required to populate an integer field using a stored procedure. This field resides in an SQL table that contains thousands of records. Normally I would use an UPDATE statement to perform the task of filling in the value for the whole table. What is the efficient solution to this? I'm...
  14. rq

    using SP within DTS for integer field

    Normally, I would take that route. But the stored procedure that will be called keeps track of the integer numbers issued. What I didn't mention earlier is that I'm converting data from one application to another wherein the latter application uses this stored procedure to generate unique...
  15. rq

    using SP within DTS for integer field

    The number is a unique integer ID.
  16. rq

    using SP within DTS for integer field

    I created an SQL table that contains an integer field, which needs to be populated via usage of a stored procedure. The store procedure generates a unique number that will be used as a link id in another table. That said, how is this stored procedure defined within a DTS package?
  17. rq

    searching for columns

    How can you access syscolumns?
  18. rq

    searching for columns

    I'm in the process of integrating 2 apps that use SQL Server 2000. Is there a function or stored procedure that can tell me if a column name is used in another table? E.g., the purchase order id exists in the sales history table; I would like to know if this column name is referred to in...
  19. rq

    using isnull() for date fields

    Thanks, BugSlayer !!! That did the trick...
  20. rq

    using isnull() for date fields

    Corran007...I created a view that is used by Data Transformation Services to export results into a dbf format. Within that view, I would like to represent NULL dates as a blank date field.

Part and Inventory Search

Back
Top