Stored procedure may return results via output parameters, output parameters+recordset, multiple recordsets, temp table(s), etc.

Metadata for which of these options you want to find?

All aliases assigned in outer queries, are...

CREATE TABLE ResultSetYeildingProc (...)

INSERT INTO ResultSetYeildingProc

exec usp_myResultSetYeildingProc

SELECT * FROM ResultSetYeildingProc

I believe error explains itself.

2 or more ID's have the same description.

Run

[Code]select COUNT(id), description

from tblProgram

GROUP BY description

HAVING COUNT(id) > 1[/Code]

and see which description(s) is an offender.

P.S. You should...

IF @@ROWCOUNT > 10 -- assume that normal query to affect not more than 10 rows

ROLLBACK

ELSE

COMMIT

For this kind of files it's better to use ODBC drivers.

They read those strings with identifiers properly.

I created text file TestInsert.txt in the folder C:\TextFiles (local to the SQL Server...

It's acceptable if number of rows never gonna exceed 1000.

Then it's gonna be another topic in "Performance" forum.

If you really cannot trim the ID's on insert (did you think about...

All of you are wrong.

Using "," as delimites is an error waiting to happen.

mdjtlj, ask you supplier to build a test file containing '19" Monitor'.

Then try to process that file.

You need to pinpoint the row(s) for UPDATE.

I guess your conditions in WHERE clause are such they cause table/index scan and lock all scanned records.

1st thing you need to try...

SQL Server is not a text editor.

It's Relational Database Management System.

You have to choose:

- either to store you data in proper relational database and use RDMS to manage it;

- or...

Schedule a job for the next second.

Job must be created earlier. Trigger just should schedule it for one-off execution as GETDATE() + 1s.

I use to think.

QA is a front end application.

The only difference essential (in our...

So, it gives you the answer:

All the time is spent on uploading data to front end.

There is nothing to improve in SQL Server performance.

Improve your upload channel.

Or don't store blobs...

Because it takes about a minute to execute that query you may add BatchStarted event in your trace and try to catch its SPID in master..sysprocesses while it's being executed.

No...

How long does it take to execute the version of query I posted?