General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
>Are you doing something else in your routines, such as updating existing fields on the passed in table instead of getting the data through select/joining two files? So I might make a blank field for the company name in the main SP and then pass the #tempfile to the 2nd SP to fill the company field in?
What I would do, is create ALL the fields I will need in the initial temp file... then, susequent SP's can just add this data to the existing records.
BOb
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only