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