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!

  • Congratulations Wanet Telecoms Ltd 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: dusanv
  • Content: Threads
  • Order by date
  1. dusanv

    Cannot save changes to IMPORT SPECIFICATION

    I have an import specification for importing a fixed width text file. The record layout of this file changed and I'm trying to update the import specification. I am able to edit the specification (add and rearrange fields), however, when I hit the save button all my modifications are...
  2. dusanv

    Executing a Stored Procedure from a View

    Hello, I tried to follow a workaround from some book for executing sp's from a view and created a linked server entry called LOOPBACK on my server that refers back to itself. Then I tried to create a view that has this statement: SELECT * FROM OPENQUERY(LOOPBACK,'EXEC dbo.sp_test') However...
  3. dusanv

    Transferring Import/Export specifications from one db to another

    Hello, Is there a way to transfer Import/Export specifications from one Ms Access database to another? Thanks, Dusan
  4. dusanv

    MAX function not working?

    Consider the following table: SSN Record Name Member EffDate ENREFFDT 123456789 GCRDEVNT WORK 6/6/2002 20020603 123456789 GCRDEVNT WORK 6/8/2002 20020608 555555555 GCRDEVNT WORK 5/8/2002 20020603 555555555 GCRDEVNT WORK...
  5. dusanv

    Exporting Message Rules in Outlook Express

    Does anyone how to transfer existing Outlook Express message rules to the instance of Outlook Express on another machine without doing it manually?
  6. dusanv

    View that is parsing out a column

    Hello, I have a table that would look like this simplified: EmpId Data 1 Name|Dusan|Title|Programmer| every odd token in Data column string is a field name, and every even one is a field value. So, Name=Dusan, Title=Programer. What I need to do is create a View...
  7. dusanv

    Concatenation/Bookmark Lookup/Constant Scan

    Our custom application is running very inefficiently on the SQL server. After doing execution traces, we found the following trace as the most expensive (always the same trace but with different parameters): Execution Tree -------------- Top(1) |--Concatenation...

Part and Inventory Search

Back
Top