Viewing 15 posts - 226 through 240 (of 485 total)
So you want to be able to have 2 different types of record in one file.
i.e
Patientcol1,Patientcol2,Patientcol3
responsecol1,responsecol2,responsecol3,responsecol4,responsecol5
If you have the same number of columns that will be fine. convert all the...
November 13, 2002 at 3:40 pm
What I am trying to get at is that you are populating the temp tables and then joining to them. If you stick with this option then you will should...
November 13, 2002 at 3:09 pm
Why is UNION out of the question.
You can insert the data into a table and then select it out.
How are you plannig to get the ascii output
Simon Sabin
Co-author of...
November 13, 2002 at 3:00 pm
It depends on how your client manages errors. But often the client responds to the first error and does not complete the rest of the code.
This can be forced...
November 13, 2002 at 2:57 pm
Having looked at this it can be written as one query. What are the volumes in company, contact and address. You haven't got an index on the temp tables.
Simon Sabin
Co-author...
November 13, 2002 at 2:54 pm
You should also use the username in your object names i.e devREDe.dbo.tbl_Company
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 13, 2002 at 2:13 pm
What do you mean by batch if you are not using SQL.
If you want to call a com component then use DCOM. Register the dll and then set it to...
November 13, 2002 at 2:10 pm
This is because at parse time the table does not exist. You should split this into seperate stored procedures,
Main SP creates tables and calls the sub sps
Sub SP1 populates company,...
November 13, 2002 at 2:01 pm
Can you post the query. I find that if the query is a poor performer then it can be pot luck on whether it is quick or slow.
Simon Sabin
Co-author of...
November 13, 2002 at 1:57 pm
if you just want parent child then join back to the table
If you want unlimited then you have to populate a temporary table.
i.e populate records with a parent of 0...
November 13, 2002 at 1:55 pm
Wow I never new about set context_info. I really like it, we have a real fudge in place at the moment.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 13, 2002 at 10:30 am
You need to include all parts of the 4 part name in the call i.e. server.database.user.object
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 13, 2002 at 10:23 am
You can just use the UNC path in the maintenance plan or backup wizards. The backup device is not required.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 13, 2002 at 9:27 am
Are you calling these from the same instance of the application. If you have any component whether it is the client or an intermidary dll that is not mulit threaded...
November 13, 2002 at 9:10 am
In te past with have not fired triggers for specific users and user suser_sname() to conditionally run the trigger code.
i.e
IF suser_sname() <> 'MyUser'
BEGIN
do stuff in
...
November 13, 2002 at 9:03 am
Viewing 15 posts - 226 through 240 (of 485 total)